Oracle Tips by Burleson

dba_sqltune views

DBA_SQLTUNE_BINDS
------------------------------------------------------------------------------------
TASK_ID 		NUMBER
OBJECT_ID 		NUMBER
POSITION 		NUMBER
VALUE 		ANYDATA


DBA_SQLTUNE_PLANS
------------------------------------------------------------------------------------
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
TASK_ID 		NUMBER
OBJECT_ID 		NUMBER
ATTRIBUTE 		VARCHAR2
STATEMENT_ID 	VARCHAR2
PLAN_HASH_VALUE 	NUMBER
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


DBA_SQLTUNE_RATIONALE_PLAN
------------------------------------------------------------------------------------
TASK_ID 		NUMBER
RATIONALE_ID 	NUMBER
OBJECT_ID 		NUMBER
OPERATION_ID 	NUMBER
PLAN_ATTRIBUTE 	VARCHAR2


DBA_SQLTUNE_STATISTICS
------------------------------------------------------------------------------------
TASK_ID 		NUMBER
OBJECT_ID 		NUMBER
PARSING_SCHEMA_ID 	NUMBER
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
COMMAND_TYPE 	NUMBER