| TRACEFILE in report10g [message #517437] |
Tue, 26 July 2011 02:18  |
swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai
|
Senior Member |
|
|
Hi friends,
i want to tracing my RDF..so i get an information how much time query will take...i will do this PROGRAM -> TRACING -> given name of trace file.
But it will show me only log...i want complete information...how can i do it
|
|
|
|
|
|
| Re: TRACEFILE in report10g [message #517477 is a reply to message #517468] |
Tue, 26 July 2011 04:57  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
If I understood what you are looking for, "this" tracing is not the one you're after.
Put SRW.DO_SQL ('ALTER SESSION SET SQL_TRACE=TRUE');
On a database server, in a directory whose path can be found by running the following statement (as a privileged user), you'll find the trace file:SQL> select value from v$parameter where name = 'user_dump_dest';
VALUE
------------------------------------------------------------------------
D:\ORACLE\ADMIN\ORA10\UDUMP
Go to the database server. Locate the TRC (trace) file in the UDUMP directory (if you use MS Windows, Explorer will show it to you - sort files by date). Trace files have strange names, such as ORA10_ORA_3464.TRC.
Now open command prompt on the database server. Navigate to the UDUMP directory and run TKPROF (there are variations, this is just an example): tkprof ora10_ora_3464.trc trace.txt explain=scott/tiger@ora10 sys=no |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
