oracle 查看数据文件大小

set pages 1000 line 200
col tablespace_name for a15
col file_name for a60
--上面三行是在sqlplus执行时对输出格式进行调整用，用其他工具连时不用加
select * from (
  /**  Data Tablespace **/
  select 'Data Tablespace' tablespace_type, tablespace_name,file_id, file_name, bytes/1024/1024 "Size M", maxbytes/1024/1024 "Max Size M", autoextensible, online_status from dba_data_files
  union all
  /**  Temp Tablespace **/
  select 'Temp Tablespace' tablespace_type,tablespace_name, file_id, file_name, bytes/1024/1024 "Size M", maxbytes/1024/1024 "Max Size M", autoextensible, status 
  from dba_temp_files
) order by 1,2,3;

显示了数据文件初始化和最大使用量。

增加数据文件 一个使用完后增加

alter tablespace ly_mh add datafile '/data/oracle/oradata/orcl/ly_mh_02.dbf' size 10m autoextend on next 5m maxsize unlimited;

oralce 数据导入时查看正在运行的任务

set pages 1000 lines 300
col OWNER_NAME for a20
col JOB_NAME for a30
col OPERATION for a15
col JOB_MODE for a15
col STATE for a15
select OWNER_NAME,JOB_NAME,OPERATION,JOB_MODE,STATE from dba_datapump_jobs;