| sm_ahmeds |
Posted: Oct 09, 2007 02:52:21 AM |
Total Post: 53
Joined: Apr, 2007
|
Hi
How can i find in which dump directory the Trace file is generated.
Do i need to enable tracing at database level for Trace file to get generated. What does BDUMP,CDUMP,UDUMP actually mean and when does trace file gets generated in these directories.
Also how can i read the trace file
Thanks |
|
|
Mohammed Taj |
| Posted: Oct 09, 2007 01:02:45 PM | |
|
Total Post: 746
Joined: Jul, 2007
|
Check it UDUMP user dump area folder.
located : show parameter udump.
or
#oraclehome/admin/
Regards
Taj
|
|
|
|
|
shahul |
| Posted: Oct 11, 2007 05:36:23 AM | |
|
Total Post: 17
Joined: Sep, 2007
|
hi
The trace will b generated in udum directory.
And the trace file will be in unreadable format
To read you can use TKprof tool provided by oracle
|
|
|
|
|
sm_ahmeds |
| Posted: Oct 11, 2007 05:47:40 AM | |
|
Total Post: 53
Joined: Apr, 2007
|
Thanks Very much for the Reply
Please tell me when the trace file is generated in Bdump and Udump
|
|
|
|
|
vikhardba |
| Posted: Oct 13, 2007 04:53:45 PM | |
|
Total Post: 86
Joined: Apr, 2007
|
Yes, i understood that trace is in unreadable format, but how should i read it using TKPROF tool. Can you please let me know from basic.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |