select dbid, sql_id, plan_hash_value, id, operation, options,
object_node, object#, object_owner, object_name,
object_alias, object_type, optimizer,
parent_id, depth, position, search_columns, cost, cardinality,
bytes, other_tag, partition_start, partition_stop, partition_id,
other, distribution, cpu_cost, io_cost, temp_space,
access_predicates, filter_predicates,
projection, time, qblock_name, remarks, timestamp, other_xml,
decode(con_dbid, 0, dbid, con_dbid),
con_dbid_to_id(decode(con_dbid, 0, dbid, con_dbid)) con_id
from WRH$_SQL_PLAN
SELECT DBID
, SQL_ID
, PLAN_HASH_VALUE
, ID
, OPERATION
, OPTIONS
,
OBJECT_NODE
, OBJECT#
, OBJECT_OWNER
, OBJECT_NAME
,
OBJECT_ALIAS
, OBJECT_TYPE
, OPTIMIZER
,
PARENT_ID
, DEPTH
, POSITION
, SEARCH_COLUMNS
, COST
, CARDINALITY
,
BYTES
, OTHER_TAG
, PARTITION_START
, PARTITION_STOP
, PARTITION_ID
,
OTHER
, DISTRIBUTION
, CPU_COST
, IO_COST
, TEMP_SPACE
,
ACCESS_PREDICATES
, FILTER_PREDICATES
,
PROJECTION
, TIME
, QBLOCK_NAME
, REMARKS
, TIMESTAMP
, OTHER_XML
,
DECODE(CON_DBID
, 0
, DBID
, CON_DBID)
,
CON_DBID_TO_ID(DECODE(CON_DBID
, 0
, DBID
, CON_DBID)) CON_ID
FROM WRH$_SQL_PLAN
|
|
|