Database Reference
In-Depth Information
CHAPTER 8
■ ■ ■
Event 10079 and Oracle
Net Packet Contents
T
he undocumented event 10079 may be used to dump Oracle Net traffic to a trace file. It is
useful for quickly determining which SQL statements, PL/SQL calls, or SQL*Plus commands
send sensitive data such as passwords unencrypted.
Event 10079 is similar to Oracle Net tracing in that it dumps the complete contents of
network packet contents between database client and server. It is more convenient than changing
sqlnet.ora
to enable dumping of Oracle Net packet contents. Unlike
trace_level_client
in
sqlnet.ora
, it may also be used to enable packet dumps for database sessions that are already
established. Table 8-1 lists the supported event levels.
Table 8-1.
Supported Levels of Event 10079
Level
Purpose
1
Trace network operations to/from client
2
In addition to level 1, dump data
4
Trace network operations to/from database link
8
In addition to level 4, dump data
Case Study
The subsequent sections assume that the Advanced Security Option for the encryption of
Oracle Net traffic is not used. The
SQL*Plus User's Guide and Reference
does not state whether
passwords are sent encrypted when modified with the SQL*Plus command
PASSWORD
. Event 10079
may be used to find out.
87
