Oracle Magazine, July/August 2019
Emerging Technologies AUTONOMOUS ORACLE MAGAZINE JULY AUGUST 2019 126 order by task_ id TASK_ ID TASK_ NAME ADVISOR_ NAME 2 SYS_ AUTO_ SPM_ EVOLVE_ TASK SPM Evolve Advisor 3 SYS_ AI_ SPM_ EVOLVE_ TASK SPM Evolve Advisor 4 SYS_ AI_ VERIFY_ TASK SQL Performance Analyzer 5 SYS_ AUTO_ INDEX_ TASK SQL Access Advisor 6 AUTO_ STATS_ ADVISOR_ TASK Statistics Advisor 7 INDIVIDUAL_ STATS_ ADVISOR_ TASK Statistics Advisor He points out the SYS_ AUTO_ INDEX_ TASK task and two tasks with _ AI_ in their name These are the tasks behind the Automatic Indexing feature ADMINISTRATION Bettys interest is piqued now How do the DBAs administer this feature she asks John reminds her that the DBAs actually do not need to implement anything the system detects the need to create indexes automatically and creates them and it even drops them when they are not needed So the DBAs involvement is limited to Configuring the properties and parameters Getting reports on automatic indexing usage To set the default tablespace of the autocreated indexes to USER_ AI John uses the following dbms_ auto_ index configure AUTO_ INDEX_ DEFAULT_ TABLESPACE USER_ AI But autocreated indexes may overwhelm the space in that tablespace To prevent
You must have JavaScript enabled to view digital editions.