Oracle Database Tips by Donald Burleson

Examining a Trace File

At first glance, a trace file can be pretty intimidating.  This section will provide some knowledge of a process just by examining a raw trace file.  Like the rest of this book, rather than just theory, this section will focus on real trace files.  The first file is named toy_ora_32622_find_me.trc.  This trace file and the others that will be shown could be generated by any of the methods previously discussed in this chapter.

 1 /app/oracle/admin/TOY/udump/toy_ora_32622_find_me.trc

 2

 3 Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production

 4 With the Partitioning, OLAP and Oracle Data Mining options

 5 JServer Release 9.2.0.3.0 - Production

 6 ORACLE_HOME = /app/oracle/product/9.2.0

 7 System name:    Linux

 8 Node name:      matthew

 9 Release:        2.4.18-3

10 Version:        #1 Thu Apr 18 07:31:07 EDT 2002

11 Machine:        i586

12 Instance name: TOY

13 Redo thread mounted by this instance: 1

14 Oracle process number: 9

15 Unix process pid: 32622, image: oracle@matthew (TNS V1-V3)

16

17 *** 2003-12-16 23:27:24.051

18 *** SESSION ID:(14.1906) 2003-12-16 23:27:24.049

19 APPNAME mod='SQL*Plus' mh=3669949024 act='' ah=4029777240

20 =====================

21 PARSING IN CURSOR #1 len=69 dep=0 uid=5 oct=42 lid=5 tim=1046525824269291 hv=1494869006 ad='5487450c'

22 ALTER SESSION SET EVENTS '10046 trace name context forever, level 12'

23 END OF STMT

24 EXEC #1:c=0,e=31785,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1046525824267259

25 WAIT #1: nam='SQL*Net message to client' ela= 16 p1=1650815232 p2=1 p3=0

26 WAIT #1: nam='SQL*Net message from client' ela= 2086543 p1=1650815232 p2=1 p3=0 

The above book excerpt is from:

Oracle Wait Event Tuning

High Performance with Wait Event Iinterface Analysis 

ISBN 0-9745993-7-9  

Stephen Andert 

http://www.rampant-books.com/book_2004_2_wait_tuning.htm