DBA Data[Home] [Help]

SYS.DBMS_FEATURE_WCR_CAPTURE dependencies on DUAL

Line 29: date_format) into prev_sample_date_dbtz from dual;

25:
26: -- convert date to db timezone
27: select to_date(to_char(from_tz(cast(prev_sample_date as timestamp),
28: sessiontimezone) at time zone dbtimezone, date_format),
29: date_format) into prev_sample_date_dbtz from dual;
30:
31: -- Find # of workload captures since last sample in current DB
32: select count(*)
33: into captures_since