Oracle Enterprise Manager Oracle Trace User's Guide

Library

Product

Contents

Index

Relating Data Between Products

• Methods for Passing Data Among Products
• What Is the Cross-Product Mechanism?

This chapter describes how Oracle Trace lets you relate an event in one product to an event in another product so that you can understand the full context in which the event occurred. The following topics are discussed:

• passing data using traditional methods

• passing data using the Oracle Trace cross-product mechanism

• descriptions of existing cross-product items

Relating events across products can sometimes be accomplished by explicitly passing items for those events through APIs and logging those items in both products for correlation at a later time.

For products that cannot explicitly pass items through APIs, Oracle Trace provides a mechanism called cross-product.

What Is the Cross-Product Mechanism?

If two products are instrumented such that one of them sets a cross-product number and the other one logs it, that information can then be correlated. Table 6-1 lists the cross-product items available. These items are the only items available for use as cross-product items. All other items pertain to only one product at a time and cannot be related across products. Some of the cross-product items are already associated with certain products, that is, some of the cross-product items are reserved for Oracle and others are for general use.

Table 6-1: Cross-Product Items

Item Name	Item ID	Datatype	Description
CROSS-FAC-1	115	4-byte integer	Application ID used by high-level applications such as Oracle Financials
CROSS-FAC-2	116	4-byte integer	Forms ID or additional application ID
CROSS-FAC-3	117	4-byte integer	SQL*Net connection ID
CROSS-FAC-4	118	4-byte integer	Oracle7 Server transaction ID
CROSS-FAC-5	119	4-byte integer	Hash ID of SQL statement
CROSS-FAC-6	120	4-byte integer	Reserved for use by Oracle Rdb7
CROSS-FAC-7	121	4-byte integer	Available for general use
CROSS-FAC-8	122	4-byte integer	Available for general use
CROSS-FAC-9	123	4-byte integer	Available for general use
CROSS-FAC-10	124	4-byte integer	Available for general use
Item Name	Item ID	Datatype	Description
CROSS-FAC-11	125	4-byte integer	Available for general use
CROSS-FAC-12	126	4-byte integer	Available for general use
CROSS-FAC-13	127	4-byte integer	Available for general use
CROSS-FAC-14	128	4-byte integer	Available for general use

To use the cross-product items you must perform the following steps:

1.

Assign cross-product items to eventsin the product definition.

2.

Assign the appropriate values to the cross-product items in the Oracle Trace cross-product routines.

Prev Next

Copyright © 1996 Oracle Corporation. All Rights Reserved.

Library

Product

Contents

Index