home - keyword index

Keyword: LAST

back to index

Columns

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
top back to index

Comment on this page:




home - keyword index