| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Tracing
search <gerry_at_village.uunet.be> schreef in berichtnieuws
3ee9b8d2$0$731$ba620e4c_at_reader0.news.skynet.be...
| I found it :
|
| edit the sqlnet.ora :
|
| TRACE_LEVEL_CLIENT = 16
| TRACE_FILE_CLIENT = CLIENT
| TRACE_DIRECTORY_CLIENT = C:\TRACE
|
This wil result in a file on the client machine c:\trace\client.trc with the
highest possible level of details about all sqlnet traffic between the
client and the database server process.
Is that what you want?
Or do you want a trace of the executed statements?
Then you do "alter session set sql_trace = true;" and look for a trace file
in the with parameter user_dump_dest specified directory at the database
server.
Use tkprof to get a more readable output including execution plans.
Received on Fri Jun 13 2003 - 16:06:00 CDT
 |
 |