| Column Name
| Description
|
| LAST_QUERY (V$PQ_SESSTAT)
|
|
| LAST_QUERY (GV$PQ_SESSTAT)
|
|
| MV_QUERY_GEN_MISMATCH (V$SQL_SHARED_CURSOR)
|
|
| MV_QUERY_GEN_MISMATCH (GV$SQL_SHARED_CURSOR)
|
|
| QUERY (DBA_SNAPSHOTS)
| The original query that this snapshot is an instantiation of
|
| QUERY (DBA_MVIEWS)
| The defining query that the materialized view instantiates
|
| QUERY (USER_SUMMARIES)
|
|
| QUERY (DBA_MVIEW_ANALYSIS)
| SELECT expression of the materialized view definition
|
| QUERY (USER_MVIEW_ANALYSIS)
| SELECT expression of the materialized view definition
|
| QUERY (DBA_SUMMARIES)
|
|
| QUERY (ALL_SUMMARIES)
|
|
| QUERY (USER_SNAPSHOTS)
| The original query that this snapshot is an instantiation of
|
| QUERY (USER_MVIEWS)
| The defining query that the materialized view instantiates
|
| QUERY (ALL_SNAPSHOTS)
| The original query that this snapshot is an instantiation of
|
| QUERY (ALL_MVIEWS)
| The defining query that the materialized view instantiates
|
| QUERY (ALL_MVIEW_ANALYSIS)
| SELECT expression of the materialized view definition
|
| QUERY_LEN (DBA_MVIEWS)
| The number of bytes in the defining query (based on the server character set
|
| QUERY_LEN (USER_SUMMARIES)
|
|
| QUERY_LEN (ALL_MVIEW_ANALYSIS)
| The length (in bytes) of the query field
|
| QUERY_LEN (DBA_MVIEW_ANALYSIS)
| The length (in bytes) of the query field
|
| QUERY_LEN (ALL_MVIEWS)
| The number of bytes in the defining query (based on the server character set
|
| QUERY_LEN (USER_MVIEWS)
| The number of bytes in the defining query (based on the server character set
|
| QUERY_LEN (DBA_SUMMARIES)
|
|
| QUERY_LEN (USER_MVIEW_ANALYSIS)
| The length (in bytes) of the query field
|
| QUERY_LEN (ALL_SUMMARIES)
|
|
| QUERY_TXT (DBA_REGISTERED_MVIEWS)
| Query defining the materialized view
|
| QUERY_TXT (ALL_REGISTERED_SNAPSHOTS)
| Query defining the snapshot
|
| QUERY_TXT (ALL_REGISTERED_MVIEWS)
| Query defining the materialized view
|
| QUERY_TXT (DBA_REGISTERED_SNAPSHOTS)
| Query defining the snapshot
|
| QUERY_TXT (USER_REGISTERED_MVIEWS)
| Query defining the materialized view
|
| QUERY_TXT (USER_REGISTERED_SNAPSHOTS)
| Query defining the snapshot
|