New V$ views:
| VIEW_NAME |
| V_$ADVISOR_CURRENT_SQLPLAN |
| V_$ASH_INFO |
| V_$ASM_ACFSSNAPSHOTS |
| V_$ASM_ACFSVOLUMES |
| V_$ASM_ACFS_ENCRYPTION_INFO |
| V_$ASM_ACFS_SECURITY_INFO |
| V_$ASM_ATTRIBUTE |
| V_$ASM_DISK_IOSTAT |
| V_$ASM_FILESYSTEM |
| V_$ASM_USER |
| V_$ASM_USERGROUP |
| V_$ASM_USERGROUP_MEMBER |
| V_$ASM_VOLUME |
| V_$ASM_VOLUME_STAT |
| V_$CALLTAG |
| V_$CELL |
| V_$CELL_CONFIG |
| V_$CELL_REQUEST_TOTALS |
| V_$CELL_STATE |
| V_$CELL_THREAD_HISTORY |
| V_$CORRUPT_XID_LIST |
| V_$CPOOL_CC_INFO |
| V_$CPOOL_CC_STATS |
| V_$CPOOL_CONN_INFO |
| V_$CPOOL_STATS |
| V_$DATABASE_KEY_INFO |
| V_$DETACHED_SESSION |
| V_$DIAG_ADR_CONTROL |
| V_$DIAG_ADR_INVALIDATION |
| V_$DIAG_ALERT_EXT |
| V_$DIAG_AMS_XACTION |
| V_$DIAG_CRITICAL_ERROR |
| V_$DIAG_DDE_USER_ACTION |
| V_$DIAG_DDE_USER_ACTION_DEF |
| V_$DIAG_DDE_USR_ACT_PARAM |
| V_$DIAG_DDE_USR_ACT_PARAM_DEF |
| V_$DIAG_DDE_USR_INC_ACT_MAP |
| V_$DIAG_DDE_USR_INC_TYPE |
| V_$DIAG_DFW_CONFIG_CAPTURE |
| V_$DIAG_DFW_CONFIG_ITEM |
| V_$DIAG_DIAGV_INCIDENT |
| V_$DIAG_DIR_EXT |
| V_$DIAG_EM_DIAG_JOB |
| V_$DIAG_EM_TARGET_INFO |
| V_$DIAG_EM_USER_ACTIVITY |
| V_$DIAG_HM_FDG_SET |
| V_$DIAG_HM_FINDING |
| V_$DIAG_HM_INFO |
| V_$DIAG_HM_MESSAGE |
| V_$DIAG_HM_RECOMMENDATION |
| V_$DIAG_HM_RUN |
| V_$DIAG_INCCKEY |
| V_$DIAG_INCIDENT |
| V_$DIAG_INCIDENT_FILE |
| V_$DIAG_INC_METER_CONFIG |
| V_$DIAG_INC_METER_IMPT_DEF |
| V_$DIAG_INC_METER_INFO |
| V_$DIAG_INC_METER_PK_IMPTS |
| V_$DIAG_INC_METER_SUMMARY |
| V_$DIAG_INFO |
| V_$DIAG_IPS_CONFIGURATION |
| V_$DIAG_IPS_FILE_COPY_LOG |
| V_$DIAG_IPS_FILE_METADATA |
| V_$DIAG_IPS_PACKAGE |
| V_$DIAG_IPS_PACKAGE_FILE |
| V_$DIAG_IPS_PACKAGE_HISTORY |
| V_$DIAG_IPS_PACKAGE_INCIDENT |
| V_$DIAG_IPS_PKG_UNPACK_HIST |
| V_$DIAG_IPS_PROGRESS_LOG |
| V_$DIAG_IPS_REMOTE_PACKAGE |
| V_$DIAG_PICKLEERR |
| V_$DIAG_PROBLEM |
| V_$DIAG_RELMD_EXT |
| V_$DIAG_SWEEPERR |
| V_$DIAG_VEM_USER_ACTLOG |
| V_$DIAG_VEM_USER_ACTLOG1 |
| V_$DIAG_VHM_RUN |
| V_$DIAG_VIEW |
| V_$DIAG_VIEWCOL |
| V_$DIAG_VINCIDENT |
| V_$DIAG_VINCIDENT_FILE |
| V_$DIAG_VINC_METER_INFO |
| V_$DIAG_VIPS_FILE_COPY_LOG |
| V_$DIAG_VIPS_FILE_METADATA |
| V_$DIAG_VIPS_PACKAGE_FILE |
| V_$DIAG_VIPS_PACKAGE_HISTORY |
| V_$DIAG_VIPS_PACKAGE_MAIN_INT |
| V_$DIAG_VIPS_PACKAGE_SIZE |
| V_$DIAG_VIPS_PKG_FILE |
| V_$DIAG_VIPS_PKG_INC_CAND |
| V_$DIAG_VIPS_PKG_INC_DTL |
| V_$DIAG_VIPS_PKG_INC_DTL1 |
| V_$DIAG_VIPS_PKG_MAIN_PROBLEM |
| V_$DIAG_VNOT_EXIST_INCIDENT |
| V_$DIAG_VPROBLEM |
| V_$DIAG_VPROBLEM1 |
| V_$DIAG_VPROBLEM2 |
| V_$DIAG_VPROBLEM_BUCKET |
| V_$DIAG_VPROBLEM_BUCKET1 |
| V_$DIAG_VPROBLEM_BUCKET_COUNT |
| V_$DIAG_VPROBLEM_INT |
| V_$DIAG_VPROBLEM_LASTINC |
| V_$DIAG_VSHOWCATVIEW |
| V_$DIAG_VSHOWINCB |
| V_$DIAG_VSHOWINCB_I |
| V_$DIAG_VTEST_EXISTS |
| V_$DIAG_V_ACTINC |
| V_$DIAG_V_ACTPROB |
| V_$DIAG_V_INCCOUNT |
| V_$DIAG_V_INCFCOUNT |
| V_$DIAG_V_INC_METER_INFO_PROB |
| V_$DIAG_V_IPSPRBCNT |
| V_$DIAG_V_IPSPRBCNT1 |
| V_$DIAG_V_NFCINC |
| V_$DIAG_V_SWPERRCOUNT |
| V_$DNFS_CHANNELS |
| V_$DNFS_FILES |
| V_$DNFS_SERVERS |
| V_$DNFS_STATS |
| V_$DYNAMIC_REMASTER_STATS |
| V_$EMON |
| V_$ENCRYPTED_TABLESPACES |
| V_$FILE_OPTIMIZED_HISTOGRAM |
| V_$FLASHBACK_TXN_GRAPH |
| V_$FLASHBACK_TXN_MODS |
| V_$FOREIGN_ARCHIVED_LOG |
| V_$FS_FAILOVER_HISTOGRAM |
| V_$FS_FAILOVER_STATS |
| V_$GOLDENGATE_CAPTURE |
| V_$GOLDENGATE_MESSAGE_TRACKING |
| V_$GOLDENGATE_TRANSACTION |
| V_$HANG_INFO |
| V_$HANG_SESSION_INFO |
| V_$HM_CHECK |
| V_$HM_CHECK_PARAM |
| V_$HM_FINDING |
| V_$HM_INFO |
| V_$HM_RECOMMENDATION |
| V_$HM_RUN |
| V_$INCMETER_CONFIG |
| V_$INCMETER_INFO |
| V_$INCMETER_SUMMARY |
| V_$IOFUNCMETRIC |
| V_$IOFUNCMETRIC_HISTORY |
| V_$IOSTAT_CONSUMER_GROUP |
| V_$IOSTAT_FILE |
| V_$IOSTAT_FUNCTION |
| V_$IOSTAT_FUNCTION_DETAIL |
| V_$IOSTAT_NETWORK |
| V_$IO_CALIBRATION_STATUS |
| V_$IR_FAILURE |
| V_$IR_FAILURE_SET |
| V_$IR_MANUAL_CHECKLIST |
| V_$IR_REPAIR |
| V_$LIBCACHE_LOCKS |
| V_$LISTENER_NETWORK |
| V_$LOBSTAT |
| V_$MEMORY_CURRENT_RESIZE_OPS |
| V_$MEMORY_DYNAMIC_COMPONENTS |
| V_$MEMORY_RESIZE_OPS |
| V_$MEMORY_TARGET_ADVICE |
| V_$NFS_CLIENTS |
| V_$NFS_LOCKS |
| V_$NFS_OPEN_FILES |
| V_$OBJECT_DML_FREQUENCIES |
| V_$OBJECT_PRIVILEGE |
| V_$PERSISTENT_PUBLISHERS |
| V_$PERSISTENT_QMN_CACHE |
| V_$PERSISTENT_QUEUES |
| V_$PERSISTENT_SUBSCRIBERS |
| V_$POLICY_HISTORY |
| V_$PROCESS_GROUP |
| V_$PX_INSTANCE_GROUP |
| V_$QMON_COORDINATOR_STATS |
| V_$QMON_SERVER_STATS |
| V_$QMON_TASKS |
| V_$QMON_TASK_STATS |
| V_$RECOVERY_AREA_USAGE |
| V_$REDO_DEST_RESP_HISTOGRAM |
| V_$RESULT_CACHE_DEPENDENCY |
| V_$RESULT_CACHE_MEMORY |
| V_$RESULT_CACHE_OBJECTS |
| V_$RESULT_CACHE_STATISTICS |
| V_$RMAN_COMPRESSION_ALGORITHM |
| V_$RMAN_ENCRYPTION_ALGORITHMS |
| V_$RSRCMGRMETRIC |
| V_$RSRCMGRMETRIC_HISTORY |
| V_$SECUREFILE_TIMER |
| V_$SEGSPACE_USAGE |
| V_$SESSION_BLOCKERS |
| V_$SQLCOMMAND |
| V_$SQLFN_ARG_METADATA |
| V_$SQLFN_METADATA |
| V_$SQLPA_METRIC |
| V_$SQLSTATS_PLAN_HASH |
| V_$SQL_CS_HISTOGRAM |
| V_$SQL_CS_SELECTIVITY |
| V_$SQL_CS_STATISTICS |
| V_$SQL_FEATURE |
| V_$SQL_FEATURE_DEPENDENCY |
| V_$SQL_FEATURE_HIERARCHY |
| V_$SQL_HINT |
| V_$SQL_MONITOR |
| V_$SQL_PLAN_MONITOR |
| V_$SSCR_SESSIONS |
| V_$STANDBY_EVENT_HISTOGRAM |
| V_$STREAMS_MESSAGE_TRACKING |
| V_$STREAMS_POOL_STATISTICS |
| V_$SUBSCR_REGISTRATION_STATS |
| V_$TOPLEVELCALL |
| V_$WAIT_CHAINS |
| V_$WLM_PCMETRIC |
| V_$WLM_PCMETRIC_HISTORY |
| V_$WLM_PC_STATS |
| V_$WORKLOAD_REPLAY_THREAD |
| V_$XSTREAM_CAPTURE |
| V_$XSTREAM_MESSAGE_TRACKING |
| V_$XSTREAM_OUTBOUND_SERVER |
| V_$XSTREAM_TRANSACTION |
New V$ view columns:
| VIEW_NAME | COLUMN_NAME |
| V_$ACTIVE_SESSION_HISTORY | IS_AWR_SAMPLE |
| IS_SQLID_CURRENT | |
| SQL_OPNAME | |
| TOP_LEVEL_SQL_ID | |
| TOP_LEVEL_SQL_OPCODE | |
| SQL_PLAN_LINE_ID | |
| SQL_PLAN_OPERATION | |
| SQL_PLAN_OPTIONS | |
| SQL_EXEC_ID | |
| SQL_EXEC_START | |
| QC_SESSION_SERIAL# | |
| PX_FLAGS | |
| BLOCKING_INST_ID | |
| BLOCKING_HANGCHAIN_INFO | |
| CURRENT_ROW# | |
| TOP_LEVEL_CALL# | |
| TOP_LEVEL_CALL_NAME | |
| CONSUMER_GROUP_ID | |
| REMOTE_INSTANCE# | |
| TIME_MODEL | |
| IN_CONNECTION_MGMT | |
| IN_PARSE | |
| IN_HARD_PARSE | |
| IN_SQL_EXECUTION | |
| IN_PLSQL_EXECUTION | |
| IN_PLSQL_RPC | |
| IN_PLSQL_COMPILATION | |
| IN_JAVA_EXECUTION | |
| IN_BIND | |
| IN_CURSOR_CLOSE | |
| IN_SEQUENCE_LOAD | |
| CAPTURE_OVERHEAD | |
| REPLAY_OVERHEAD | |
| IS_CAPTURED | |
| IS_REPLAYED | |
| MACHINE | |
| PORT | |
| ECID | |
| DBREPLAY_FILE_ID | |
| DBREPLAY_CALL_COUNTER | |
| TM_DELTA_TIME | |
| TM_DELTA_CPU_TIME | |
| TM_DELTA_DB_TIME | |
| DELTA_TIME | |
| DELTA_READ_IO_REQUESTS | |
| DELTA_WRITE_IO_REQUESTS | |
| DELTA_READ_IO_BYTES | |
| DELTA_WRITE_IO_BYTES | |
| DELTA_INTERCONNECT_IO_BYTES | |
| PGA_ALLOCATED | |
| TEMP_SPACE_ALLOCATED | |
| V_$ADVISOR_PROGRESS | EXECUTION_TYPE |
| V_$AQ | AVERAGE_MSG_AGE |
| V_$AQ1 | AVERAGE_MSG_AGE |
| V_$ARCHIVED_LOG | BACKED_BY_VSS |
| V_$ARCHIVE_DEST | COMPRESSION |
| APPLIED_SCN | |
| V_$ARCHIVE_DEST_STATUS | GAP_STATUS |
| V_$ASM_DISK | OS_MB |
| HOT_USED_MB | |
| COLD_USED_MB | |
| PREFERRED_READ | |
| HASH_VALUE | |
| HOT_READS | |
| HOT_WRITES | |
| HOT_BYTES_READ | |
| HOT_BYTES_WRITTEN | |
| COLD_READS | |
| COLD_WRITES | |
| COLD_BYTES_READ | |
| COLD_BYTES_WRITTEN | |
| VOTING_FILE | |
| SECTOR_SIZE | |
| FAILGROUP_TYPE | |
| V_$ASM_DISKGROUP | HOT_USED_MB |
| COLD_USED_MB | |
| VOTING_FILES | |
| V_$ASM_DISKGROUP_STAT | HOT_USED_MB |
| COLD_USED_MB | |
| VOTING_FILES | |
| V_$ASM_DISK_STAT | OS_MB |
| HOT_USED_MB | |
| COLD_USED_MB | |
| PREFERRED_READ | |
| HASH_VALUE | |
| HOT_READS | |
| HOT_WRITES | |
| HOT_BYTES_READ | |
| HOT_BYTES_WRITTEN | |
| COLD_READS | |
| COLD_WRITES | |
| COLD_BYTES_READ | |
| COLD_BYTES_WRITTEN | |
| VOTING_FILE | |
| SECTOR_SIZE | |
| FAILGROUP_TYPE | |
| V_$ASM_FILE | PERMISSIONS |
| USER_NUMBER | |
| USER_INCARNATION | |
| USERGROUP_NUMBER | |
| USERGROUP_INCARNATION | |
| PRIMARY_REGION | |
| MIRROR_REGION | |
| HOT_READS | |
| HOT_WRITES | |
| HOT_BYTES_READ | |
| HOT_BYTES_WRITTEN | |
| COLD_READS | |
| COLD_WRITES | |
| COLD_BYTES_READ | |
| COLD_BYTES_WRITTEN | |
| V_$ASM_OPERATION | ERROR_CODE |
| V_$ASM_TEMPLATE | PRIMARY_REGION |
| MIRROR_REGION | |
| V_$AW_LONGOPS | SEQ_NUMBER |
| SQL_ID | |
| TARGET | |
| TARGET_DESC | |
| LAST_UPDATE_TIME | |
| ELAPSED_SECONDS | |
| SOFAR | |
| TOTALWORK | |
| UNITS | |
| MESSAGE | |
| USERNAME | |
| V_$BACKUP_DATAFILE | FOREIGN_DBID |
| PLUGGED_READONLY | |
| PLUGIN_CHANGE# | |
| PLUGIN_RESETLOGS_CHANGE# | |
| PLUGIN_RESETLOGS_TIME | |
| SECTION_SIZE | |
| UNDO_OPTIMIZED | |
| BLOCKS_SKIPPED_IN_CELL | |
| V_$BACKUP_PIECE | BACKED_BY_VSS |
| ENCRYPTED | |
| BACKED_BY_OSB | |
| V_$BACKUP_PIECE_DETAILS | BACKED_BY_VSS |
| ENCRYPTED | |
| BACKED_BY_OSB | |
| V_$BACKUP_SET | MULTI_SECTION |
| V_$BACKUP_SET_DETAILS | ENCRYPTED |
| BACKED_BY_OSB | |
| V_$BACKUP_SPFILE | DB_UNIQUE_NAME |
| V_$BH | LOBID |
| CACHEHINT | |
| V_$BUFFERED_PUBLISHERS | ELAPSED_ENQUEUE_TIME |
| ENQUEUE_CPU_TIME | |
| LAST_ENQUEUE_TIME | |
| V_$BUFFERED_QUEUES | OLDEST_MSGID |
| OLDEST_MSG_ENQTM | |
| QUEUE_STATE | |
| ELAPSED_ENQUEUE_TIME | |
| ELAPSED_DEQUEUE_TIME | |
| ELAPSED_TRANSFORMATION_TIME | |
| ELAPSED_RULE_EVALUATION_TIME | |
| ENQUEUE_CPU_TIME | |
| DEQUEUE_CPU_TIME | |
| AVG_MSG_AGE | |
| LAST_ENQUEUE_TIME | |
| LAST_DEQUEUE_TIME | |
| QUEUE_SIZE | |
| V_$BUFFERED_SUBSCRIBERS | ELAPSED_DEQUEUE_TIME |
| DEQUEUE_CPU_TIME | |
| AVG_MSG_AGE | |
| LAST_DEQUEUE_TIME | |
| OLDEST_MSGID | |
| OLDEST_MSG_ENQTM | |
| V_$CR_BLOCK_SERVER | OTHER_REQUESTS |
| STALE | |
| V_$CURRENT_BLOCK_SERVER | CLEANDC |
| RCVDC | |
| QUEUEDC | |
| EVICTDC | |
| WRITEDC | |
| V_$DATABASE | CONTROLFILE_CONVERTED |
| PRIMARY_DB_UNIQUE_NAME | |
| SUPPLEMENTAL_LOG_DATA_PL | |
| MIN_REQUIRED_CAPTURE_CHANGE# | |
| V_$DATAFILE | FOREIGN_DBID |
| FOREIGN_CREATION_CHANGE# | |
| FOREIGN_CREATION_TIME | |
| PLUGGED_READONLY | |
| PLUGIN_CHANGE# | |
| PLUGIN_RESETLOGS_CHANGE# | |
| PLUGIN_RESETLOGS_TIME | |
| V_$DATAFILE_COPY | CONVERTED_FILE |
| SAME_ENDIAN | |
| FOREIGN_DBID | |
| PLUGGED_READONLY | |
| PLUGIN_CHANGE# | |
| PLUGIN_RESETLOGS_CHANGE# | |
| PLUGIN_RESETLOGS_TIME | |
| BACKED_BY_VSS | |
| V_$DATAFILE_HEADER | LAST_DEALLOC_CHANGE# |
| UNDO_OPT_CURRENT_CHANGE# | |
| V_$DATAGUARD_STATS | DATUM_TIME |
| V_$DATAPUMP_JOB | SERIALNUM |
| QUEUE_TABNUM | |
| V_$DB_OBJECT_CACHE | HASH_VALUE |
| LOCK_MODE | |
| PIN_MODE | |
| STATUS | |
| TIMESTAMP | |
| PREVIOUS_TIMESTAMP | |
| LOCKED_TOTAL | |
| PINNED_TOTAL | |
| V_$EVENTMETRIC | TIME_WAITED_FG |
| WAIT_COUNT_FG | |
| V_$EVENT_HISTOGRAM | LAST_UPDATE_TIME |
| V_$FILESTAT | OPTIMIZED_PHYBLKRD |
| V_$FLASHBACK_DATABASE_LOGFILE | TYPE |
| V_$GCSPFMASTER_INFO | DATA_OBJECT_ID |
| GC_MASTERING_POLICY | |
| V_$INSTANCE_CACHE_TRANSFER | LOST |
| LOST_TIME | |
| CR_BLOCK_TIME | |
| CR_2HOP | |
| CR_2HOP_TIME | |
| CR_3HOP | |
| CR_3HOP_TIME | |
| CR_BUSY_TIME | |
| CR_CONGESTED_TIME | |
| CURRENT_BLOCK_TIME | |
| CURRENT_2HOP | |
| CURRENT_2HOP_TIME | |
| CURRENT_3HOP | |
| CURRENT_3HOP_TIME | |
| CURRENT_BUSY_TIME | |
| CURRENT_CONGESTED_TIME | |
| V_$KCCDI | DIDBOP |
| DIBFN | |
| DIBSQ | |
| V_$KCCFE | FEPLUS |
| FEPRLS | |
| FEPRLT | |
| FEFCRS | |
| FEFCRT | |
| FEFCPS | |
| FEFCPT | |
| FEMVST | |
| V_$LOG | BLOCKSIZE |
| NEXT_CHANGE# | |
| NEXT_TIME | |
| V_$LOGMNR_CONTENTS | START_SCN |
| COMMIT_SCN | |
| START_TIMESTAMP | |
| OS_USERNAME | |
| MACHINE_NAME | |
| OBJECT_ID | |
| EDITION_NAME | |
| CLIENT_ID | |
| V_$LOGMNR_LOGS | COMPATIBLE |
| V_$LOGSTDBY_PROGRESS | RESETLOGS_ID |
| V_$LOGSTDBY_TRANSACTION | PRIMARY_XIDUSN |
| PRIMARY_XIDSLT | |
| PRIMARY_XIDSQN | |
| PRIMARY_PARENT_XIDUSN | |
| PRIMARY_PARENT_XIDSLT | |
| PRIMARY_PARENT_XIDSQN | |
| TYPE | |
| V_$OPEN_CURSOR | LAST_SQL_ACTIVE_TIME |
| SQL_EXEC_ID | |
| CURSOR_TYPE | |
| V_$OSSTAT | COMMENTS |
| CUMULATIVE | |
| V_$PARAMETER | ISBASIC |
| V_$PARAMETER2 | ISBASIC |
| V_$PGA_TARGET_ADVICE | ESTD_TIME |
| V_$PROCESS | PNAME |
| TRACEFILE | |
| V_$PROPAGATION_RECEIVER | LAST_RECEIVED_MSG |
| SESSION_ID | |
| SERIAL# | |
| SPID | |
| PROPAGATION_NAME | |
| STATE | |
| LAST_RECEIVED_MSG_POSITION | |
| ACKNOWLEGEMENT_POSITION | |
| V_$PROPAGATION_SENDER | ELAPSED_RULE_TIME |
| LAST_MSG_LATENCY | |
| LAST_MSG_ENQUEUE_TIME | |
| LAST_MSG_PROPAGATION_TIME | |
| LAST_LCR_LATENCY | |
| LAST_LCR_CREATION_TIME | |
| LAST_LCR_PROPAGATION_TIME | |
| DST_DATABASE_NAME | |
| SESSION_ID | |
| SERIAL# | |
| SPID | |
| PROPAGATION_NAME | |
| STATE | |
| V_$PROXY_ARCHIVEDLOG | KEEP |
| KEEP_UNTIL | |
| KEEP_OPTIONS | |
| V_$PROXY_ARCHIVELOG_DETAILS | KEEP |
| KEEP_UNTIL | |
| KEEP_OPTIONS | |
| V_$PROXY_DATAFILE | FOREIGN_DBID |
| PLUGGED_READONLY | |
| PLUGIN_CHANGE# | |
| PLUGIN_RESETLOGS_CHANGE# | |
| PLUGIN_RESETLOGS_TIME | |
| V_$PWFILE_USERS | SYSASM |
| V_$RECOVERY_PROGRESS | COMMENTS |
| V_$RESTORE_POINT | RESTORE_POINT_TIME |
| PRESERVED | |
| V_$RMAN_BACKUP_JOB_DETAILS | BACKED_BY_OSB |
| V_$RMAN_BACKUP_SUBJOB_DETAILS | BACKED_BY_OSB |
| V_$RMAN_STATUS | OSB_ALLOCATED |
| V_$RSRC_CONSUMER_GROUP | CPU_DECISIONS |
| CPU_DECISIONS_EXCLUSIVE | |
| CPU_DECISIONS_WON | |
| SWITCHES_IN_CPU_TIME | |
| SWITCHES_OUT_CPU_TIME | |
| SWITCHES_IN_IO_MEGABYTES | |
| SWITCHES_OUT_IO_MEGABYTES | |
| SWITCHES_IN_IO_REQUESTS | |
| SWITCHES_OUT_IO_REQUESTS | |
| IO_SERVICE_TIME | |
| IO_SERVICE_WAITS | |
| SMALL_READ_MEGABYTES | |
| SMALL_WRITE_MEGABYTES | |
| LARGE_READ_MEGABYTES | |
| LARGE_WRITE_MEGABYTES | |
| SMALL_READ_REQUESTS | |
| SMALL_WRITE_REQUESTS | |
| LARGE_READ_REQUESTS | |
| LARGE_WRITE_REQUESTS | |
| CURRENT_PQS_ACTIVE | |
| CURRENT_PQ_SERVERS_ACTIVE | |
| PQS_QUEUED | |
| PQS_COMPLETED | |
| PQ_SERVERS_USED | |
| PQ_ACTIVE_TIME | |
| CURRENT_PQS_QUEUED | |
| PQ_QUEUED_TIME | |
| PQ_QUEUE_TIME_OUTS | |
| V_$RSRC_CONS_GROUP_HISTORY | CPU_DECISIONS |
| CPU_DECISIONS_EXCLUSIVE | |
| CPU_DECISIONS_WON | |
| SWITCHES_IN_CPU_TIME | |
| SWITCHES_OUT_CPU_TIME | |
| SWITCHES_IN_IO_MEGABYTES | |
| SWITCHES_OUT_IO_MEGABYTES | |
| SWITCHES_IN_IO_REQUESTS | |
| SWITCHES_OUT_IO_REQUESTS | |
| IO_SERVICE_TIME | |
| IO_SERVICE_WAITS | |
| SMALL_READ_MEGABYTES | |
| SMALL_WRITE_MEGABYTES | |
| LARGE_READ_MEGABYTES | |
| LARGE_WRITE_MEGABYTES | |
| SMALL_READ_REQUESTS | |
| SMALL_WRITE_REQUESTS | |
| LARGE_READ_REQUESTS | |
| LARGE_WRITE_REQUESTS | |
| PQS_COMPLETED | |
| PQ_SERVERS_USED | |
| PQS_QUEUED | |
| PQ_ACTIVE_TIME | |
| PQ_QUEUED_TIME | |
| PQ_QUEUE_TIME_OUTS | |
| V_$RSRC_PLAN | CPU_MANAGED |
| INSTANCE_CAGING | |
| PARALLEL_SERVERS_ACTIVE | |
| PARALLEL_SERVERS_TOTAL | |
| PARALLEL_EXECUTION_MANAGED | |
| V_$RSRC_PLAN_HISTORY | CPU_MANAGED |
| INSTANCE_CAGING | |
| PARALLEL_EXECUTION_MANAGED | |
| V_$RSRC_SESSION_INFO | CURRENT_IO_SERVICE_TIME |
| IO_SERVICE_TIME | |
| CURRENT_IO_SERVICE_WAITS | |
| IO_SERVICE_WAITS | |
| CURRENT_SMALL_READ_MEGABYTES | |
| SMALL_READ_MEGABYTES | |
| CURRENT_LARGE_READ_MEGABYTES | |
| LARGE_READ_MEGABYTES | |
| CURRENT_SMALL_WRITE_MEGABYTES | |
| SMALL_WRITE_MEGABYTES | |
| CURRENT_LARGE_WRITE_MEGABYTES | |
| LARGE_WRITE_MEGABYTES | |
| CURRENT_SMALL_READ_REQUESTS | |
| SMALL_READ_REQUESTS | |
| CURRENT_SMALL_WRITE_REQUESTS | |
| SMALL_WRITE_REQUESTS | |
| CURRENT_LARGE_READ_REQUESTS | |
| LARGE_READ_REQUESTS | |
| CURRENT_LARGE_WRITE_REQUESTS | |
| LARGE_WRITE_REQUESTS | |
| CURRENT_PQ_ACTIVE_TIME | |
| PQ_ACTIVE_TIME | |
| DOP | |
| ESTIMATED_EXECUTION_TIME | |
| CURRENT_PQ_QUEUED_TIME | |
| PQ_QUEUED_TIME | |
| PQ_QUEUED | |
| PQ_QUEUE_TIME_OUTS | |
| PQ_ACTIVE | |
| V_$SESSION | PORT |
| SQL_EXEC_START | |
| SQL_EXEC_ID | |
| PREV_EXEC_START | |
| PREV_EXEC_ID | |
| TOP_LEVEL_CALL# | |
| FINAL_BLOCKING_SESSION_STATUS | |
| FINAL_BLOCKING_INSTANCE | |
| FINAL_BLOCKING_SESSION | |
| WAIT_TIME_MICRO | |
| TIME_REMAINING_MICRO | |
| TIME_SINCE_LAST_WAIT_MICRO | |
| SQL_TRACE_PLAN_STATS | |
| SESSION_EDITION_ID | |
| CREATOR_ADDR | |
| CREATOR_SERIAL# | |
| ECID | |
| V_$SESSION_CONNECT_INFO | SERIAL# |
| CLIENT_CHARSET | |
| CLIENT_CONNECTION | |
| CLIENT_OCI_LIBRARY | |
| CLIENT_VERSION | |
| CLIENT_DRIVER | |
| CLIENT_LOBATTR | |
| CLIENT_REGID | |
| V_$SESSION_FIX_CONTROL | SQL_FEATURE |
| V_$SESSION_LONGOPS | SQL_PLAN_HASH_VALUE |
| SQL_EXEC_START | |
| SQL_EXEC_ID | |
| SQL_PLAN_LINE_ID | |
| SQL_PLAN_OPERATION | |
| SQL_PLAN_OPTIONS | |
| V_$SESSION_WAIT | WAIT_TIME_MICRO |
| TIME_REMAINING_MICRO | |
| TIME_SINCE_LAST_WAIT_MICRO | |
| V_$SESSION_WAIT_HISTORY | WAIT_TIME_MICRO |
| TIME_SINCE_LAST_WAIT_MICRO | |
| V_$SESS_IO | OPTIMIZED_PHYSICAL_READS |
| V_$SES_OPTIMIZER_ENV | SQL_FEATURE |
| V_$SHARED_SERVER | IN_NET |
| OUT_NET | |
| V_$SPPARAMETER | TYPE |
| V_$SQL | IS_BIND_SENSITIVE |
| IS_BIND_AWARE | |
| IS_SHAREABLE | |
| SQL_PATCH | |
| SQL_PLAN_BASELINE | |
| IO_CELL_OFFLOAD_ELIGIBLE_BYTES | |
| IO_INTERCONNECT_BYTES | |
| PHYSICAL_READ_REQUESTS | |
| PHYSICAL_READ_BYTES | |
| PHYSICAL_WRITE_REQUESTS | |
| PHYSICAL_WRITE_BYTES | |
| OPTIMIZED_PHY_READ_REQUESTS | |
| LOCKED_TOTAL | |
| PINNED_TOTAL | |
| IO_CELL_UNCOMPRESSED_BYTES | |
| IO_CELL_OFFLOAD_RETURNED_BYTES | |
| V_$SQLAREA | IS_BIND_SENSITIVE |
| IS_BIND_AWARE | |
| SQL_PATCH | |
| SQL_PLAN_BASELINE | |
| IO_CELL_OFFLOAD_ELIGIBLE_BYTES | |
| IO_INTERCONNECT_BYTES | |
| PHYSICAL_READ_REQUESTS | |
| PHYSICAL_READ_BYTES | |
| PHYSICAL_WRITE_REQUESTS | |
| PHYSICAL_WRITE_BYTES | |
| OPTIMIZED_PHY_READ_REQUESTS | |
| LOCKED_TOTAL | |
| PINNED_TOTAL | |
| IO_CELL_UNCOMPRESSED_BYTES | |
| IO_CELL_OFFLOAD_RETURNED_BYTES | |
| V_$SQLAREA_PLAN_HASH | IO_CELL_OFFLOAD_ELIGIBLE_BYTES |
| IO_INTERCONNECT_BYTES | |
| PHYSICAL_READ_REQUESTS | |
| PHYSICAL_READ_BYTES | |
| PHYSICAL_WRITE_REQUESTS | |
| PHYSICAL_WRITE_BYTES | |
| OPTIMIZED_PHY_READ_REQUESTS | |
| IO_CELL_UNCOMPRESSED_BYTES | |
| IO_CELL_OFFLOAD_RETURNED_BYTES | |
| V_$SQLSTATS | IO_CELL_OFFLOAD_ELIGIBLE_BYTES |
| IO_INTERCONNECT_BYTES | |
| PHYSICAL_READ_REQUESTS | |
| PHYSICAL_READ_BYTES | |
| PHYSICAL_WRITE_REQUESTS | |
| PHYSICAL_WRITE_BYTES | |
| EXACT_MATCHING_SIGNATURE | |
| FORCE_MATCHING_SIGNATURE | |
| IO_CELL_UNCOMPRESSED_BYTES | |
| IO_CELL_OFFLOAD_RETURNED_BYTES | |
| V_$SQL_SHARED_CURSOR | FORCE_HARD_PARSE |
| BIND_EQUIV_FAILURE | |
| EDITION_MISMATCH | |
| PDDL_ENV_MISMATCH | |
| CROSSEDITION_TRIGGER_MISMATCH | |
| PLSQL_DEBUG | |
| LOAD_OPTIMIZER_STATS | |
| ACL_MISMATCH | |
| FLASHBACK_ARCHIVE_MISMATCH | |
| LOCK_USER_SCHEMA_FAILED | |
| REMOTE_MAPPING_MISMATCH | |
| LOAD_RUNTIME_HEAP_FAILED | |
| HASH_MATCH_FAILED | |
| PURGED_CURSOR | |
| BIND_LENGTH_UPGRADEABLE | |
| USE_FEEDBACK_STATS | |
| REASON | |
| V_$SQL_WORKAREA_ACTIVE | SQL_EXEC_START |
| SQL_EXEC_ID | |
| V_$STANDBY_LOG | BLOCKSIZE |
| NEXT_CHANGE# | |
| NEXT_TIME | |
| V_$STREAMS_APPLY_COORDINATOR | UNASSIGNED_COMPLETE_TXNS |
| AUTO_TXN_BUFFER_SIZE | |
| LWM_POSITION | |
| HWM_POSITION | |
| PROCESSED_MESSAGE_NUMBER | |
| V_$STREAMS_APPLY_READER | SPILL_LWM_SCN |
| PROXY_SID | |
| PROXY_SERIAL | |
| PROXY_SPID | |
| CAPTURE_BYTES_RECEIVED | |
| DEQUEUED_POSITION | |
| LAST_BROWSE_POSITION | |
| OLDEST_POSITION | |
| SPILL_LWM_POSITION | |
| OLDEST_TRANSACTION_ID | |
| TOTAL_LCRS_WITH_DEP | |
| TOTAL_LCRS_WITH_WMDEP | |
| TOTAL_IN_MEMORY_LCRS | |
| SGA_ALLOCATED | |
| V_$STREAMS_APPLY_SERVER | COMMIT_POSITION |
| DEP_COMMIT_POSITION | |
| LAST_APPLY_POSITION | |
| TRANSACTION_ID | |
| DEP_TRANSACTION_ID | |
| V_$STREAMS_CAPTURE | APPLY_NAME |
| APPLY_DBLINK | |
| APPLY_MESSAGES_SENT | |
| APPLY_BYTES_SENT | |
| OPTIMIZATION | |
| PURPOSE | |
| SGA_USED | |
| SGA_ALLOCATED | |
| BYTES_OF_REDO_MINED | |
| SESSION_RESTART_SCN | |
| V_$STREAMS_TRANSACTION | FIRST_MESSAGE_POSITION |
| LAST_MESSAGE_POSITION | |
| TRANSACTION_ID | |
| PURPOSE | |
| V_$SYSTEM_EVENT | TOTAL_WAITS_FG |
| TOTAL_TIMEOUTS_FG | |
| TIME_WAITED_FG | |
| AVERAGE_WAIT_FG | |
| TIME_WAITED_MICRO_FG | |
| V_$SYSTEM_FIX_CONTROL | SQL_FEATURE |
| V_$SYSTEM_PARAMETER | ISBASIC |
| V_$SYSTEM_PARAMETER2 | ISBASIC |
| V_$SYSTEM_WAIT_CLASS | TOTAL_WAITS_FG |
| TIME_WAITED_FG | |
| V_$SYS_OPTIMIZER_ENV | SQL_FEATURE |
| V_$WAITCLASSMETRIC | TIME_WAITED_FG |
| WAIT_COUNT_FG | |
| V_$WAITCLASSMETRIC_HISTORY | TIME_WAITED_FG |
| WAIT_COUNT_FG | |
| V_$XML_AUDIT_TRAIL | OBJ_EDITION_NAME |
| DBID |
Advertisements
Pingback: 11.2 New views « Oracle Scratchpad