C
Oracle SQL*Net Events

This appendix describes events that have been instrumented in Oracle SQL*Net. The events are useful largely for debugging purposes.

Table C-1 lists the Oracle SQL*Net events instrumented for Oracle Trace. For more detailed descriptions, refer to the section for the event in which you are interested.

***Table C-1 Oracle SQL*Net Events***

Event	Description	Type of Event
User	User-level debug information	Point
Admin	Administrator-level debug information	Point
Dev	Developer-level debug information	Point
Hex	Hexadecimal dump of packet onto transport	Point
Time	Duration event for specific network events	Duration
CF3	Ties cross-product 3 to 8-byte connection ID	Point
Error	Debug information for errors	Point
Fatal	Debug information for fatal errors	Point

Specific kinds of information, known as items, are associated with each event. Oracle Trace has a standard set of items, called Resource Utilization items, that it collects by default for any instrumented application, including SQL*Net.

The standard Resource Utilization items are described in Table C-2. Items specific to SQL*Net release 2.3 are described in Table C-3.

Table C-2 Standard Resource Utilization Items

Item Name	Item ID	Description	Oracle Trace Datatype	Usage
UCPU	129	Amount of CPU time in user mode	Unsigned 4 bytes	Counter
SCPU	130	Amount of CPU time in system mode	Unsigned 4 bytes	Counter
INPUT_IO	131	Number of times file system performed input	Unsigned 4 bytes	Counter
OUTPUT_IO	132	Number of times file system performed output	Unsigned 4 bytes	Counter
PAGE_FAULTS	133	Number of hard and soft page faults	Unsigned 4 bytes	Counter
PAGEFAULT_IO	134	Number of hard page faults	Unsigned 4 bytes	Counter
MAXRS_SIZE	135	Maximum resident set size used	Usigned 4 bytes	Counter

***Table C-3 Oracle SQL*Net Release 2.3 Items***

Item Name	Item ID	Description	Datatype	Usage
Function_ID	1	Internal function name (MSB code) where message originated	Unsigned 4 bytes	MSB Code
Probe_ID	2	Line number in file where message originated	Unsigned 4 bytes	Level
Message	3	Trace information and any error information	ASCIW	MSB Code & Params
Hex_Dump	4	Hex data	ASCIW	Text
Trace_Masks	5	Vector bit array of different options	ASCIW	Level
Connection_ID	6	8-byte unique connection ID	Unsigned 8 bytes	Level
Duration_Type	7	Duration ASCII identifier	Unsigned 4 bytes	MSB Code
CROSS_FAC_3	138	Ties CF3 to 8-byte connection ID	Unsigned 4 bytes	Level

Items Associated with Each Event

The following sections describe each event in more detail and provide tables that list the items associated with each event. For item descriptions, refer back to Table C-3.

User, Admin, Dev, Error, and Fatal Events

The User, Admin, Dev, Error, and Fatal events are comparable to the events of the same names that SQL*Net tracing collected in previous releases. For each event, the function name and location within the code where the event took place is identified. The rest of the information collected about each event is similar but at different levels of granularity, depending on the parameters entered for the Message item. The items associated with the User, Admin, Dev, Error, and Fatal events are: