Databases Reference
In-Depth Information
-rw-r----- 1 oracle oinstall 976 Mar 21 21:36
ord_ora_4463.trc
-rw-r----- 1 oracle oinstall 958 Jun 21 22:08
ord_ora_4474.trc
-rw-r----- 1 oracle oinstall 1665 Mar 22 20:08
ord_ora_4529.trc
-rw-r----- 1 oracle oinstall 1048 Mar 14 12:29
ord_ora_9813.trc
-rw-r----- 1 oracle oinstall 39563 Jun 22 23:34
ord_ora_982.trc
-rw-r----- 1 oracle oinstall 1407 Mar 14 12:51
ord_ora_9843.trc
[oracle@oltp udump]$
Which trace file is the right one? The datestamp of each file helps to narrow
down the search, but there could be multiple users creating trace files at the same
time. Janice must join the
dynamic performance
views to retrieve the operating system process number, which Oracle uses in the
trace filename:
V$PROCESS
and
V$SESSION
select spid from v$process v, v$session s
where v.addr = s.paddr and s.username = 'HR';
SPID
------------
23342
1 row selected.
Given the operating system process number of 23342, Janice knows that she
needs to analyze the user trace file
ord_ora_ 23342.trc. However, when she
opens this trace file in Notepad, it is not very readable:
