Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_ADVISOR_SQLA_REC_SUM

DBA_ADVISOR_SQLA_REC_SUM displays recommendation rollup information for all workload objects in the database after an Access Advisor analysis operation.

Related View

USER_ADVISOR_SQLA_REC_SUM displays recommendation rollup information for the workload objects owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description
OWNER VARCHAR2(30)   Owner of the task
TASK_ID NUMBER   Unique identifier of the task
TASK_NAME VARCHAR2(30)   Name of the task
REC_ID NUMBER   Identifier of the recommendation
TOTAL_STMTS NUMBER   Total number of statements processed during analysis
TOTAL_PRECOST NUMBER   Total cost of executing the statements in which the recommended object will be utilized, prior to the recommendations
TOTAL_POSTCOST NUMBER   Total cost of executing the statements in which the recommended object will be utilized, after the recommendations have been implemented