Keyword: SQL
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| GV$SQL | Synonym for GV_$SQL |
| GV$SQL_BIND_DATA | Synonym for GV_$SQL_BIND_DATA |
| GV$SQL_BIND_METADATA | Synonym for GV_$SQL_BIND_METADATA |
| GV$SQL_CURSOR | Synonym for GV_$SQL_CURSOR |
| GV$SQL_PLAN | Synonym for GV_$SQL_PLAN |
| GV$SQL_PLAN_STATISTICS | Synonym for GV_$SQL_PLAN_STATISTICS |
| GV$SQL_PLAN_STATISTICS_ALL | Synonym for GV_$SQL_PLAN_STATISTICS_ALL |
| GV$SQL_REDIRECTION | Synonym for GV_$SQL_REDIRECTION |
| GV$SQL_SHARED_CURSOR | Synonym for GV_$SQL_SHARED_CURSOR |
| GV$SQL_SHARED_MEMORY | Synonym for GV_$SQL_SHARED_MEMORY |
| GV$SQL_WORKAREA | Synonym for GV_$SQL_WORKAREA |
| GV$SQL_WORKAREA_ACTIVE | Synonym for GV_$SQL_WORKAREA_ACTIVE |
| GV$SQL_WORKAREA_HISTOGRAM | Synonym for GV_$SQL_WORKAREA_HISTOGRAM |
| V$SQL | Synonym for V_$SQL |
| V$SQL_BIND_DATA | Synonym for V_$SQL_BIND_DATA |
| V$SQL_BIND_METADATA | Synonym for V_$SQL_BIND_METADATA |
| V$SQL_CURSOR | Synonym for V_$SQL_CURSOR |
| V$SQL_PLAN | Synonym for V_$SQL_PLAN |
| V$SQL_PLAN_STATISTICS | Synonym for V_$SQL_PLAN_STATISTICS |
| V$SQL_PLAN_STATISTICS_ALL | Synonym for V_$SQL_PLAN_STATISTICS_ALL |
| V$SQL_REDIRECTION | Synonym for V_$SQL_REDIRECTION |
| V$SQL_SHARED_CURSOR | Synonym for V_$SQL_SHARED_CURSOR |
| V$SQL_SHARED_MEMORY | Synonym for V_$SQL_SHARED_MEMORY |
| V$SQL_WORKAREA | Synonym for V_$SQL_WORKAREA |
| V$SQL_WORKAREA_ACTIVE | Synonym for V_$SQL_WORKAREA_ACTIVE |
| V$SQL_WORKAREA_HISTOGRAM | Synonym for V_$SQL_WORKAREA_HISTOGRAM |
Columns
| Column Name | Description |
|---|---|
| PREV_SQL_ADDR (GV$SESSION) | |
| PREV_SQL_ADDR (V$SESSION) | |
| SQL_ADDRESS (V$SESSION_LONGOPS) | |
| SQL_ADDRESS (V$SESSION) | |
| SQL_ADDRESS (GV$SESSION_LONGOPS) | |
| SQL_ADDRESS (GV$SESSION) | |
| SQL_BIND (DBA_FGA_AUDIT_TRAIL) | Bind variable data of the query |
| SQL_COLUMN_NAME (V$LOGMNR_CONTENTS) | |
| SQL_COLUMN_NAME (GV$LOGMNR_CONTENTS) | |
| SQL_COLUMN_TYPE (GV$LOGMNR_CONTENTS) | |
| SQL_COLUMN_TYPE (V$LOGMNR_CONTENTS) | |
| SQL_HASH (V$VPD_POLICY) | |
| SQL_HASH (GV$VPD_POLICY) | |
| SQL_HASH_VALUE (GV$SESSION) | |
| SQL_HASH_VALUE (V$SESSION) | |
| SQL_HASH_VALUE (V$SESSION_LONGOPS) | |
| SQL_HASH_VALUE (GV$SESSION_LONGOPS) | |
| SQL_REDIRECT_MISMATCH (V$SQL_SHARED_CURSOR) | |
| SQL_REDIRECT_MISMATCH (GV$SQL_SHARED_CURSOR) | |
| SQL_REDO (V$LOGMNR_CONTENTS) | |
| SQL_REDO (GV$LOGMNR_CONTENTS) | |
| SQL_TEXT (GV$SQL) | |
| SQL_TEXT (GV$SQLAREA) | |
| SQL_TEXT (GV$SQL_SHARED_MEMORY) | |
| SQL_TEXT (V$SQLTEXT_WITH_NEWLINES) | |
| SQL_TEXT (V$SQL_SHARED_MEMORY) | |
| SQL_TEXT (V$OPEN_CURSOR) | |
| SQL_TEXT (V$SQLAREA) | |
| SQL_TEXT (GV$SQLTEXT_WITH_NEWLINES) | |
| SQL_TEXT (DBA_OUTLINES) | SQL text of the query |
| SQL_TEXT (USER_RESUMABLE) | The current SQL text |
| SQL_TEXT (V$SQLTEXT) | |
| SQL_TEXT (DBA_FGA_AUDIT_TRAIL) | SQL text of the query |
| SQL_TEXT (V$SQL) | |
| SQL_TEXT (DBA_RESUMABLE) | The current SQL text |
| SQL_TEXT (GV$SQLTEXT) | |
| SQL_TEXT (ALL_OUTLINES) | SQL text of the query |
| SQL_TEXT (USER_OUTLINES) | SQL text of the query |
| SQL_TEXT (GV$OPEN_CURSOR) | |
| SQL_TEXT (V$SQLXS) | |
| SQL_TEXT_PIECE (GV$SQL_REDIRECTION) | |
| SQL_TEXT_PIECE (V$SQL_REDIRECTION) | |
| SQL_TYPE_MISMATCH (GV$SQL_SHARED_CURSOR) | |
| SQL_TYPE_MISMATCH (V$SQL_SHARED_CURSOR) | |
| SQL_UNDO (V$LOGMNR_CONTENTS) | |
| SQL_UNDO (GV$LOGMNR_CONTENTS) |