The new 12c
dbms_stats.report_stats_operations now give you a
window into the 12c automatic statistics collection
mechanisms for creating indexes and CTAS (create table as
select). Here is a sample invocation of
dbms_stats.report_stats_operations:
SQL> variable
mystatrep2 clob;
SQL> set long 1000000
SQL> begin
2 :mystatrep2 :=
dbms_stats.report_stats_operations(
3 since=>SYSTIMESTAMP-16,
4 until=>SYSTIMESTAMP-1,
5 detail_level=>'TYPICAL',
6 format=>'TEXT');
7 end;
8 /
PL/SQL procedure
successfully completed.
SQL> print
mystatrep2
The output from dbms_stats.report_stats_operations
report on the following data:
- Operation Id
- Operation
- Target
- Start Time
- End Time
- Status
- Total Tasks
- Successful
- Tasks
- Failed Tasks
- Active Tasks
