ora9i@cs_dc02:/ora9i/app/oracle/admin/csmisc/udump > ll -tlc
total 4432
-rw-r----- 1 ora9i dba 332995 jan 10 12:00 csmisc2_ora_22580.trc
-rw-r----- 1 ora9i dba 3168 jan 10 11:59 csmisc2_ora_20552.trc
-rw-r----- 1 ora9i dba 407133 jan 7 15:10 csmisc2_ora_2708.trc
-rw-r----- 1 ora9i dba 640 jan 7 14:48 csmisc2_ora_835.trc
-rw-r----- 1 ora9i dba 1590 dec 30 22:50 csmisc2_ora_16244.trc
-rw-r----- 1 ora9i dba 1308403 dec 30 22:44 csmisc2_ora_16033.trc
-rw-r----- 1 ora9i dba 616 dec 28 14:16 csmisc2_ora_2176.trc
-rw-r----- 1 ora9i dba 644 dec 8 18:22 csmisc2_ora_21083.trc
ora9i@cs_dc02:/ora9i/app/oracle/admin/csmisc/udump > mailx -s "csmisc2_ora_22580.trc" zhangdp@aspire-tech.com < csmisc2_ora_22580.trc
ora9i@cs_dc02:/ora9i/app/oracle/admin/csmisc/udump > mailx -s "csmisc2_ora_20552.trc" zhangdp@aspire-tech.com < csmisc2_ora_20552.trc
ora9i@cs_dc02:/ora9i/app/oracle/admin/csmisc/udump > exit
sql>
我们看到sid为30的会话,产生的跟踪文件(csmisc2_ora_22580.trc)为的主要内容是:
/ora9i/app/oracle/admin/csmisc/udump/csmisc2_ora_22580.trc
oracle9i enterprise edition release 9.2.0.4.0 - 64bit production
with the partitioning and real application clusters options
jserver release 9.2.0.4.0 - production
oracle_home = /ora9i/app/oracle/product/920
system name: hp-ux
node name: cs_dc02
release: b.11.11
version: u
machine: 9000/800
instance name: csmisc2
redo thread mounted by this instance: 2
oracle process number: 28
unix process pid: 22580, image: oracle@cs_dc02 (tns v1-v3)
*** 2005-01-10 11:31:49.416
*** session id:(30.24167) 2005-01-10 11:31:49.354
wait #0: nam='library cache lock' ela= 507258 p1=-4611686013547141416 p2=-4611686013691716064 p3=1301
wait #0: nam='library cache lock' ela= 505686 p1=-4611686013547141416 p2=-4611686013691716064 p3=1301
wait #0: nam='library cache lock' ela= 507678 p1=-4611686013547141416 p2=-4611686013691716064 p3=1301
wait #0: nam='library cache lock' ela= 507595 p1=-4611686013547141416 p2=-4611686013691716064 p3=1301
wait #0: nam='library cache lock' ela= 507880 p1=-4611686013547141416 p2=-4611686013691716064 p3=1301
wait #0: nam='library cache lock' ela= 507317 p1=-4611686013547141416 p2=-4611686013691716064 p3=1301
wait #0: nam='library cache lock' ela= 507703 p1=-4611686013547141416 p2=-4611686013691716064 p3=1301
wait #0: nam='library cache lock' ela= 507683 p1=-4611686013547141416 p2=-4611686013691716064 p3=1301
wait #0: nam='library cache lock' ela= 508265 p1=-4611686013547141416 p2=-4611686013691716064 p3=1301
wait #0: nam='library cache lock' ela= 507100 p1=-4611686013547141416 p2=-4611686013691716064 p3=1301
wait #0: nam='library cache lock' ela= 507684 p1=-4611686013547141416 p2=-4611686013691716064 p3=1301
wait #0: nam='library cache lock' ela= 505889 p1=-4611686013547141416 p2=-4611686013691716064 p3=1301
wait #0: nam='library cache lock' ela= 507731 p1=-4611686013547141416 p2=-4611686013691716064 p3=1301
wait #0: nam='library cache lock' ela= 507650 p1=-4611686013547141416 p2=-4611686013691716064 p3=1301
wait #0: nam='library cache lock' ela= 507604 p1=-4611686013547141416 p2=-4611686013691716064 p3=1301