Name

query_instance_id — return an opaque integer id for the current query instance frame

Synopsis

integer query_instance_id( in depth integer);
 

Description

query_instance_id returns the in-memory address of the current query instance (or one of its ancestors) cast to an integer. depth is the number of caller frames to walk up; 0 selects the current frame. Returns NULL if no frame at the requested depth exists. The value is opaque and intended only for debugging and correlation with server traces.

Parameters

depth

Number of caller frames to walk up; 0 selects the current frame.

Return Types

An opaque integer identifier, or NULL if no frame exists at the requested depth.

Examples

Example 24.210. Id of the current query frame

SQL> select query_instance_id (0);
      

See Also

host_id, getrusage


© 1992 - OpenLink Software. All rights reserved.

Making Technology Work for You®