amolghadge
asked on
How to read and analyze Trace files in oracle
How can one analyze the information generated in bdump tracefiles ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi, just wondered if you had managed to successfully process your trace files.
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.
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.