What Advisors Are Available

Many times we need to know that counselors are available in a database, depending on the version will be more or less. But looking at the view dba_advisor_definitions know the ones.

Executing the next code in Oracle  11g;

ORA11*ANTO> select * from dba_advisor_definitions;

ADVISOR_ID ADVISOR_NAME                     PROPERTY
__________ ______________________________ __________
         1 ADDM                                    1
         2 SQL Access Advisor                    271
         3 Undo Advisor                            1
         4 SQL Tuning Advisor                    935
         5 Segment Advisor                         3
         6 SQL Workload Manager                    0
         7 Tune MView                             31
         8 SQL Performance Analyzer              935
         9 SQL Repair Advisor                    679
        10 Compression Advisor                     3

10 filas seleccionadas.

The same query for Oracle Version 10g

ORA10*ANTO> select * from dba_advisor_definitions;

ADVISOR_ID ADVISOR_NAME                     PROPERTY
__________ ______________________________ __________
         1 ADDM                                    1
         2 SQL Access Advisor                     15
         3 Undo Advisor                            1
         4 SQL Tuning Advisor                      7
         5 Segment Advisor                         3
         6 SQL Workload Manager                    0
         7 Tune MView                             31

7 filas seleccionadas.

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s