Oracle Magazine, July/August 2019
Emerging Technologies AUTONOMOUS But the easiest way to monitor Automatic Indexing is to use the built in report feature The DBMS_ AUTO_ INDEX REPORT_ ACTIVITY function returns a CLOB containing all the relevant details John pulls the data for activities between the 20th and 21st of April ORACLE MAGAZINE JULY AUGUST 2019 128 declare report clob null begin report DBMS_ AUTO_ INDEX REPORT_ ACTIVITY activity_ start TO_ TIMESTAMP 2019 04 20 YYYY MM DD activity_ end TO_ TIMESTAMP 2019 04 21 YYYY MM DD type TEXT section SUMMARY level BASIC end This produces a report containing all the needed information Here is part of the report GENERAL INFORMATION Activity start 20 APR 2019 00 00 00 Activity end 20 APR 2019 00 00 00 Executions completed 27
You must have JavaScript enabled to view digital editions.