[Home] [Help] [Dependency Information]
Object Name: | DBA_SQLSET_STATEMENTS |
---|---|
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 | ||
SQL_TEXT | CLOB | (4000) | ||
PARSING_SCHEMA_NAME | VARCHAR2 | (128) | ||
PARSING_SCHEMA_ID | NUMBER | |||
PLAN_HASH_VALUE | NUMBER | Yes | ||
BIND_DATA | RAW | (2000) | ||
BINDS_CAPTURED | CHAR | (1) | ||
MODULE | VARCHAR2 | (64) | ||
ACTION | VARCHAR2 | (64) | ||
ELAPSED_TIME | NUMBER | |||
CPU_TIME | NUMBER | |||
BUFFER_GETS | NUMBER | |||
DISK_READS | NUMBER | |||
DIRECT_WRITES | NUMBER | |||
ROWS_PROCESSED | NUMBER | |||
FETCHES | NUMBER | |||
EXECUTIONS | NUMBER | |||
END_OF_FETCH_COUNT | NUMBER | |||
OPTIMIZER_COST | NUMBER | |||
OPTIMIZER_ENV | RAW | (2000) | ||
PRIORITY | NUMBER | |||
COMMAND_TYPE | NUMBER | |||
FIRST_LOAD_TIME | VARCHAR2 | (19) | ||
STAT_PERIOD | NUMBER | |||
ACTIVE_STAT_PERIOD | NUMBER | |||
OTHER | CLOB | (4000) | ||
PLAN_TIMESTAMP | DATE | |||
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
, SQL_TEXT
, PARSING_SCHEMA_NAME
, PARSING_SCHEMA_ID
, PLAN_HASH_VALUE
, BIND_DATA
, BINDS_CAPTURED
, MODULE
, ACTION
, ELAPSED_TIME
, CPU_TIME
, BUFFER_GETS
, DISK_READS
, DIRECT_WRITES
, ROWS_PROCESSED
, FETCHES
, EXECUTIONS
, END_OF_FETCH_COUNT
, OPTIMIZER_COST
, OPTIMIZER_ENV
, PRIORITY
, COMMAND_TYPE
, FIRST_LOAD_TIME
, STAT_PERIOD
, ACTIVE_STAT_PERIOD
, OTHER
, PLAN_TIMESTAMP
, SQL_SEQ
FROM SYS.DBA_SQLSET_STATEMENTS;
|
|
|