| how to enable tracing of sqlnet [message #51897] |
Thu, 20 June 2002 08:46  |
Radek
Messages: 33
Registered: April 2002
|
Member |
|
|
Hi,
I need to check sql queries that oracle designer is issuing into db. I set trace_level_client=4 in sqlnet.ora in designer's ORACLE_HOME but I do not see any files in ORACLE_HOMEnet80trace though. Is there something else I should do?
Thanks,
Radek
|
|
|
|
| Re: how to enable tracing of sqlnet [message #51898 is a reply to message #51897] |
Thu, 20 June 2002 09:07  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
Found this on MetaLink:
4.1 SQL*Net Activity Logging
----------------------------
Use the log option to check the SQL*Net activity. This option is controlled
by the file ORACLE_HOMENETWORKADMINSQLNET.ORA. Add the following lines to
this file to activate the SQL*Net activity logging:
trace_level_client = 16
trace_file_client = sqlnet
trace_directory_client=<path>
A file named sqlnet.trc is created in the directory described. This file
contains log information on all SQL*Net client-server activity. In most
cases, the file is very large and hard to read. However, with some effort,
you should be able to detect queries processed by SQL*Net and the results of
the queries. A query has approximately the following layout:
nspsend:00 00 00 00 00 00 00 00 |........
nspsend:00 73 65 6C 65 63 74 20 |.select
nspsend:2A 20 66 72 6F 6D 20 65 |* from e
nspsend:6D 70 0A 0A 01 00 00 00 |mp......
nspsend:00 00 00 00 00 00 00 00 |........
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
