DBA Data[Home] [Help]

SYS.DBMS_FEATURE_AUM dependencies on DBA_FEATURE_USAGE_STATISTICS

Line 50: FROM dba_feature_usage_statistics);

46: into undo_blocks, max_concurrency
47: from v$undostat
48: where begin_time >=
49: (SELECT nvl(max(last_sample_date), sysdate-7)
50: FROM dba_feature_usage_statistics);
51:
52: ts_info := ts_info || '(Undo Blocks: ' || undo_blocks ||
53: ', Max Concurrency: ' || max_concurrency || ') ';
54:

Line 62: FROM dba_feature_usage_statistics)))

58: sum(SSOLDERRCNT) errcnt
59: from v$undostat
60: where (begin_time >=
61: (SELECT nvl(max(last_sample_date), sysdate-7)
62: FROM dba_feature_usage_statistics)))
63: loop
64: ts_info := ts_info ||
65: '(Snapshot Old Info - Begin Time: ' || ssold.btime ||
66: ', End Time: ' || ssold.etime ||