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
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
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
by Guy Harriso » Tue, 11 Mar 1997 04:00:00
If you mean trace files generated by SQL_TRACE, look in the Oracle ServerQuote:> 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 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
5. High level ODBC trace interpretation
6. 17367-MA-Boston-Metro West-Software Development-SYBASE-ORACLE-UNIX
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