| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
DBA_ADVISOR_SQLW_TABLES displays cross references between the workload statements and the tables referenced in the statement.
USER_ADVISOR_SQLW_TABLES displays cross references between the workload statements and the tables referenced in the statement. This view does not display the OWNER column.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
OWNER | 
VARCHAR2(30) | 
Owner of the workload object | |
WORKLOAD_ID | 
NUMBER | 
Unique identifier number of the workload object | |
WORKLOAD_NAME | 
VARCHAR2(30) | 
Name of the workload | |
SQL_ID | 
NUMBER | 
Identifier of the statement | |
TABLE_OWNER | 
VARCHAR2(30) | 
Owner of the table | |
TABLE_NAME | 
VARCHAR2(30) | 
Name of the table | 
See Also:
"USER_ADVISOR_SQLW_TABLES"