|
Logging Option
|
Logging Level
|
Type of information logged
|
|
STATEMENT
|
LEVEL 1
|
Shows the sql statement and information on these sql operations:
 Transactions
Preparing a SQL statement
Describing a SQL statement
Opening and closing a SQL statement
Return status from the above operations
Prepare, Describe, and Close occur only once for each statement execution.
Level 1 shows the least amount of output data for the log.
|
|
LEVEL 2
|
The same information as that of Level 1 is logged and in addition, information on the SQL operation: executing SQL statement, once for each statement.
|
|
|
LEVEL 3
|
The same information as that of Level 1 is logged
|
|
|
LEVEL 4
|
Information that is logged for Level 1 and additionally the following:
Information on SQL operations like fetching Result Set data from the server, connection time steps including the authentication system
Note: Fetching occurs once for each block of Result Set data sent to the client. The Result Set data clould be sent to the client any number of times.
Level 4 shows the largest amount of output data for the log.
|
|
|
INOUT
|
LEVEL 1
|
No information is logged
|
|
LEVEL 2
|
No information is logged
|
|
|
LEVEL 3
|
Input parameters to a query or statement and output parameters from a query are logged
|
|
|
LEVEL 4
|
The input/output parameters of the display LOB are logged
|
|
|
QUERY_PLAN
|
LEVEL 1
|
Query and optimized query plan are logged
|
|
LEVEL 2
|
The same information as that of Level 1 is logged
|
|
|
LEVEL 3
|
The same information as that of Level 1 is logged
|
|
|
LEVEL 4
|
The same information as that of Level 1 is logged
|
|
|
EXEC
|
LEVEL 1
|
No logging is done
|
|
LEVEL 2
|
No logging is done
|
|
|
LEVEL 3
|
No logging is done
|
|
|
LEVEL 4
|
No logging is done
|
|
|
PRO_TABLESCAN_EVENT
|
LEVEL 1
|
The details about tables on which table scan was performed
|
|
LEVEL 2
|
The same information as that of Level 1 is logged
|
|
|
LEVEL 3
|
The same information as that of Level 1 is logged
|
|
|
LEVEL 4
|
The same information as that of Level 1 is logged
|
|
|
CACHE
|
LEVEL 1
|
No logging is done
|
|
LEVEL 2
|
No logging is done
|
|
|
LEVEL 3
|
No logging is done
|
|
|
LEVEL 4
|
No logging is done
|
|
|
MEMORY
|
LEVEL 1
|
No logging is done
|
|
LEVEL 2
|
No logging is done
|
|
|
LEVEL 3
|
No logging is done
|
|
|
LEVEL 4
|
No logging is done
|
|
|
PROC
|
LEVEL 1
|
No logging is done
|
|
LEVEL 2
|
No logging is done
|
|
|
LEVEL 3
|
No logging is done
|
|
|
LEVEL 4
|
No logging is done
|
|
|
Communication
|
LEVEL 1
|
No logging is done
|
|
LEVEL 2
|
No logging is done
|
|
|
LEVEL 3
|
No logging is done
|
|
|
LEVEL 4
|
No logging is done
|