Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-10
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
PDF · Mobi · ePub

DBA_ADVISOR_SQLA_TABLES

DBA_ADVISOR_SQLA_TABLES displays cross references between the workload statements and the tables referenced in the statement.

Related View

USER_ADVISOR_SQLA_TABLES displays cross references between the workload statements and the tables referenced in the statement for the current user. This view does not display the OWNER column.

Column Datatype NULL Description
OWNER VARCHAR2(30)   Owner of the workload object
TASK_ID NUMBER   Unique identifier of the task
TASK_NAME VARCHAR2(30)   Name of the task
SQL_ID VARCHAR2(13)   SQL identifier of the parent cursor in the library cache
STMT_ID NUMBER   Statement ID
TABLE_OWNER VARCHAR2(30)   Owner of the table
TABLE_NAME VARCHAR2(30)   Table name