DBA Data[Home] [Help]

VIEW: SYS.DBA_WI_PATTERNS

Source

View Text - Preformatted

select jobid,
       patternid,
       length,
       numberOfExecutions,
       dbtime
from wi$_frequent_pattern
View Text - HTML Formatted

SELECT JOBID
, PATTERNID
, LENGTH
, NUMBEROFEXECUTIONS
, DBTIME FROM WI$_FREQUENT_PATTERN