DBA Data[Home] [Help]

VIEW: SYS.INT$DBA_HIST_PLAN_OP_NAME

Source

View Text - Preformatted

select dbid, operation_id, operation_name,
       decode(con_dbid, 0, dbid, con_dbid),
       0 con_id
from WRH$_PLAN_OPERATION_NAME
View Text - HTML Formatted

SELECT DBID
, OPERATION_ID
, OPERATION_NAME
, DECODE(CON_DBID
, 0
, DBID
, CON_DBID)
, 0 CON_ID FROM WRH$_PLAN_OPERATION_NAME