Oracle 11gR2 new v$ views and columns as compared to 10gR2

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
This entry was posted in Uncategorized. Bookmark the permalink.

One Response to Oracle 11gR2 new v$ views and columns as compared to 10gR2

  1. Pingback: 11.2 New views « Oracle Scratchpad

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s