Oracle Enterprise Manager Oracle Trace User's Guide

Library

Product

Contents

Index

Oracle SQL*Net Release 2.3 Events

• Items Associated with Each Event

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

Table B-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 B-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-facility 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 B-2. Items specific to SQL*Net release 2.3 are described in Table B-3.

Table B-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 B-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

User, Admin, Dev, Error, and Fatal Events

Hex Event

Time Event

CF3 Event

Prev Next

Copyright © 1996 Oracle Corporation. All Rights Reserved.

Library

Product

Contents

Index