Oracle Enterprise Manager Oracle Trace Developer's Guide Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index



Go to previous file in sequence Go to next file in sequence

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:

Hex Event

The Hex event logs hexadecimal packet dumps. The items associated with the Hex events are:

Time Event

The Time event logs network duration events. The items associated with start and

end of the Time event are:

CF3 Event

The CF3 event ties cross-product 3 to a unique connection ID. The items associated with the CF3 event are:




Go to previous file in sequence Go to next file in sequence
Prev Next
Oracle
Copyright © 1997 Oracle Corporation.
All Rights Reserved.
Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index