SQL> alter session set tracefile_identifier = 'night';
Session altered
Executed in 0 seconds
SQL> alter system dump datafile 4 block 32;
System altered
Executed in 0.047 seconds
[oracle@bogon udump]$ ls -l |grep night
-rw-r----- 1 oracle oinstall 8203 Jan 22 23:51 chent_ora_12306_night.trc
另:参数文件默认命名方式
sid_ora_spid.trc
查找spid:
SQL> select b.spid from
2 v$session a,v$process b
3 where a.paddr = b.addr
4 and a.audsid = userenv('sessionid');
SPID
------------
12306
Session altered
Executed in 0 seconds
SQL> alter system dump datafile 4 block 32;
System altered
Executed in 0.047 seconds
[oracle@bogon udump]$ ls -l |grep night
-rw-r----- 1 oracle oinstall 8203 Jan 22 23:51 chent_ora_12306_night.trc
另:参数文件默认命名方式
sid_ora_spid.trc
查找spid:
SQL> select b.spid from
2 v$session a,v$process b
3 where a.paddr = b.addr
4 and a.audsid = userenv('sessionid');
SPID
------------
12306
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22745099/viewspace-625817/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22745099/viewspace-625817/