Keyword: LAST
back to indexColumns
Column Name | Description |
---|---|
LAST_ABORTED_SIZE (V$SHARED_POOL_RESERVED) | |
LAST_ABORTED_SIZE (GV$SHARED_POOL_RESERVED) | |
LAST_ANALYZED (USER_ALL_TABLES) | The date of the most recent time this table was analyzed |
LAST_ANALYZED (USER_TAB_COL_STATISTICS) | The date of the most recent time this column was analyzed |
LAST_ANALYZED (USER_TAB_SUBPARTITIONS) | |
LAST_ANALYZED (ALL_PART_COL_STATISTICS) | |
LAST_ANALYZED (DBA_IND_SUBPARTITIONS) | |
LAST_ANALYZED (DBA_ALL_TABLES) | The date of the most recent time this table was analyzed |
LAST_ANALYZED (USER_IND_SUBPARTITIONS) | |
LAST_ANALYZED (ALL_INDEXES) | The date of the most recent time this index was analyzed |
LAST_ANALYZED (DBA_SUBPART_COL_STATISTICS) | |
LAST_ANALYZED (ALL_TAB_SUBPARTITIONS) | |
LAST_ANALYZED (DBA_OBJECT_TABLES) | The date of the most recent time this table was analyzed |
LAST_ANALYZED (USER_TAB_PARTITIONS) | |
LAST_ANALYZED (USER_SUBPART_COL_STATISTICS) | |
LAST_ANALYZED (ALL_TAB_COLUMNS) | The date of the most recent time this column was analyzed |
LAST_ANALYZED (COLS) | The date of the most recent time this column was analyzed |
LAST_ANALYZED (ALL_SUBPART_COL_STATISTICS) | |
LAST_ANALYZED (USER_TABLES) | The date of the most recent time this table was analyzed |
LAST_ANALYZED (USER_INDEXES) | The date of the most recent time this index was analyzed |
LAST_ANALYZED (DBA_PART_COL_STATISTICS) | |
LAST_ANALYZED (ALL_OBJECT_TABLES) | The date of the most recent time this table was analyzed |
LAST_ANALYZED (USER_PART_COL_STATISTICS) | |
LAST_ANALYZED (USER_TAB_COLS) | The date of the most recent time this column was analyzed |
LAST_ANALYZED (ALL_TAB_COL_STATISTICS) | The date of the most recent time this column was analyzed |
LAST_ANALYZED (USER_TAB_COLUMNS) | The date of the most recent time this column was analyzed |
LAST_ANALYZED (DBA_TABLES) | The date of the most recent time this table was analyzed |
LAST_ANALYZED (TABS) | The date of the most recent time this table was analyzed |
LAST_ANALYZED (ALL_IND_SUBPARTITIONS) | |
LAST_ANALYZED (DBA_TAB_COL_STATISTICS) | The date of the most recent time this column was analyzed |
LAST_ANALYZED (ALL_ALL_TABLES) | The date of the most recent time this table was analyzed |
LAST_ANALYZED (ALL_TAB_COLS) | The date of the most recent time this column was analyzed |
LAST_ANALYZED (ALL_IND_PARTITIONS) | |
LAST_ANALYZED (DBA_TAB_COLS) | The date of the most recent time this column was analyzed |
LAST_ANALYZED (ALL_TAB_PARTITIONS) | |
LAST_ANALYZED (DBA_TAB_PARTITIONS) | |
LAST_ANALYZED (DBA_IND_PARTITIONS) | |
LAST_ANALYZED (DBA_INDEXES) | The date of the most recent time this index was analyzed |
LAST_ANALYZED (ALL_TABLES) | The date of the most recent time this table was analyzed |
LAST_ANALYZED (DBA_TAB_COLUMNS) | The date of the most recent time this column was analyzed |
LAST_ANALYZED (IND) | The date of the most recent time this index was analyzed |
LAST_ANALYZED (USER_OBJECT_TABLES) | The date of the most recent time this table was analyzed |
LAST_ANALYZED (DBA_TAB_SUBPARTITIONS) | |
LAST_ANALYZED (USER_IND_PARTITIONS) | |
LAST_CALL_ET (GV$SESSION) | |
LAST_CALL_ET (V$SESSION) | |
LAST_CHANGE (DBA_CONSTRAINTS) | The date when this column was last enabled or disabled |
LAST_CHANGE (ALL_CONSTRAINTS) | The date when this column was last enabled or disabled |
LAST_CHANGE (USER_CONSTRAINTS) | The date when this column was last enabled or disabled |
LAST_CHANGE# (GV$DATAFILE) | |
LAST_CHANGE# (GV$STANDBY_LOG) | |
LAST_CHANGE# (V$DATAFILE) | |
LAST_CHANGE# (V$STANDBY_LOG) | |
LAST_CONVERT (DBA_DML_LOCKS) | |
LAST_CONVERT (DBA_LOCK) | |
LAST_CONVERT (DBA_LOCKS) | |
LAST_CR_BUFFER_GETS (V$SQL_PLAN_STATISTICS) | |
LAST_CR_BUFFER_GETS (V$SQL_PLAN_STATISTICS_ALL) | |
LAST_CR_BUFFER_GETS (GV$SQL_PLAN_STATISTICS_ALL) | |
LAST_CR_BUFFER_GETS (GV$SQL_PLAN_STATISTICS) | |
LAST_CU_BUFFER_GETS (GV$SQL_PLAN_STATISTICS_ALL) | |
LAST_CU_BUFFER_GETS (GV$SQL_PLAN_STATISTICS) | |
LAST_CU_BUFFER_GETS (V$SQL_PLAN_STATISTICS_ALL) | |
LAST_CU_BUFFER_GETS (V$SQL_PLAN_STATISTICS) | |
LAST_DATE (DBA_JOBS) | Date that this job last successfully executed |
LAST_DATE (ALL_JOBS) | Date that this job last successfully executed |
LAST_DATE (USER_JOBS) | Date that this job last successfully executed |
LAST_DATE (DBA_JOBS_RUNNING) | Date that this job last successfully executed |
LAST_DDL_TIME (ALL_PROBE_OBJECTS) | |
LAST_DDL_TIME (OBJ) | Timestamp for the last DDL change (including GRANT and REVOKE) to the object |
LAST_DDL_TIME (DBA_OBJECTS) | Timestamp for the last DDL change (including GRANT and REVOKE) to the object |
LAST_DDL_TIME (USER_OBJECTS) | Timestamp for the last DDL change (including GRANT and REVOKE) to the object |
LAST_DDL_TIME (ALL_OBJECTS) | Timestamp for the last DDL change (including GRANT and REVOKE) to the object |
LAST_DEGREE (V$SQL_PLAN_STATISTICS_ALL) | |
LAST_DEGREE (GV$SQL_WORKAREA) | |
LAST_DEGREE (GV$SQL_PLAN_STATISTICS_ALL) | |
LAST_DEGREE (V$SQL_WORKAREA) | |
LAST_DISK_READS (V$SQL_PLAN_STATISTICS) | |
LAST_DISK_READS (V$SQL_PLAN_STATISTICS_ALL) | |
LAST_DISK_READS (GV$SQL_PLAN_STATISTICS) | |
LAST_DISK_READS (GV$SQL_PLAN_STATISTICS_ALL) | |
LAST_DISK_WRITES (GV$SQL_PLAN_STATISTICS) | |
LAST_DISK_WRITES (V$SQL_PLAN_STATISTICS_ALL) | |
LAST_DISK_WRITES (V$SQL_PLAN_STATISTICS) | |
LAST_DISK_WRITES (GV$SQL_PLAN_STATISTICS_ALL) | |
LAST_ELAPSED_TIME (V$SQL_PLAN_STATISTICS_ALL) | |
LAST_ELAPSED_TIME (GV$SQL_PLAN_STATISTICS_ALL) | |
LAST_ELAPSED_TIME (GV$SQL_PLAN_STATISTICS) | |
LAST_ELAPSED_TIME (V$SQL_PLAN_STATISTICS) | |
LAST_ENQUEUE_TIME (V$REPLQUEUE) | |
LAST_ENQUEUE_TIME (GV$REPLQUEUE) | |
LAST_ERROR_DATE (DBA_QUEUE_SCHEDULES) | |
LAST_ERROR_DATE (USER_QUEUE_SCHEDULES) | |
LAST_ERROR_MSG (DBA_QUEUE_SCHEDULES) | |
LAST_ERROR_MSG (USER_QUEUE_SCHEDULES) | |
LAST_ERROR_TIME (USER_QUEUE_SCHEDULES) | |
LAST_ERROR_TIME (DBA_QUEUE_SCHEDULES) | |
LAST_EXECUTION (V$SQL_PLAN_STATISTICS_ALL) | |
LAST_EXECUTION (GV$SQL_WORKAREA) | |
LAST_EXECUTION (V$SQL_WORKAREA) | |
LAST_EXECUTION (GV$SQL_PLAN_STATISTICS_ALL) | |
LAST_EXTENDED (DBA_SUBSCRIPTIONS) | |
LAST_EXTENDED (ALL_SUBSCRIPTIONS) | |
LAST_EXTENDED (USER_SUBSCRIPTIONS) | |
LAST_FAILURE_SIZE (V$SHARED_POOL_RESERVED) | |
LAST_FAILURE_SIZE (GV$SHARED_POOL_RESERVED) | |
LAST_INDEX (V$CONTROLFILE_RECORD_SECTION) | |
LAST_INDEX (GV$CONTROLFILE_RECORD_SECTION) | |
LAST_LOAD_TIME (V$SQL) | |
LAST_LOAD_TIME (GV$SQL) | |
LAST_MEMORY_USED (GV$SQL_WORKAREA) | |
LAST_MEMORY_USED (V$SQL_PLAN_STATISTICS_ALL) | |
LAST_MEMORY_USED (GV$SQL_PLAN_STATISTICS_ALL) | |
LAST_MEMORY_USED (V$SQL_WORKAREA) | |
LAST_MISS_SIZE (V$SHARED_POOL_RESERVED) | |
LAST_MISS_SIZE (GV$SHARED_POOL_RESERVED) | |
LAST_NUMBER (SEQ) | Last sequence number written to disk |
LAST_NUMBER (ALL_SEQUENCES) | Last sequence number written to disk |
LAST_NUMBER (DBA_SEQUENCES) | Last sequence number written to disk |
LAST_NUMBER (USER_SEQUENCES) | Last sequence number written to disk |
LAST_OPER_MODE (V$SGA_DYNAMIC_COMPONENTS) | |
LAST_OPER_MODE (GV$SGA_DYNAMIC_COMPONENTS) | |
LAST_OPER_TIME (V$SGA_DYNAMIC_COMPONENTS) | |
LAST_OPER_TIME (GV$SGA_DYNAMIC_COMPONENTS) | |
LAST_OPER_TYPE (GV$SGA_DYNAMIC_COMPONENTS) | |
LAST_OPER_TYPE (V$SGA_DYNAMIC_COMPONENTS) | |
LAST_OUTPUT_ROWS (GV$SQL_PLAN_STATISTICS_ALL) | |
LAST_OUTPUT_ROWS (V$SQL_PLAN_STATISTICS) | |
LAST_OUTPUT_ROWS (V$SQL_PLAN_STATISTICS_ALL) | |
LAST_OUTPUT_ROWS (GV$SQL_PLAN_STATISTICS) | |
LAST_PURGED (DBA_SUBSCRIPTIONS) | |
LAST_PURGED (ALL_SUBSCRIPTIONS) | |
LAST_PURGED (USER_SUBSCRIPTIONS) | |
LAST_PURGE_END_DATE (USER_REPRESOL_STATS_CONTROL) | The last end date of the statistics purging date range |
LAST_PURGE_END_DATE (ALL_REPRESOL_STATS_CONTROL) | The last end date of the statistics purging date range |
LAST_PURGE_END_DATE (DBA_REPRESOL_STATS_CONTROL) | The last end date of the statistics purging date range |
LAST_PURGE_START_DATE (DBA_REPRESOL_STATS_CONTROL) | The last start date of the statistics purging date range |
LAST_PURGE_START_DATE (ALL_REPRESOL_STATS_CONTROL) | The last start date of the statistics purging date range |
LAST_PURGE_START_DATE (USER_REPRESOL_STATS_CONTROL) | The last start date of the statistics purging date range |
LAST_PURGE_TIME (V$REPLQUEUE) | |
LAST_PURGE_TIME (GV$REPLQUEUE) | |
LAST_QUERY (V$PQ_SESSTAT) | |
LAST_QUERY (GV$PQ_SESSTAT) | |
LAST_RECID (GV$CONTROLFILE_RECORD_SECTION) | |
LAST_RECID (V$CONTROLFILE_RECORD_SECTION) | |
LAST_REFRESH (USER_MVIEW_REFRESH_TIMES) | SYSDATE from the master site at the time of the last refresh |
LAST_REFRESH (ALL_MVIEW_REFRESH_TIMES) | SYSDATE from the master site at the time of the last refresh |
LAST_REFRESH (DBA_MVIEW_REFRESH_TIMES) | SYSDATE from the master site at the time of the last refresh |
LAST_REFRESH (USER_SNAPSHOT_REFRESH_TIMES) | SYSDATE from the master site at the time of the last refresh |
LAST_REFRESH (ALL_SNAPSHOT_REFRESH_TIMES) | SYSDATE from the master site at the time of the last refresh |
LAST_REFRESH (ALL_SNAPSHOTS) | SYSDATE from the master site at the time of the last refresh |
LAST_REFRESH (USER_SNAPSHOTS) | SYSDATE from the master site at the time of the last refresh |
LAST_REFRESH (DBA_SNAPSHOT_REFRESH_TIMES) | SYSDATE from the master site at the time of the last refresh |
LAST_REFRESH (DBA_SNAPSHOTS) | SYSDATE from the master site at the time of the last refresh |
LAST_REFRESH_DATE (DBA_SUMMARIES) | The date of the last refresh of the summary |
LAST_REFRESH_DATE (ALL_SUMMARIES) | The date of the last refresh of the summary |
LAST_REFRESH_DATE (ALL_MVIEW_ANALYSIS) | The date of the last refresh of the materialized view |
LAST_REFRESH_DATE (DBA_MVIEW_ANALYSIS) | The date of the last refresh of the materialized view |
LAST_REFRESH_DATE (DBA_MVIEWS) | The date that the materialized view was last refreshed |
LAST_REFRESH_DATE (USER_MVIEW_ANALYSIS) | The date of the last refresh of the materialized view |
LAST_REFRESH_DATE (ALL_MVIEWS) | The date that the materialized view was last refreshed |
LAST_REFRESH_DATE (USER_MVIEWS) | The date that the materialized view was last refreshed |
LAST_REFRESH_DATE (USER_SUMMARIES) | The date of the last refresh of the summary |
LAST_REFRESH_SCN (DBA_MVIEW_ANALYSIS) | The SCN of the last transaction to refresh the materialized view |
LAST_REFRESH_SCN (USER_MVIEW_ANALYSIS) | The SCN of the last transaction to refresh the materialized view |
LAST_REFRESH_SCN (ALL_MVIEW_ANALYSIS) | The SCN of the last transaction to refresh the materialized view |
LAST_REFRESH_SCN (USER_SUMMARIES) | The SCN of the last transaction to refresh the summary |
LAST_REFRESH_SCN (DBA_SUMMARIES) | The SCN of the last transaction to refresh the summary |
LAST_REFRESH_SCN (ALL_SUMMARIES) | The SCN of the last transaction to refresh the summary |
LAST_REFRESH_TYPE (USER_MVIEWS) | Indicates the kind of refresh that was last performed on the MV |
LAST_REFRESH_TYPE (DBA_MVIEWS) | Indicates the kind of refresh that was last performed on the MV |
LAST_REFRESH_TYPE (ALL_MVIEWS) | Indicates the kind of refresh that was last performed on the MV |
LAST_RUN_DATE (DBA_QUEUE_SCHEDULES) | |
LAST_RUN_DATE (USER_QUEUE_SCHEDULES) | |
LAST_RUN_TIME (DBA_QUEUE_SCHEDULES) | |
LAST_RUN_TIME (USER_QUEUE_SCHEDULES) | |
LAST_SEC (DBA_JOBS) | Same as LAST_DATE. This is when the last successful execution started. |
LAST_SEC (DBA_JOBS_RUNNING) | Same as LAST_DATE. This is when the last successful execution started. |
LAST_SEC (ALL_JOBS) | Same as LAST_DATE. This is when the last successful execution started. |
LAST_SEC (USER_JOBS) | Same as LAST_DATE. This is when the last successful execution started. |
LAST_STARTS (V$SQL_PLAN_STATISTICS) | |
LAST_STARTS (GV$SQL_PLAN_STATISTICS_ALL) | |
LAST_STARTS (V$SQL_PLAN_STATISTICS_ALL) | |
LAST_STARTS (GV$SQL_PLAN_STATISTICS) | |
LAST_TEMPSEG_SIZE (GV$SQL_PLAN_STATISTICS_ALL) | |
LAST_TEMPSEG_SIZE (GV$SQL_WORKAREA) | |
LAST_TEMPSEG_SIZE (V$SQL_WORKAREA) | |
LAST_TEMPSEG_SIZE (V$SQL_PLAN_STATISTICS_ALL) | |
LAST_TIME (V$DATAFILE) | |
LAST_TIME (GV$DATAFILE) | |
LAST_TIME (V$STANDBY_LOG) | |
LAST_TIME (GV$STANDBY_LOG) | |
LAST_UPDATE_TIME (GV$SESSION_LONGOPS) | |
LAST_UPDATE_TIME (V$SESSION_LONGOPS) | |
LAST_UPDATE_TIME (V$SGA_CURRENT_RESIZE_OPS) | |
LAST_UPDATE_TIME (GV$SGA_CURRENT_RESIZE_OPS) | |
MVIEW_LAST_REFRESH_TIME (ALL_BASE_TABLE_MVIEWS) | One date per materialized view -- the date the materialized view was last refreshed |
MVIEW_LAST_REFRESH_TIME (USER_BASE_TABLE_MVIEWS) | One date per materialized view -- the date the materialized view was last refreshed |
MVIEW_LAST_REFRESH_TIME (DBA_BASE_TABLE_MVIEWS) | One date per materialized view -- the date the materialized view was last refreshed |