--查询回滚段信息

--10g之前，通过如下语句得到目标trace文件

col TRACE_FILE_NAME for a100
set linesize 200
select d.value || '/' || lower(rtrim(i.instance, chr(0))) || '_ora_' ||p.spid|| '.trc' trace_file_name
from (select p.spid
from v$mystat m, v$session s, v$process p
where m.statistic# = 1
and s.sid = m.sid
and p.addr = s.paddr) p,
(select t.instance
from v$thread t, v$parameter v
where v.name = 'thread'
and (v.value = 0 or t.thread# = to_number(v.value))) i,
(select value from v$parameter where name = 'user_dump_dest') d;

--mount状态下查询隐藏参数

ITPub博客

Oracle脚本收集【不定时更新】