Formatting .TRC Files

From: markag <member_at_dbforums.com>
Date: Wed, 09 Oct 2002 12:46:42 +0000
Message-ID: <1907570.1034167602@dbforums.com>

Hi,

Is there a way to format or otherwise summarize information from a .TRC file that is created when a problem occurs?

I'm not talking about using TKPROF after I have explain Planned a SQL statement with Times Statistics as that is for a specific SQL statement. These .TRC files, which end up in my UDUMP directory, look like this:

Dump file C:\Oracle\admin\#$%^&\udump\ORA01228.TRC Tue Oct 08 15:22:58 2002
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586 Oracle8i Release 8.1.6.0.0 - Production
JServer Release 8.1.6.0.0 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586 Instance name: %^&*$
Redo thread mounted by this instance: 1

Oracle process number: 41

Windows thread id: 1228, image: ORACLE.EXE

• 2002-10-08 15:22:58.740
• SESSION ID:(45.19870) 2002-10-08 15:22:58.724 DEADLOCK DETECTED

According to Oracle Docs, a utility called DUMPFMT exists on most systems to format this dump file, but I cannot locate this program.

I'm on Oracle8i Release 8.1.6.0.0 - Production Windows 2000

TIA,
Mark

--
Posted via http://dbforums.com

Received on Wed Oct 09 2002 - 07:46:42 CDT