Database Tuning (MOSC)

MOSC Banner

Understanding the Benefit from Auto Indexing

Hi

I am playing with the AI feature, and enabled AI as per:

exec dbms_auto_index.configure('AUTO_INDEX_MODE','IMPLEMENT');

Now, I can see a bunch of SYS_AI... indexed being created, and over time I can see that some of the indexes are now visible/usable.

This is all great, but I want to see what impact these new indexes are having on the queries running, and maybe present back to the customer how great this all is, so I create a report for the last 7 days

select dbms_auto_index.report_activity(activity_start => systimestamp-7,activity_end=>systimestamp, type => 'HTML') from  dual;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center