1 查看所有数据文件
select file_name from dba_data_files
union
select file_name from dba_temp_files
union
select name from v$controlfile
union
select value from v$parameter where name=‘spfile‘
union
select member from v$logfile;
————————————————
2 查看正在运行的job
select
djr.sid sess,
djr.job jid,
dj.log_user subu,
dj.priv_user secd,
dj.what proc,
to_char(djr.last_date,‘MM/DD‘) lsd,
substr(djr.last_sec,1,5) lst,
to_char(djr.this_date,‘MM/DD‘) nrd,
substr(djr.this_sec,1,5) nrt,
djr.failures fail
from
sys.dba_jobs dj,
sys.dba_jobs_running djr
where
djr.job = dj.job
/