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 of the workload object |
|
|
|
|
Unique identifier of the task |
|
|
|
|
Name of the task |
|
|
|
|
SQL identifier of the parent cursor in the library cache |
|
|
|
|
Statement ID |
|
|
|
|
Owner of the table |
|
|
|
|
Table name |
See Also: