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