-
How can i convert \udump\*.trc files into readable format
this will help me to debug the user dump and background dump processes.
Thanks in advance
from Anuj Pathak
india
-
use the TKPROF utility, see the docs for syntax, examples & more info.
[]s
Chiappa
-
Thanks JChiappa
When ever i run tkprof like
tkprof inputfile.trc output.txt
It always gives same output in output.txt as below copied though trc files are different in size from 10 kb to 5 mb
Waiting for yr reply
from Anuj
TKPROF: Release 8.1.5.0.0 - Production on Fri Feb 23 17:55:24 2001
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Trace file: orclsmon.trc
Sort options: default
********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
********************************************************************************
Trace file: orclsmon.trc
Trace file compatibility: 7.00.12
Sort options: default
3 sessions in tracefile.
0 user SQL statements in trace file.
0 internal SQL statements in trace file.
0 SQL statements in trace file.
0 unique SQL statements in trace file.
94147 lines in trace file.
-
In order to convert *.trc files in readable format ,please run the tkprof utility.It takes two arguments one name of the trace file and other ur output file name.
for e.g if ur trace file name is ora0001.trc run the following command
C:\tkprof ora0001.trc a.txt
this will create readable trace file.U can go through it to find the necessary information.
If any queries please write to me at rohitsn@hotmail.com
-
hi there
you gotta alter your initsid.ora parameter max_dump_file_size to a larger value as the current settings are to small hence oracle is not able to dump the entire trace file.hope it helps
hrishy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|