[Home] [Help] [Dependency Information]
Object Name: | _ALL_SQLSET_STATEMENTS_PHV |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SQLSET_NAME | VARCHAR2 | (128) | Yes | |
SQLSET_OWNER | VARCHAR2 | (128) | ||
SQLSET_ID | NUMBER | Yes | ||
CON_DBID | NUMBER | Yes | ||
SQL_ID | VARCHAR2 | (13) | Yes | |
FORCE_MATCHING_SIGNATURE | NUMBER | Yes | ||
PLAN_HASH_VALUE | NUMBER | Yes | ||
COMMAND_TYPE | NUMBER | |||
PARSING_SCHEMA_NAME | VARCHAR2 | (128) | ||
MODULE | VARCHAR2 | (64) | ||
ACTION | VARCHAR2 | (64) | ||
PLAN_TIMESTAMP | DATE | |||
BINDS_CAPTURED | CHAR | (1) | ||
SQL_SEQ | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT SQLSET_NAME
, SQLSET_OWNER
, SQLSET_ID
, CON_DBID
, SQL_ID
, FORCE_MATCHING_SIGNATURE
, PLAN_HASH_VALUE
, COMMAND_TYPE
, PARSING_SCHEMA_NAME
, MODULE
, ACTION
, PLAN_TIMESTAMP
, BINDS_CAPTURED
, SQL_SEQ
FROM SYS._ALL_SQLSET_STATEMENTS_PHV;
|
|
|