[Webinar] Streamline your web hosting managementRegister Today


How to read and analyze  Trace files in oracle

Posted on 2008-02-07
Medium Priority
Last Modified: 2013-12-19
How can one analyze the information generated in bdump tracefiles ?
Question by:amolghadge
  • 2
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 900 total points
ID: 20840184
LVL 16

Assisted Solution

Milleniumaire earned 600 total points
ID: 20840368
Use the tkprof utility.

I have attached a code snippet for a simple unix script that processes the latest trace file in the Oracle dump directory (you will need to edit this directory in the script) and generates a readable trace file.

Save the code as a script and call it something like traceit then change the privileges e.g. chmod 775 traceit.

Don't forget to change the database password used by the tkprof call.

If you run the script without an argument it will process the newest file in the udump directory, otherwise it will process the file that you give to the script.

Of course, this assumes you are working on unix!
trace_dir=/sld/oracle/admin/udump   # Location of the trace files
if [ "$1" = "" ]
    infile=`ls -t $trace_dir/sld_ora*.trc | head -1`
echo Converting $infile
tkprof $infile $outfile explain=username/password sort=exeela
if [ $? -eq 0 ]
    echo "Trace output produced in file $outfile"

Open in new window

LVL 16

Expert Comment

ID: 20865828
Hi, just wondered if you had managed to successfully process your trace files.
LVL 74

Expert Comment

ID: 20874615
BDUMP trace files generally have memory dumps and other system-state type information in them are largely unusable to end users.

You can use the Metalink ORA-600 lookup tool to extract info from the dump.

As the previous posts mention UDUMP traces can be parsed and summarized with tkprof, you can also you Oracle's trace analyzer from Metalink.

You can session specific information in a BDUMP tracefile too, but it's still oracle internal calls like "kgxxxxxxxx" many (most?) of which aren't publicly documented.

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to recover a database from a user managed backup
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question