| Oracle Tracing [message #58197] |
Wed, 06 August 2003 09:29  |
raman
Messages: 66
Registered: February 2000
|
Member |
|
|
Hi folks,
Can anyone point me in the right direction for tracing in Oracle 8i? Thanks in advance...
|
|
|
|
|
|
| Re: Oracle Tracing [message #58212 is a reply to message #58197] |
Thu, 07 August 2003 07:51  |
shad
Messages: 50
Registered: October 2000
|
Member |
|
|
I assume you mean client tracing and on a windows client.
(1) Close all database connections you have from your PC
(2) On your PC go to oracle_homenetworkadmin
(3) add the folliwng two lines to the sqlnet.ora file
(i) trace_level_client = 16 (you could put SUPPORT instead of 16 if like). ==> This is the level of tracing you want-- I recommend 16 because you get details of packets plus the actual sql stetement
(ii) trace_directory_client = oracle_homenetworkadmin [[this is a directory on whihc the cli.trc or sqlnet.trc file will be created--> this is your trace file]]
(4) Connect to the database, do what you nromally do, and look in the oracle_homenetworkadmin for the trace file.
(5) Close all your database connecitons to read the trace file. You can not read the file if you still have database connections becaue they will still be writing to the file.
|
|
|
|
|
|
| Re: Oracle Tracing [message #58298 is a reply to message #58212] |
Wed, 13 August 2003 03:11 |
raman
Messages: 66
Registered: February 2000
|
Member |
|
|
Thank you for your advice. I have tried using the parameters you specify in the sqlnet.ora file, however, the trace file is not picking up any sql statements between my third party client application and my database?
Any ideas greatfully received.
Thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
