Interpretation of trace files

Interpretation of trace files

Post by Andrea Pallott » Thu, 06 Mar 1997 04:00:00



Hi everybody!!

I need some help about Oracle trace files.
Where i can find  information about the contents of these files?

Please help me!!

Thanks in advance

Andrea Pallotta

 
 
 

Interpretation of trace files

Post by Rich Wood » Thu, 06 Mar 1997 04:00:00



> Hi everybody!!

> I need some help about Oracle trace files.
> Where i can find  information about the contents of these files?

> Please help me!!

> Thanks in advance

> Andrea Pallotta

Call Oracle Support.  You won't find trace file contents documented
anywhere outside of Oracle.
--
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.

 
 
 

Interpretation of trace files

Post by Guy Harriso » Tue, 11 Mar 1997 04:00:00




Quote:> Hi everybody!!

> I need some help about Oracle trace files.
> Where i can find  information about the contents of these files?

If you mean trace files generated by SQL_TRACE,  look in the Oracle Server
Tuning guide ("Appendix A: diagnostic and tuning tools" from memory).  You
could also checkout http://www.oreview.com/9604har.htm .

If you mean trace files generated by errors or from process or system state
dumps,  the best documentation is in the "Oracle Backup and Recovery
handbook" by R Velpuri,  Oracle Press.

----------------------------------------------------------------------
Guy Harrison                                                            

http://werple.net.au/~gharriso              
(61) 0419 377 964                                                              



Quote:> Hi everybody!!

> I need some help about Oracle trace files.
> Where i can find  information about the contents of these files?

> Please help me!!

> Thanks in advance

> Andrea Pallotta

 
 
 

1. deadlock trace interpretation

all:
I have follwing deadlock trace file.

my question:
1. what is ddl and parse locks ?

2. how to translate object handle (c000000020a80868),
                     waiting session(c0000000044de890),
                    block session(c000000006f10a70)
  to object_id or object name and more meaningful session number ?

thnx in advance
ted chyn  
================

A deadlock among DDL and parse locks is detected.
This deadlock is usually due to user errors in
the design of an application or from issuing a set
of concurrent statements which can cause a deadlock.
This should not be reported to Oracle Support.
The following information may aid in finding
the errors which cause the deadlock:
ORA-04020: deadlock detected while trying to lock object RTRAC.RYDERTRAC_EDI
--------------------------------------------------------
  object   waiting  waiting       blocking blocking
  handle   session     lock mode   session     lock mode
--------  -------- -------- ----  -------- -------- ----
c000000020a80868  c0000000044de890 c000000006f10a70    S  c000000004509e10 c0000
00006db8f60    X
c000000020a80a40  c000000004509e10 c00000000ab7a858    X  c0000000044de890 c0000
00008835d40    S
--------------------------------------------------------
---------- DUMP OF WAITING AND BLOCKING LOCKS ----------
--------------------------------------------------------
------------- WAITING LOCK -------------
----------------------------------------
SO: c000000006f10a70, type: 35, owner: c000000004759ee0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=c000000006f10a70 handle=c000000020a80868 request=S
call pin=0 session pin=0
user=c0000000044de890 session=c0000000044de890 count=0 flags=[00] savepoint=5114
044
LIBRARY OBJECT HANDLE: handle=c000000020a80868
name=RTRAC.ERRORDEFINITION
hash=abc79a96 timestamp=09-15-2002 03:26:53
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0501-0711 lock=X pin=S latch=0

2. Cyrillic to UNICODE conversion

3. DB2 ODBC trace log timing interpretation

4. Bitwise operations

5. High level ODBC trace interpretation

6. 17367-MA-Boston-Metro West-Software Development-SYBASE-ORACLE-UNIX-Implementatio

7. MDC file stats entry interpretation?

8. Add Quote : Sql Server 2000

9. File protection on SQL trace files

10. Backup control file to trace. can't find the trace file

11. ALTER DB BKP CTL FILE TO TRACE: how do you retrieve the trace file number in the dictionary ?

12. SQL Query Analyzer Server Trace vs SQL Profiler Trace