oracle dump与跟踪(三)
v$parameter u_dump
cross join v$parameter db_name
cross join v$process
join v$session
on v$process.addr = v$session.paddr
where
u_dump.name = 'user_dump_dest' and
db_name.name = 'db_name' and
v$session.audsid=sys_context('userenv','sessionid');
eg：
/fsdb1/oracle/admin/newccs/udump/newccs_ora_4862050.trc
4.2 执行event
alter session set events '10046 trace name context forever, level 1';
select count(1) from all_tables;
alter session set events '10046 trace name context off' ;
4.3 在查看newccs_ora_4862050.trc
$more newccs_ora_4862050.trc