Oracle Tips by Burleson

dba_sqlset views

DBA_SQLSET
------------------------------------------------------------------------------------
ID 		NUMBER
NAME 		VARCHAR2
OWNER 		VARCHAR2
DESCRIPTION 	VARCHAR2
CREATED 		DATE
LAST_MODIFIED 	DATE
STATEMENT_COUNT 	NUMBER


DBA_SQLSET_BINDS
------------------------------------------------------------------------------------
SQLSET_NAME 		VARCHAR2
SQLSET_OWNER 		VARCHAR2
SQLSET_ID 			NUMBER
SQL_ID 			VARCHAR2
FORCE_MATCHING_SIGNATURE	NUMBER
PLAN_HASH_VALUE 		NUMBER
POSITION 			NUMBER
VALUE 			ANYDATA
CAPTURED 			CHAR
SQL_SEQ 			NUMBER


DBA_SQLSET_DEFINITIONS
Synonym for DBA_SQLSET
------------------------------------------------------------------------------------


DBA_SQLSET_PLANS
------------------------------------------------------------------------------------
SQLSET_NAME 		VARCHAR2
SQLSET_OWNER 		VARCHAR2
SQLSET_ID 			NUMBER
SQL_ID 			VARCHAR2
FORCE_MATCHING_SIGNATURE 	NUMBER
PLAN_HASH_VALUE 		NUMBER
SQL_SEQ 			NUMBER
STATEMENT_ID 		VARCHAR2
PLAN_ID 			NUMBER
TIMESTAMP 			DATE
REMARKS 			VARCHAR2
OPERATION 			VARCHAR2
OPTIONS 			VARCHAR2
OBJECT_NODE 		VARCHAR2
OBJECT_OWNER 		VARCHAR2
OBJECT_NAME 		VARCHAR2
OBJECT_ALIAS 		VARCHAR2
OBJECT_INSTANCE 		NUMBER
OBJECT_TYPE 		VARCHAR2
OPTIMIZER 			VARCHAR2
SEARCH_COLUMNS 		NUMBER
ID 			NUMBER
PARENT_ID 			NUMBER
DEPTH 			NUMBER
POSITION 			NUMBER
COST 			NUMBER
CARDINALITY 		NUMBER
BYTES 			NUMBER
OTHER_TAG 			VARCHAR2
PARTITION_START 		VARCHAR2
PARTITION_STOP 		VARCHAR2
PARTITION_ID 		NUMBER
OTHER 			LONG
DISTRIBUTION 		VARCHAR2
CPU_COST 			NUMBER
IO_COST 			NUMBER
TEMP_SPACE 		NUMBER
ACCESS_PREDICATES 		VARCHAR2
FILTER_PREDICATES 		VARCHAR2
PROJECTION 		VARCHAR2
TIME 			NUMBER
QBLOCK_NAME 		VARCHAR2
OTHER_XML 			CLOB
EXECUTIONS 		NUMBER
STARTS 			NUMBER
OUTPUT_ROWS 		NUMBER
CR_BUFFER_GETS 		NUMBER
CU_BUFFER_GETS 		NUMBER
DISK_READS 		NUMBER
DISK_WRITES 		NUMBER
ELAPSED_TIME 		NUMBER


DBA_SQLSET_REFERENCES
------------------------------------------------------------------------------------
SQLSET_NAME 		VARCHAR2
SQLSET_OWNER 		VARCHAR2
SQLSET_ID 			NUMBER
ID 			NUMBER
OWNER 			VARCHAR2
CREATED 			DATE
DESCRIPTION 		VARCHAR2


DBA_SQLSET_STATEMENTS
------------------------------------------------------------------------------------
SQLSET_NAME 		VARCHAR2
SQLSET_OWNER 		VARCHAR2
SQLSET_ID 			NUMBER
SQL_ID 			VARCHAR2
FORCE_MATCHING_SIGNATURE 	NUMBER
SQL_TEXT 			CLOB
PARSING_SCHEMA_NAME 		VARCHAR2
PARSING_SCHEMA_ID 		NUMBER
PLAN_HASH_VALUE 		NUMBER
BIND_DATA 			RAW
BINDS_CAPTURED 		CHAR
MODULE 			VARCHAR2
ACTION 			VARCHAR2
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
PRIORITY 			NUMBER
COMMAND_TYPE 		NUMBER
FIRST_LOAD_TIME 		VARCHAR2
STAT_PERIOD 		NUMBER
ACTIVE_STAT_PERIOD 		NUMBER
OTHER 			CLOB
PLAN_TIMESTAMP 		DATE
SQL_SEQ 			NUMBER