Querying Advisor Views
There are several data dictionary views you can query to display information regarding SQL Access Advisor activities (refer to Table 10-3 for commonly used advisor view names and descriptions). For example, to report on tasks and execution details, query the DBA_ADVISOR_TASKS
view.
select
owner
,task_name
,advisor_name
,created
,execution_start
,status
from dba_advisor_tasks
where advisor_name = 'SQL Access Advisor'
order by 1, 2;
Here is some sample output for this example:
OWNER TASK_NAME ADVISOR_NAME CREATED EXECUTION STATUS
------- ----------------- -------------------- --------- --------- --------
SYS SQLACCESS2522132 SQL Access Advisor 22-JUL-11 22-JUL-11 COMPLETED SYS SQLACCESS4159181 SQL ...
Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.