Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

What's New in Oracle Database Reference?

This section describes new features of Oracle Database 10g release 2 (10.2) and provides pointers to additional information. New features information from release 1 (10.1) is also retained to help those users upgrading to the current release. For information on features that were new in earlier releases of the Oracle Database, refer to the documentation for the earlier release.

The following sections describe the new features in Oracle Database Reference:

Oracle Database 10g Release 2 (10.2) New Features

The following initialization parameters are new to release 10.2:


AUDIT_SYSLOG_LEVEL
COMMIT_WRITE
OPTIMIZER_SECURE_VIEW_MERGING
PLSQL_CCFLAGS
PRE_11G_ENABLE_CAPTURE
RECYCLEBIN

See Also:

Part I, "Initialization Parameters" for more information about these initialization parameters

The following static data dictionary views are new to release 10.2:

ALL_ Views DBA_ Views USER_ Views
ALL_DEQUEUE_QUEUES    
  DBA_APPLY_OBJECT_DEPENDENCIES  
  DBA_APPLY_SPILL_TXN  
  DBA_APPLY_VALUE_DEPENDENCIES  
  DBA_AUTO_SEGADV_CTL  
  DBA_AUTO_SEGADV_SUMMARY  
  DBA_CHANGE_NOTIFICATION_REGS USER_CHANGE_NOTIFICATION_REGS
  DBA_CONNECT_ROLE_GRANTEES  
  DBA_CPU_USAGE_STATISTICS  
ALL_ENCRYPTED_COLUMNS DBA_ENCRYPTED_COLUMNS USER_ENCRYPTED_COLUMNS
ALL_FILE_GROUP_EXPORT_INFO DBA_FILE_GROUP_EXPORT_INFO USER_FILE_GROUP_EXPORT_INFO
ALL_FILE_GROUP_FILES DBA_FILE_GROUP_FILES USER_FILE_GROUP_FILES
ALL_FILE_GROUP_TABLES DBA_FILE_GROUP_TABLES USER_FILE_GROUP_TABLES
ALL_FILE_GROUP_TABLESPACES DBA_FILE_GROUP_TABLESPACES USER_FILE_GROUP_TABLESPACES
ALL_FILE_GROUP_VERSIONS DBA_FILE_GROUP_VERSIONS USER_FILE_GROUP_VERSIONS
ALL_FILE_GROUPS DBA_FILE_GROUPS USER_FILE_GROUPS
  DBA_HIST_BUFFERED_QUEUES  
  DBA_HIST_BUFFERED_SUBSCRIBERS  
  DBA_HIST_COMP_IOSTAT  
  DBA_HIST_PROCESS_MEM_SUMMARY  
  DBA_HIST_RULE_SET  
  DBA_HIST_SESS_TIME_STATS  
  DBA_HIST_SGA_TARGET_ADVICE  
  DBA_HIST_SQL_BIND_METADATA  
  DBA_HIST_STREAMS_APPLY_SUM  
  DBA_HIST_STREAMS_CAPTURE  
  DBA_HIST_STREAMS_POOL_ADVICE  
ALL_QUEUE_SUBSCRIBERS DBA_QUEUE_SUBSCRIBERS USER_QUEUE_SUBSCRIBERS
  DBA_RECOVERABLE_SCRIPT  
  DBA_RECOVERABLE_SCRIPT_BLOCKS  
  DBA_RECOVERABLE_SCRIPT_ERRORS  
  DBA_RECOVERABLE_SCRIPT_PARAMS  
  DBA_REGISTRY_HISTORY  
  DBA_REGISTRY_LOG  
  DBA_RESOURCE_INCARNATIONS  
ALL_SCHEDULER_CHAIN_RULES DBA_SCHEDULER_CHAIN_RULES USER_SCHEDULER_CHAIN_RULES
ALL_SCHEDULER_CHAIN_STEPS DBA_SCHEDULER_CHAIN_STEPS USER_SCHEDULER_CHAIN_STEPS
ALL_SCHEDULER_CHAINS DBA_SCHEDULER_CHAINS USER_SCHEDULER_CHAINS
ALL_SCHEDULER_RUNNING_CHAINS DBA_SCHEDULER_RUNNING_CHAINS USER_SCHEDULER_RUNNING_CHAINS
  DBA_SEGMENTS_OLD  
ALL_SQLSET    
ALL_SQLSET_BINDS    
ALL_SQLSET_PLANS DBA_SQLSET_PLANS USER_SQLSET_PLANS
ALL_SQLSET_REFERENCES    
ALL_SQLSET_STATEMENTS    
  DBA_STREAMS_ADD_COLUMN  
  DBA_STREAMS_DELETE_COLUMN  
  DBA_STREAMS_RENAME_COLUMN  
  DBA_STREAMS_RENAME_SCHEMA  
  DBA_STREAMS_RENAME_TABLE  
  DBA_STREAMS_TRANSFORMATIONS  
  DBA_TSM_DESTINATION  
  DBA_TSM_SOURCE  
  DBA_WORKLOAD_CAPTURES  
  DBA_WORKLOAD_FILTERS  

See Also:

Part II, "Static Data Dictionary Views" for more information about these static data dictionary views

The following dynamic performance views are new to release 10.2:

GV$ Views V$ Views
GV$ASM_DISK_STAT V$ASM_DISK_STAT
GV$ASM_DISKGROUP_STAT V$ASM_DISKGROUP_STAT
  V$BACKUP_ARCHIVELOG_DETAILS
  V$BACKUP_ARCHIVELOG_SUMMARY
  V$BACKUP_CONTROLFILE_DETAILS
  V$BACKUP_CONTROLFILE_SUMMARY
  V$BACKUP_COPY_DETAILS
  V$BACKUP_COPY_SUMMARY
  V$BACKUP_DATAFILE_DETAILS
  V$BACKUP_DATAFILE_SUMMARY
  V$BACKUP_PIECE_DETAILS
  V$BACKUP_SET_DETAILS
  V$BACKUP_SET_SUMMARY
  V$BACKUP_SPFILE_DETAILS
  V$BACKUP_SPFILE_SUMMARY
GV$BLOCKING_QUIESCE V$BLOCKING_QUIESCE
GV$CLUSTER_INTERCONNECTS V$CLUSTER_INTERCONNECTS
GV$CONFIGURED_INTERCONNECTS V$CONFIGURED_INTERCONNECTS
  V$DATAGUARD_STATS
  V$DB_TRANSPORTABLE_PLATFORM
  V$FLASH_RECOVERY_AREA_USAGE
GV$LOGMNR_DICTIONARY_LOAD V$LOGMNR_DICTIONARY_LOAD
GV$LOGSTDBY_PROCESS V$LOGSTDBY_PROCESS
GV$LOGSTDBY_PROGRESS V$LOGSTDBY_PROGRESS
GV$LOGSTDBY_STATE V$LOGSTDBY_STATE
GV$LOGSTDBY_TRANSACTION V$LOGSTDBY_TRANSACTION
GV$MUTEX_SLEEP V$MUTEX_SLEEP
GV$MUTEX_SLEEP_HISTORY V$MUTEX_SLEEP_HISTORY
GV$PROCESS_MEMORY V$PROCESS_MEMORY
GV$PARAMETER_VALID_VALUES V$PARAMETER_VALID_VALUES
  V$PROXY_ARCHIVELOG_DETAILS
  V$PROXY_ARCHIVELOG_SUMMARY
  V$PROXY_COPY_DETAILS
  V$PROXY_COPY_SUMMARY
GV$RESERVED_WORDS V$RESERVED_WORDS
GV$RESTORE_POINT V$RESTORE_POINT
GV$RFS_THREAD V$RFS_THREAD
  V$RMAN_BACKUP_JOB_DETAILS
  V$RMAN_BACKUP_SUBJOB_DETAILS
  V$RMAN_BACKUP_TYPE
  V$RMAN_ENCRYPTION_ALGORITHMS
GV$RSRC_CONS_GROUP_HISTORY V$RSRC_CONS_GROUP_HISTORY
GV$RSRC_PLAN_HISTORY V$RSRC_PLAN_HISTORY
GV$RSRC_SESSION_INFO V$RSRC_SESSION_INFO
GV$SCHEDULER_RUNNING_JOBS V$SCHEDULER_RUNNING_JOBS
GV$SGA_TARGET_ADVICE V$SGA_TARGET_ADVICE
GV$SQL_JOIN_FILTER V$SQL_JOIN_FILTER
GV$SQLAREA_PLAN_HASH V$SQLAREA_PLAN_HASH
GV$SQLSTATS V$SQLSTATS
GV$STREAMS_POOL_ADVICE V$STREAMS_POOL_ADVICE
GV$STREAMS_TRANSACTION V$STREAMS_TRANSACTION
GV$TSM_SESSIONS V$TSM_SESSIONS
  V$UNUSABLE_BACKUPFILE_DETAILS
GV$WALLET V$WALLET
GV$XML_AUDIT_TRAIL V$XML_AUDIT_TRAIL

See Also:

Part III, "Dynamic Performance Views" for more information about these dynamic performance views

The following static data dictionary views have new columns in release 10.2:

Static Data Dictionary Views New Columns
ALL_DEF_AUDIT_OPTS REA
ALL_PROPAGATION ERROR_DATE

ERROR_MESSAGE

ERROR_STATUS

ALL_SCHEDULER_JOBS SCHEDULE_TYPE
ALL_SCHEDULER_PROGRAMS DETACHED
ALL_SCHEDULER_RUNNING_CHAINS JOB_SUBNAME

STEP_JOB_LOG_ID

ALL_SCHEDULER_RUNNING_JOBS SLAVE_OS_PROCESS_ID
ALL_SCHEDULER_SCHEDULES SCHEDULE_TYPE
ALL_SCHEDULER_WINDOW_GROUPS NEXT_START_DATE
ALL_SCHEDULER_WINDOWS MANUAL_DURATION

MANUAL_OPEN_TIME

SCHEDULE_TYPE

ALL_SERVICES CLB_GOAL
ALL_STREAMS_TRANSFORM_FUNCTION CUSTOM_TYPE
DBA_ADVISOR_OBJECTS OTHER
DBA_AUDIT_EXISTS ECONTEXT_ID
DBA_AUDIT_OBJECT ECONTEXT_ID
DBA_AUDIT_STATEMENT ECONTEXT_ID
DBA_AUDIT_TRAIL ECONTEXT_ID
DBA_COMMON_AUDIT_TRAIL OS_PRIVILEGE

ECONTEXT_ID

DBA_FGA_AUDIT_TRAIL ECONTEXT_ID
DBA_HIST_SQLSTAT FORCE_MATCHING_SIGNATURE

BIND_DATA

DBA_HIST_ACTIVE_SESS_HISTORY P1TEXT

P2TEXT

P3TEXT

PX_SERVERS_EXECS_DELTA

PX_SERVERS_EXECS_TOTAL

PARSING_SCHEMA_NAME

BLOCKING_SESSION_SERIAL#

FORCE_MATCHING_SIGNATURE

DBA_PROPAGATION ERROR_DATE

ERROR_MESSAGE

ERROR_STATUS

DBA_REGISTERED_ARCHIVED_LOG RESETLOGS_CHANGE#

RESET_TIMESTAMP

DBA_SCHEDULER_JOBS SCHEDULE_TYPE
DBA_SCHEDULER_RUNNING_CHAINS JOB_SUBNAME

STEP_JOB_LOG_ID

DBA_SCHEDULER_RUNNING_JOBS SLAVE_OS_PROCESS_ID
DBA_SCHEDULER_SCHEDULES SCHEDULE_TYPE
DBA_SCHEDULER_WINDOW_GROUPS NEXT_START_DATE
DBA_SCHEDULER_WINDOWS MANUAL_DURATION

MANUAL_OPEN_TIME

SCHEDULE_TYPE

DBA_SERVICES CLB_GOAL
DBA_SQLTUNE_STATISTICS DIRECT_WRITES
DBA_STREAMS_TRANSFORM_FUNCTION CUSTOM_TYPE
DBA_TS_QUOTAS DROPPED
USER_AUDIT_OBJECT ECONTEXT_ID
USER_AUDIT_STATEMENT ECONTEXT_ID
USER_AUDIT_TRAIL ECONTEXT_ID
USER_SCHEDULER_JOBS SCHEDULE_TYPE
USER_SCHEDULER_RUNNING_CHAINS JOB_SUBNAME

STEP_JOB_LOG_ID

USER_SCHEDULER_RUNNING_JOBS SLAVE_OS_PROCESS_ID
USER_SCHEDULER_SCHEDULES SCHEDULE_TYPE
USER_SQLTUNE_STATISTICS DIRECT_WRITES
USER_TS_QUOTAS DROPPED

See Also:

Part II, "Static Data Dictionary Views" for more information about the new columns in these static data dictionary views

The following dynamic performance views have new columns in release 10.2:

Dynamic Performance View New Columns
V$ACTIVE_SESSION_HISTORY P1TEXT

P2TEXT

P3TEXT

BLOCKING_SESSION_SERIAL#

FORCE_MATCHING_SIGNATURE

V$ARCHIVE_DEST MAX_CONNECTIONS
V$ARCHIVE_DEST_STATUS PROTECTION_REASON
  SYNCHRONIZED
V$ARCHIVED_LOG END_OF_REDO_TYPE
V$ASM_DISK PRODUCT
V$ASM_DISKGROUP COMPATIBILITY
  DATABASE_COMPATIBILITY
V$ASM_DISK_STAT PRODUCT
V$BACKUP_DATAFILE USED_OPTIMIZATION
V$BUFFERED_PUBLISHERS MEMORY_USAGE

OVERSPILLED_MSGS

PUBLISHER_STATE

UNBROWSED_MSGS

V$DATAFILE FIRST_NONLOGGED_SCN

FIRST_NONLOGGED_TIME

V$DATAFILE_HEADER LAST_DEALLOC_SCN

SPACE_HEADER

V$DB_OBJECT_CACHE INVALIDATIONS
V$LATCHHOLDER GETS
V$LICENSE CPU_COUNT_CURRENT

CPU_CORE_COUNT_CURRENT

CPU_SOCKET_COUNT_CURRENT

CPU_COUNT_HIGHWATER

CPU_CORE_COUNT_HIGHWATER

CPU_SOCKET_COUNT_HIGHWATER

V$PROPAGATION_RECEIVER DST_QUEUE_NAME

TOTAL_MSGS

DST_QUEUE_SCHEMA

SRC_QUEUE_SCHEMA

V$PROPAGATION_SENDER DST_QUEUE_NAME

DST_QUEUE_SCHEMA

STARTUP_TIME

V$RECOVERY_PROGRESS START_TIME

TIMESTAMP

UNITS

V$RMAN_OUTPUT SESSION_KEY
V$SERVICEMETRIC CALLSPERSEC

DBTIMEPERCALL

DBTIMEPERSEC

V$SERVICEMETRIC_HISTORY CALLSPERSEC

DBTIMEPERCALL

DBTIMEPERSEC

V$SESSION BLOCKING_INSTANCE
V$SESSION_LONGOPS TIMESTAMP
V$SQL BIND_DATA

FORCE_MATCHING_SIGNATURE

PX_SERVERS_EXECUTIONS

SERVICE

SERVICE_HASH

V$SQL_SHARED_CURSOR MV_STALEOBJ_MISMATCH

OPTIMIZER_MODE_MISMATCH

PX_MISMATCH

FLASHBACK_TABLE_MISMATCH

BIND_PEEKED_PQ_MISMATCH

CURSOR_PARTS_MISMATCH

PQ_SLAVE_MISMATCH

LITREP_COMP_MISMATCH

MULTI_PX_MISMATCH

MV_REWRITE_MISMATCH

ROLL_INVALID_MISMATCH

ROW_SHIP_MISMATCH

STD_OBJECT_MISMATCH

TOP_LEVEL_DDL_MISMATCH

V$SQLAREA BIND_DATA

FORCE_MATCHING_SIGNATURE

PX_SERVERS_EXECUTIONS

V$STREAMS_APPLY_COORDINATOR ELAPSED_IDLE_TIME
V$STREAMS_APPLY_READER ELAPSED_SPILL_TIME

TOTAL_MESSAGES_SPILLED

V$STREAMS_CAPTURE STATE_CHANGED_TIME
V$TABLESPACE ENCRYPT_IN_BACKUP
V$THREAD LAST_REDO_CHANGE#

LAST_REDO_TIME

LAST_REDO_BLOCK

LAST_REDO_SEQUENCE#

V$THRESHOLD_TYPES METRIC_VALUE_TYPE

See Also:

Part III, "Dynamic Performance Views" for more information about the new columns in these dynamic performance views

Oracle Database 10g Release 1 (10.1) New Features

The following initialization parameters are new to release 10.1:


ASM_DISKGROUPS
ASM_DISKSTRING
ASM_POWER_LIMIT
CREATE_STORED_OUTLINES
DB_FLASHBACK_RETENTION_TARGET
DB_RECOVERY_FILE_DEST
DB_RECOVERY_FILE_DEST_SIZE
DB_UNIQUE_NAME
DDL_WAIT_FOR_LOCKS
FILEIO_NETWORK_ADAPTERS
GCS_SERVER_PROCESSES
INSTANCE_TYPE
LDAP_DIRECTORY_ACCESS
LOG_ARCHIVE_CONFIG
LOG_ARCHIVE_LOCAL_FIRST
PLSQL_CODE_TYPE
PLSQL_DEBUG
PLSQL_OPTIMIZE_LEVEL
PLSQL_WARNINGS
RESUMABLE_TIMEOUT
SGA_TARGET
SKIP_UNUSABLE_INDEXES
SMTP_OUT_SERVER
SQLTUNE_CATEGORY
STREAMS_POOL_SIZE

See Also:

Part I, "Initialization Parameters" for more information about these initialization parameters

The following static data dictionary views are new to release 10.1:

ALL_ Views DBA_ Views USER_ Views
  DBA_ADVISOR_ACTIONS USER_ADVISOR_ACTIONS
  DBA_ADVISOR_COMMANDS  
  DBA_ADVISOR_DEFINITIONS  
  DBA_ADVISOR_FINDINGS USER_ADVISOR_FINDINGS
  DBA_ADVISOR_JOURNAL USER_ADVISOR_JOURNAL
  DBA_ADVISOR_LOG USER_ADVISOR_LOG
  DBA_ADVISOR_OBJECT_TYPES  
  DBA_ADVISOR_OBJECTS USER_ADVISOR_OBJECTS
  DBA_ADVISOR_PARAMETERS USER_ADVISOR_PARAMETERS
  DBA_ADVISOR_RATIONALE USER_ADVISOR_RATIONALE
  DBA_ADVISOR_RECOMMENDATIONS USER_ADVISOR_RECOMMENDATIONS
  DBA_ADVISOR_SQLA_REC_SUM USER_ADVISOR_SQLA_REC_SUM
  DBA_ADVISOR_SQLA_WK_MAP USER_ADVISOR_SQLA_WK_MAP
  DBA_ADVISOR_SQLA_WK_STMTS USER_ADVISOR_SQLA_WK_STMTS
  DBA_ADVISOR_SQLW_JOURNAL USER_ADVISOR_SQLW_JOURNAL
  DBA_ADVISOR_SQLW_PARAMETERS USER_ADVISOR_SQLW_PARAMETERS
  DBA_ADVISOR_SQLW_STMTS USER_ADVISOR_SQLW_STMTS
  DBA_ADVISOR_SQLW_SUM USER_ADVISOR_SQLW_SUM
  DBA_ADVISOR_SQLW_TABLES USER_ADVISOR_SQLW_TABLES
  DBA_ADVISOR_SQLW_TEMPLATES USER_ADVISOR_SQLW_TEMPLATES
  DBA_ADVISOR_TASKS USER_ADVISOR_TASKS
  DBA_ADVISOR_TEMPLATES USER_ADVISOR_TEMPLATES
  DBA_ADVISOR_USAGE  
  DBA_ALERT_HISTORY  
ALL_APPLY_ENQUEUE DBA_APPLY_ENQUEUE  
ALL_APPLY_EXECUTE DBA_APPLY_EXECUTE  
  DBA_APPLY_INSTANTIATED_GLOBAL  
  DBA_APPLY_INSTANTIATED_SCHEMAS  
ALL_APPLY_TABLE_COLUMNS DBA_APPLY_TABLE_COLUMNS  
ALL_AUDIT_POLICY_COLUMNS DBA_AUDIT_POLICY_COLUMNS USER_AUDIT_POLICY_COLUMNS
ALL_AW_PS    
ALL_AWS    
ALL_CAPTURE_EXTRA_ATTRIBUTES DBA_CAPTURE_EXTRA_ATTRIBUTES  
  DBA_COMMON_AUDIT_TRAIL  
  DBA_DATAPUMP_JOBS USER_DATAPUMP_JOBS
  DBA_DATAPUMP_SESSIONS  
  DBA_ENABLED_AGGREGATIONS  
  DBA_ENABLED_TRACES  
  DBA_FEATURE_USAGE_STATISTICS  
  DBA_HIGH_WATER_MARK_STATISTICS  
  DBA_HIST_ACTIVE_SESS_HISTORY  
  DBA_HIST_BASELINE  
  DBA_HIST_BG_EVENT_SUMMARY  
  DBA_HIST_BUFFER_POOL_STAT  
  DBA_HIST_CR_BLOCK_SERVER  
  DBA_HIST_CURRENT_BLOCK_SERVER  
  DBA_HIST_DATABASE_INSTANCE  
  DBA_HIST_DATAFILE  
  DBA_HIST_DB_CACHE_ADVICE  
  DBA_HIST_DLM_MISC  
  DBA_HIST_ENQUEUE_STAT  
  DBA_HIST_EVENT_NAME  
  DBA_HIST_FILEMETRIC_HISTORY  
  DBA_HIST_FILESTATXS  
  DBA_HIST_INST_CACHE_TRANSFER  
  DBA_HIST_INSTANCE_RECOVERY  
  DBA_HIST_JAVA_POOL_ADVICE  
  DBA_HIST_LATCH  
  DBA_HIST_LATCH_CHILDREN  
  DBA_HIST_LATCH_MISSES_SUMMARY  
  DBA_HIST_LATCH_NAME  
  DBA_HIST_LATCH_PARENT  
  DBA_HIST_LIBRARYCACHE  
  DBA_HIST_LOG  
  DBA_HIST_METRIC_NAME  
  DBA_HIST_MTTR_TARGET_ADVICE  
  DBA_HIST_OPTIMIZER_ENV  
  DBA_HIST_OSSTAT  
  DBA_HIST_OSSTAT_NAME  
  DBA_HIST_PARAMETER  
  DBA_HIST_PARAMETER_NAME  
  DBA_HIST_PGA_TARGET_ADVICE  
  DBA_HIST_PGASTAT  
  DBA_HIST_RESOURCE_LIMIT  
  DBA_HIST_ROWCACHE_SUMMARY  
  DBA_HIST_SEG_STAT  
  DBA_HIST_SEG_STAT_OBJ  
  DBA_HIST_SERVICE_NAME  
  DBA_HIST_SERVICE_STAT  
  DBA_HIST_SERVICE_WAIT_CLASS  
  DBA_HIST_SESSMETRIC_HISTORY  
  DBA_HIST_SGA  
  DBA_HIST_SGASTAT  
  DBA_HIST_SHARED_POOL_ADVICE  
  DBA_HIST_SNAP_ERROR  
  DBA_HIST_SNAPSHOT  
  DBA_HIST_SQL_PLAN  
  DBA_HIST_SQL_SUMMARY  
  DBA_HIST_SQL_WORKAREA_HSTGRM  
  DBA_HIST_SQLBIND  
  DBA_HIST_SQLSTAT  
  DBA_HIST_SQLTEXT  
  DBA_HIST_STAT_NAME  
  DBA_HIST_SYS_TIME_MODEL  
  DBA_HIST_SYSMETRIC_HISTORY  
  DBA_HIST_SYSMETRIC_SUMMARY  
  DBA_HIST_SYSSTAT  
  DBA_HIST_SYSTEM_EVENT  
  DBA_HIST_TABLESPACE_STAT  
  DBA_HIST_TBSPC_SPACE_USAGE  
  DBA_HIST_TEMPFILE  
  DBA_HIST_TEMPSTATXS  
  DBA_HIST_THREAD  
  DBA_HIST_UNDOSTAT  
  DBA_HIST_WAITCLASSMET_HISTORY  
  DBA_HIST_WAITSTAT  
  DBA_HIST_WR_CONTROL  
ALL_IND_STATISTICS DBA_IND_STATISTICS USER_IND_STATISTICS
ALL_INDEXTYPE_ARRAYTYPES DBA_INDEXTYPE_ARRAYTYPES USER_INDEXTYPE_ARRAYTYPES
  DBA_LOGMNR_LOG  
  DBA_LOGMNR_PURGED_LOG  
  DBA_LOGMNR_SESSION  
ALL_MVIEW_COMMENTS DBA_MVIEW_COMMENTS USER_MVIEW_COMMENTS
ALL_NESTED_TABLE_COLS DBA_NESTED_TABLE_COLS USER_NESTED_TABLE_COLS
  DBA_OUTSTANDING_ALERTS  
ALL_PLSQL_OBJECT_SETTINGS DBA_PLSQL_OBJECT_SETTINGS USER_PLSQL_OBJECT_SETTINGS
  DBA_RECYCLEBIN USER_RECYCLEBIN
  DBA_REDEFINITION_ERRORS  
  DBA_REDEFINITION_OBJECTS  
  DBA_REGISTERED_ARCHIVED_LOG  
ALL_REWRITE_EQUIVALENCES DBA_REWRITE_EQUIVALENCES USER_REWRITE_EQUIVALENCES
  DBA_RSRC_GROUP_MAPPINGS  
  DBA_RSRC_MAPPING_PRIORITY  
ALL_SCHEDULER_JOB_ARGS DBA_SCHEDULER_JOB_ARGS USER_SCHEDULER_JOB_ARGS
ALL_SCHEDULER_JOB_CLASSES DBA_SCHEDULER_JOB_CLASSES  
ALL_SCHEDULER_JOB_LOG DBA_SCHEDULER_JOB_LOG USER_SCHEDULER_JOB_LOG
ALL_SCHEDULER_JOB_RUN_DETAILS DBA_SCHEDULER_JOB_RUN_DETAILS USER_SCHEDULER_JOB_RUN_DETAILS
ALL_SCHEDULER_JOBS DBA_SCHEDULER_JOBS USER_SCHEDULER_JOBS
ALL_SCHEDULER_PROGRAM_ARGS DBA_SCHEDULER_PROGRAM_ARGS USER_SCHEDULER_PROGRAM_ARGS
ALL_SCHEDULER_PROGRAMS DBA_SCHEDULER_PROGRAMS USER_SCHEDULER_PROGRAMS
ALL_SCHEDULER_RUNNING_JOBS DBA_SCHEDULER_RUNNING_JOBS USER_SCHEDULER_RUNNING_JOBS
ALL_SCHEDULER_SCHEDULES DBA_SCHEDULER_SCHEDULES USER_SCHEDULER_SCHEDULES
ALL_SCHEDULER_WINDOW_DETAILS DBA_SCHEDULER_WINDOW_DETAILS  
ALL_SCHEDULER_WINDOW_GROUPS DBA_SCHEDULER_WINDOW_GROUPS  
ALL_SCHEDULER_WINDOW_LOG DBA_SCHEDULER_WINDOW_LOG  
ALL_SCHEDULER_WINDOWS DBA_SCHEDULER_WINDOWS  
ALL_SCHEDULER_WINGROUP_MEMBERS DBA_SCHEDULER_WINGROUP_MEMBERS  
ALL_SEC_RELEVANT_COLS DBA_SEC_RELEVANT_COLS USER_SEC_RELEVANT_COLS
  DBA_SERVER_REGISTRY  
ALL_SERVICES DBA_SERVICES  
  DBA_SQL_PROFILES  
  DBA_SQLSET USER_SQLSET
  DBA_SQLSET_BINDS USER_SQLSET_BINDS
  DBA_SQLSET_REFERENCES USER_SQLSET_REFERENCES
  DBA_SQLSET_STATEMENTS USER_SQLSET_STATEMENTS
  DBA_SQLTUNE_BINDS USER_SQLTUNE_BINDS
  DBA_SQLTUNE_PLANS USER_SQLTUNE_PLANS
  DBA_SQLTUNE_RATIONALE_PLAN USER_SQLTUNE_RATIONALE_PLAN
  DBA_SQLTUNE_STATISTICS USER_SQLTUNE_STATISTICS
  DBA_STREAMS_ADMINISTRATOR  
ALL_STREAMS_MESSAGE_CONSUMERS DBA_STREAMS_MESSAGE_CONSUMERS  
ALL_STREAMS_MESSAGE_RULES DBA_STREAMS_MESSAGE_RULES  
ALL_STREAMS_NEWLY_SUPPORTED DBA_STREAMS_NEWLY_SUPPORTED  
ALL_STREAMS_RULES DBA_STREAMS_RULES  
ALL_STREAMS_TRANSFORM_FUNCTION DBA_STREAMS_TRANSFORM_FUNCTION  
ALL_STREAMS_UNSUPPORTED DBA_STREAMS_UNSUPPORTED  
ALL_TAB_STATISTICS DBA_TAB_STATISTICS USER_TAB_STATISTICS
  DBA_TABLESPACE_GROUPS  
  DBA_THRESHOLDS  
  DBA_TUNE_MVIEW USER_TUNE_MVIEW
ALL_WARNING_SETTINGS DBA_WARNING_SETTINGS USER_WARNING_SETTINGS

See Also:

Part II, "Static Data Dictionary Views" for more information about these static data dictionary views

The following dynamic performance views are new to release 10.1:

GV$ Views V$ Views
GV$ACTIVE_SERVICES V$ACTIVE_SERVICES
GV$ACTIVE_SESSION_HISTORY V$ACTIVE_SESSION_HISTORY
GV$ALERT_TYPES V$ALERT_TYPES
GV$ASM_ALIAS V$ASM_ALIAS
GV$ASM_CLIENT V$ASM_CLIENT
GV$ASM_DISK V$ASM_DISK
GV$ASM_DISKGROUP V$ASM_DISKGROUP
GV$ASM_FILE V$ASM_FILE
GV$ASM_OPERATION V$ASM_OPERATION
GV$ASM_TEMPLATE V$ASM_TEMPLATE
  V$BACKUP_FILES
  V$BLOCK_CHANGE_TRACKING
GV$BUFFERED_PUBLISHERS V$BUFFERED_PUBLISHERS
GV$BUFFERED_QUEUES V$BUFFERED_QUEUES
GV$BUFFERED_SUBSCRIBERS V$BUFFERED_SUBSCRIBERS
GV$CLIENT_STATS V$CLIENT_STATS
GV$CURRENT_BLOCK_SERVER V$CURRENT_BLOCK_SERVER
GV$DATAGUARD_CONFIG V$DATAGUARD_CONFIG
GV$DISPATCHER_CONFIG V$DISPATCHER_CONFIG
GV$EVENT_HISTOGRAM V$EVENT_HISTOGRAM
GV$EVENTMETRIC V$EVENTMETRIC
GV$FILE_HISTOGRAM V$FILE_HISTOGRAM
GV$FILEMETRIC V$FILEMETRIC
GV$FILEMETRIC_HISTORY V$FILEMETRIC_HISTORY
GV$FLASHBACK_DATABASE_LOG V$FLASHBACK_DATABASE_LOG
GV$FLASHBACK_DATABASE_STAT V$FLASHBACK_DATABASE_STAT
GV$JAVA_LIBRARY_CACHE_MEMORY V$JAVA_LIBRARY_CACHE_MEMORY
GV$JAVA_POOL_ADVICE V$JAVA_POOL_ADVICE
GV$METRICNAME V$METRICNAME
GV$OSSTAT V$OSSTAT
GV$PROPAGATION_RECEIVER V$PROPAGATION_RECEIVER
GV$PROPAGATION_SENDER V$PROPAGATION_SENDER
  V$RECOVERY_FILE_DEST
GV$RMAN_OUTPUT V$RMAN_OUTPUT
  V$RMAN_STATUS
GV$RULE V$RULE
GV$RULE_SET V$RULE_SET
GV$RULE_SET_AGGREGATE_STATS V$RULE_SET_AGGREGATE_STATS
GV$SERV_MOD_ACT_STATS V$SERV_MOD_ACT_STATS
GV$SERVICE_EVENT V$SERVICE_EVENT
GV$SERVICE_STATS V$SERVICE_STATS
GV$SERVICE_WAIT_CLASS V$SERVICE_WAIT_CLASS
GV$SERVICEMETRIC V$SERVICEMETRIC
GV$SERVICEMETRIC_HISTORY V$SERVICEMETRIC_HISTORY
GV$SERVICES V$SERVICES
GV$SES_OPTIMIZER_ENV V$SES_OPTIMIZER_ENV
GV$SESS_TIME_MODEL V$SESS_TIME_MODEL
GV$SESSION_WAIT_CLASS V$SESSION_WAIT_CLASS
GV$SESSION_WAIT_HISTORY V$SESSION_WAIT_HISTORY
GV$SESSMETRIC V$SESSMETRIC
GV$SGAINFO V$SGAINFO
GV$SQL_BIND_CAPTURE V$SQL_BIND_CAPTURE
GV$SQL_OPTIMIZER_ENV V$SQL_OPTIMIZER_ENV
GV$SYS_OPTIMIZER_ENV V$SYS_OPTIMIZER_ENV
GV$SYS_TIME_MODEL V$SYS_TIME_MODEL
GV$SYSAUX_OCCUPANTS V$SYSAUX_OCCUPANTS
GV$SYSMETRIC V$SYSMETRIC
GV$SYSMETRIC_HISTORY V$SYSMETRIC_HISTORY
GV$SYSMETRIC_SUMMARY V$SYSMETRIC_SUMMARY
GV$SYSTEM_WAIT_CLASS V$SYSTEM_WAIT_CLASS
GV$TEMP_HISTOGRAM V$TEMP_HISTOGRAM
GV$THRESHOLD_TYPES V$THRESHOLD_TYPES
  V$TRANSPORTABLE_PLATFORM
GV$WAITCLASSMETRIC V$WAITCLASSMETRIC
GV$WAITCLASSMETRIC_HISTORY V$WAITCLASSMETRIC_HISTORY

See Also:

Part III, "Dynamic Performance Views" for more information about these dynamic performance views

The following static data dictionary views have new columns in release 10.1:

Static Data Dictionary View New Columns
ALL_ALL_TABLES DROPPED
ALL_APPLY PRECOMMIT_HANDLER

MAX_APPLIED_MESSAGE_NUMBER

NEGATIVE_RULE_SET_NAME

NEGATIVE_RULE_SET_OWNER

STATUS_CHANGE_TIME

ERROR_NUMBER

ERROR_MESSAGE

ALL_APPLY_DML_HANDLERS APPLY_NAME
ALL_APPLY_PROGRESS SOURCE_DATABASE
ALL_AUDIT_POLICIES SEL

INS

UPD

DEL

AUDIT_TRAIL

POLICY_COLUMN_OPTIONS

ALL_CAPTURE CAPTURE_USER

CAPTURED_SCN

APPLIED_SCN

USE_DATABASE_LINK

FIRST_SCN

SOURCE_DATABASE

SOURCE_DBID

SOURCE_RESETLOGS_SCN

SOURCE_RESETLOGS_TIME

LOGMINER_ID

NEGATIVE_RULE_SET_NAME

NEGATIVE_RULE_SET_OWNER

MAX_CHECKPOINT_SCN

REQUIRED_CHECKPOINT_SCN

LOGFILE_ASSIGNMENT

STATUS_CHANGE_TIME

ERROR_NUMBER

ERROR_MESSAGE

VERSION

CAPTURE_TYPE

ALL_DEF_AUDIT_OPTS FBK
ALL_DIM_ATTRIBUTES ATTRIBUTE_NAME
ALL_ERRORS ATTRIBUTE

MESSAGE_NUMBER

ALL_EXTERNAL_TABLES PROPERTY
ALL_INDEXES IOT_REDUNDANT_PKEY_ELIM

DROPPED

ALL_INDEXTYPES ARRAY_DML
ALL_LOBS TABLESPACE_NAME

FORMAT

PARTITIONED

ALL_LOG_GROUP_COLUMNS LOGGING_PROPERTY
ALL_LOG_GROUPS LOG_GROUP_TYPE

GENERATED

ALL_MVIEWS UNKNOWN_TRUSTED_FD

STALE_SINCE

ALL_OBJECT_TABLES DROPPED
ALL_OUTLINES COMPATIBLE

ENABLED

FORMAT

ALL_PART_COL_STATISTICS HISTOGRAM
ALL_POLICIES IDX

POLICY_TYPE

LONG_PREDICATE

ALL_PROPAGATION NEGATIVE_RULE_SET_OWNER

NEGATIVE_RULE_SET_NAME

ALL_SUBPART_COL_STATISTICS HISTOGRAM
ALL_SUBSCRIBED_COLUMNS SUBSCRIPTION_NAME
ALL_SUBSCRIBED_TABLES SUBSCRIPTION_NAME
ALL_SUBSCRIPTIONS SUBSCRIPTION_NAME
ALL_TAB_COL_STATISTICS HISTOGRAM
ALL_TAB_COLS HISTOGRAM

QUALIFIED_COL_NAME

ALL_TAB_COLUMNS HISTOGRAM
ALL_TAB_MODIFICATIONS DROP_SEGMENTS
ALL_TABLES DROPPED
DBA_ALL_TABLES DROPPED
DBA_APPLY PRECOMMIT_HANDLER

MAX_APPLIED_MESSAGE_NUMBER

NEGATIVE_RULE_SET_NAME

NEGATIVE_RULE_SET_OWNER

STATUS_CHANGE_TIME

ERROR_NUMBER

ERROR_MESSAGE

DBA_APPLY_DML_HANDLERS APPLY_NAME
DBA_APPLY_PROGRESS SOURCE_DATABASE
DBA_AUDIT_EXISTS EXTENDED_TIMESTAMP

PROXY_SESSIONID

GLOBAL_UID

INSTANCE_NUMBER

OS_PROCESS

TRANSACTIONID

SCN

SQL_BIND

SQL_TEXT

DBA_AUDIT_OBJECT EXTENDED_TIMESTAMP

PROXY_SESSIONID

GLOBAL_UID

INSTANCE_NUMBER

OS_PROCESS

TRANSACTIONID

SCN

SQL_BIND

SQL_TEXT

DBA_AUDIT_POLICIES SEL

INS

UPD

DEL

AUDIT_TRAIL

POLICY_COLUMN_OPTIONS

DBA_AUDIT_SESSION EXTENDED_TIMESTAMP

PROXY_SESSIONID

GLOBAL_UID

INSTANCE_NUMBER

OS_PROCESS

DBA_AUDIT_STATEMENT EXTENDED_TIMESTAMP

PROXY_SESSIONID

GLOBAL_UID

INSTANCE_NUMBER

OS_PROCESS

TRANSACTIONID

SCN

SQL_BIND

SQL_TEXT

DBA_AUDIT_TRAIL EXTENDED_TIMESTAMP

PROXY_SESSIONID

GLOBAL_UID

INSTANCE_NUMBER

OS_PROCESS

TRANSACTIONID

SCN

SQL_BIND

SQL_TEXT

DBA_AW_PS MAXPAGES
DBA_CAPTURE CAPTURE_USER

USE_DATABASE_LINK

FIRST_SCN

SOURCE_DATABASE

SOURCE_DBID

SOURCE_RESETLOGS_SCN

SOURCE_RESETLOGS_TIME

LOGMINER_ID

NEGATIVE_RULE_SET_NAME

NEGATIVE_RULE_SET_OWNER

MAX_CHECKPOINT_SCN

REQUIRED_CHECKPOINT_SCN

LOGFILE_ASSIGNMENT

STATUS_CHANGE_TIME

ERROR_NUMBER

ERROR_MESSAGE

VERSION

CAPTURE_TYPE

DBA_DIM_ATTRIBUTES ATTRIBUTE_NAME
DBA_ERRORS ATTRIBUTE

MESSAGE_NUMBER

DBA_EXTERNAL_TABLES PROPERTY
DBA_FGA_AUDIT_TRAIL STATEMENT_TYPE

EXTENDED_TIMESTAMP

PROXY_SESSIONID

GLOBAL_UID

INSTANCE_NUMBER

OS_PROCESS

TRANSACTIONID

STATEMENTID

ENTRYID

DBA_INDEXES IOT_REDUNDANT_PKEY_ELIM

DROPPED

DBA_INDEXTYPES ARRAY_DML
DBA_LOBS TABLESPACE_NAME

FORMAT

PARTITIONED

DBA_LOG_GROUP_COLUMNS LOGGING_PROPERTY
DBA_LOG_GROUPS LOG_GROUP_TYPE

GENERATED

DBA_LOGSTDBY_LOG APPLIED
DBA_LOGSTDBY_PROGRESS APPLIED_THREAD#

APPLIED_SEQUENCE#

READ_THREAD#

READ_SEQUENCE#

NEWEST_THREAD#

NEWEST_SEQUENCE#

DBA_LOGSTDBY_SKIP USE_LIKE

ESC

DBA_LOGSTDBY_UNSUPPORTED ATTRIBUTES
DBA_MVIEWS UNKNOWN_TRUSTED_FD

STALE_SINCE

DBA_OBJ_AUDIT_OPTS FBK
DBA_OBJECT_TABLES DROPPED
DBA_OUTLINES COMPATIBLE

ENABLED

FORMAT

DBA_PART_COL_STATISTICS HISTOGRAM
DBA_POLICIES IDX

POLICY_TYPE

LONG_PREDICATE

DBA_PROPAGATION NEGATIVE_RULE_SET_OWNER

NEGATIVE_RULE_SET_NAME

DBA_PROXIES AUTHENTICATION
DBA_REGISTRY NAMESPACE
DBA_REGISTRY_HIERARCHY NAMESPACE
DBA_RSRC_PLAN_DIRECTIVES MAX_IDLE_TIME

MAX_IDLE_BLOCKER_TIME

SWITCH_TIME_IN_CALL

DBA_SUBPART_COL_STATISTICS HISTOGRAM
DBA_SUBSCRIBED_COLUMNS SUBSCRIPTION_NAME
DBA_SUBSCRIBED_TABLES SUBSCRIPTION_NAME
DBA_SUBSCRIPTIONS SUBSCRIPTION_NAME
DBA_TAB_COL_STATISTICS HISTOGRAM
DBA_TAB_COLS HISTOGRAM

QUALIFIED_COL_NAME

DBA_TAB_COLUMNS HISTOGRAM
DBA_TAB_MODIFICATIONS DROP_SEGMENTS
DBA_TABLES DROPPED
DBA_TABLESPACES RETENTION

BIGFILE

USER_ALL_TABLES DROPPED
USER_AUDIT_OBJECT EXTENDED_TIMESTAMP

PROXY_SESSIONID

GLOBAL_UID

INSTANCE_NUMBER

OS_PROCESS

TRANSACTIONID

SCN

SQL_BIND

SQL_TEXT

USER_AUDIT_POLICIES SEL

INS

UPD

DEL

AUDIT_TRAIL

POLICY_COLUMN_OPTIONS

USER_AUDIT_SESSION EXTENDED_TIMESTAMP

PROXY_SESSIONID

GLOBAL_UID

INSTANCE_NUMBER

OS_PROCESS

USER_AUDIT_STATEMENT EXTENDED_TIMESTAMP

PROXY_SESSIONID

GLOBAL_UID

INSTANCE_NUMBER

OS_PROCESS

TRANSACTIONID

SCN

SQL_BIND

SQL_TEXT

USER_AUDIT_TRAIL EXTENDED_TIMESTAMP

PROXY_SESSIONID

GLOBAL_UID

INSTANCE_NUMBER

OS_PROCESS

TRANSACTIONID

SCN

SQL_BIND

SQL_TEXT

USER_AW_PS MAXPAGES
USER_DIM_ATTRIBUTES ATTRIBUTE_NAME
USER_ERRORS ATTRIBUTE

MESSAGE_NUMBER

USER_EXTERNAL_TABLES PROPERTY
USER_INDEXES IOT_REDUNDANT_PKEY_ELIM

DROPPED

USER_INDEXTYPES ARRAY_DML
USER_LOBS TABLESPACE_NAME

FORMAT

PARTITIONED

USER_LOG_GROUP_COLUMNS LOGGING_PROPERTY
USER_LOG_GROUPS LOG_GROUP_TYPE

GENERATED

USER_MVIEWS UNKNOWN_TRUSTED_FD

STALE_SINCE

USER_OBJ_AUDIT_OPTS FBK
USER_OBJECT_TABLES DROPPED
USER_OUTLINES COMPATIBLE

ENABLED

FORMAT

USER_PART_COL_STATISTICS HISTOGRAM
USER_POLICIES IDX

POLICY_TYPE

LONG_PREDICATE

USER_PROXIES AUTHENTICATION
USER_PUBLISHED_COLUMNS CHANGE_SET_NAME

PUB_ID

USER_REGISTRY NAMESPACE
USER_SUBPART_COL_STATISTICS HISTOGRAM
USER_SUBSCRIBED_COLUMNS SUBSCRIPTION_NAME
USER_SUBSCRIBED_TABLES SUBSCRIPTION_NAME
USER_SUBSCRIPTIONS SUBSCRIPTION_NAME
USER_TAB_COL_STATISTICS HISTOGRAM
USER_TAB_COLS HISTOGRAM

QUALIFIED_COL_NAME

USER_TAB_COLUMNS HISTOGRAM
USER_TAB_MODIFICATIONS DROP_SEGMENTS
USER_TABLES DROPPED
USER_TABLESPACES RETENTION

BIGFILE


See Also:

Part II, "Static Data Dictionary Views" for more information about the new columns in these static data dictionary views

The following dynamic performance views have new columns in release 10.1:

Dynamic Performance View New Columns
GV$ARCHIVE_DEST and V$ARCHIVE_DEST VALID_NOW

VALID_TYPE

VALID_ROLE

DB_UNIQUE_NAME

VERIFY

EXPEDITE

GV$ARCHIVE_DEST_STATUS and V$ARCHIVE_DEST_STATUS DB_UNIQUE_NAME
GV$ARCHIVED_LOG and V$ARCHIVED_LOG RESETLOGS_ID

IS_RECOVERY_DEST_FILE

FAL

GV$AW_CALC and V$AW_CALC SESSION_ID

CURR_DML_COMMAND

PREV_DML_COMMAND

AGGR_FUNC_LOGICAL_NA

AGGR_FUNC_PRECOMPUTE

AGGR_FUNC_CALCS

GV$AW_SESSION_INFO and V$AW_SESSION_INFO SESSION_ID
GV$BACKUP_ASYNC_IO and V$BACKUP_ASYNC_IO RMAN_STATUS_RECID

RMAN_STATUS_STAMP

GV$BACKUP_DATAFILE and V$BACKUP_DATAFILE USED_CHANGE_TRACKING

BLOCKS_READ

GV$BACKUP_PIECE and V$BACKUP_PIECE BYTES

IS_RECOVERY_DEST_FILE

RMAN_STATUS_RECID

RMAN_STATUS_STAMP

COMPRESSED

GV$BACKUP_SYNC_IO and V$BACKUP_SYNC_IO RMAN_STATUS_RECID

RMAN_STATUS_STAMP

GV$BGPROCESS and V$BGPROCESS PSERIAL#
GV$CLASS_CACHE_TRANSFER and V$CLASS_CACHE_TRANSFER CR_TRANSFER

CURRENT_TRANSFER

GV$CONTROLFILE and V$CONTROLFILE IS_RECOVERY_DEST_FILE
GV$DATABASE and V$DATABASE SWITCHOVER#

PLATFORM_ID

PLATFORM_NAME

RECOVERY_TARGET_INCARNATION#

LAST_OPEN_INCARNATION#

CURRENT_SCN

FLASHBACK_ON

SUPPLEMENTAL_LOG_DATA_FK

SUPPLEMENTAL_LOG_DATA_ALL

DB_UNIQUE_NAME

STANDBY_BECAME_PRIMARY_SCN

GV$DATABASE_INCARNATION and V$DATABASE_INCARNATION INCARNATION#

STATUS

RESETLOGS_ID

PRIOR_INCARNATION#

GV$DATAFILE_COPY and V$DATAFILE_COPY IS_RECOVERY_DEST_FILE

RMAN_STATUS_RECID

RMAN_STATUS_STAMP

GV$DB_CACHE_ADVICE and V$DB_CACHE_ADVICE ESTD_PHYSICAL_READ_TIME

ESTD_PCT_OF_DB_TIME_FOR_READS

GV$EVENT_NAME and V$EVENT_NAME EVENT_ID

WAIT_CLASS_ID

WAIT_CLASS#

WAIT_CLASS

GV$FAST_START_SERVERS and V$FAST_START_SERVERS XID
GV$FAST_START_TRANSACTIONS and V$FAST_START_TRANSACTIONS XID

PXID

RCVSERVERS

GV$INSTANCE_RECOVERY and V$INSTANCE_RECOVERY OPTIMAL_LOGFILE_SIZE

ESTD_CLUSTER_AVAILABLE_TIME

WRITES_MTTR

WRITES_LOGFILE_SIZE

WRITES_LOG_CHECKPOINT_SETTINGS

WRITES_OTHER_SETTINGS

WRITES_AUTOTUNE

WRITES_FULL_THREAD_CKPT

GV$LATCH and V$LATCH HASH
GV$LATCH_CHILDREN and V$LATCH_CHILDREN HASH
GV$LATCH_PARENT and V$LATCH_PARENT HASH
GV$LATCHNAME and V$LATCHNAME HASH
GV$LOADISTAT and V$LOADISTAT MESSAGE_NUM
GV$LOG_HISTORY and V$LOG_HISTORY RESETLOGS_CHANGE#

RESETLOGS_TIME

GV$LOGFILE and V$LOGFILE IS_RECOVERY_DEST_FILE
GV$LOGMNR_CONTENTS and V$LOGMNR_CONTENTS TABLE_NAME

DATA_OBJV#

SAFE_RESUME_SCN

XID

PXID

AUDIT_SESSIONID

GV$LOGMNR_DICTIONARY and V$LOGMNR_DICTIONARY DB_CREATED

DB_VERSION_TIME

DB_CHARACTER_SET

DB_VERSION

DB_STATUS

DB_TXN_SCN

GV$LOGMNR_LOGS and V$LOGMNR_LOGS TYPE

BLOCKSIZE

FILESIZE

GV$LOGMNR_PARAMETERS and V$LOGMNR_PARAMETERS REQUIRED_START_DATE

REQUIRED_START_SCN

OPTIONS

GV$MANAGED_STANDBY and V$MANAGED_STANDBY RESETLOG_ID
GV$OFFLINE_RANGE and V$OFFLINE_RANGE RESETLOGS_CHANGE#

RESETLOGS_TIME

GV$OPEN_CURSOR and V$OPEN_CURSOR SQL_ID
GV$PARAMETER and V$PARAMETER DISPLAY_VALUE

ISINSTANCE_MODIFIABLE

ISDEPRECATED

HASH

GV$PARAMETER2 and V$PARAMETER2 DISPLAY_VALUE

ISINSTANCE_MODIFIABLE

ISDEPRECATED

GV$PROXY_ARCHIVEDLOG and V$PROXY_ARCHIVEDLOG TAG

RMAN_STATUS_RECID

RMAN_STATUS_STAMP

GV$PROXY_DATAFILE and V$PROXY_DATAFILE RMAN_STATUS_RECID

RMAN_STATUS_STAMP

GV$RSRC_PLAN and V$RSRC_PLAN IS_TOP_PLAN
GV$SESSION and V$SESSION SQL_ID

SQL_CHILD_NUMBER

PREV_SQL_ID

PREV_CHILD_NUMBER

BLOCKING_SESSION_STATUS

BLOCKING_SESSION

SEQ#

EVENT#

EVENT

P1TEXT

P1

P1RAW

P2TEXT

P2

P2RAW

P3TEXT

P3

P3RAW

WAIT_CLASS_ID

WAIT_CLASS#

WAIT_CLASS

WAIT_TIME

SECONDS_IN_WAIT

STATE

SERVICE_NAME

GV$SESSION_EVENT and V$SESSION_EVENT EVENT_ID
GV$SESSION_LONGOPS and V$SESSION_LONGOPS SQL_ID
GV$SESSION_WAIT and V$SESSION_WAIT WAIT_CLASS_ID

WAIT_CLASS#

WAIT_CLASS

GV$SGA_DYNAMIC_COMPONENTS and V$SGA_DYNAMIC_COMPONENTS USER_SPECIFIED_SIZE
GV$SHARED_POOL_ADVICE and V$SHARED_POOL_ADVICE ESTD_LC_LOAD_TIME

ESTD_LC_LOAD_TIME_FACTOR

GV$SPPARAMETER and V$SPPARAMETER DISPLAY_VALUE
GV$SQL and V$SQL SQL_FULLTEXT

SQL_ID

END_OF_FETCH_COUNT

DIRECT_WRITES

APPLICATION_WAIT_TIME

CONCURRENCY_WAIT_TIME

CLUSTER_WAIT_TIME

USER_IO_WAIT_TIME

PLSQL_EXEC_TIME

JAVA_EXEC_TIME

OPTIMIZER_ENV

OPTIMIZER_ENV_HASH_VALUE

OLD_HASH_VALUE

SQL_PROFILE

PROGRAM_ID

PROGRAM_LINE#

GV$SQL_PLAN and V$SQL_PLAN SQL_ID

PLAN_HASH_VALUE

OBJECT_ALIAS

OBJECT_TYPE

PROJECTION

TIME

QBLOCK_NAME

REMARKS

GV$SQL_PLAN_STATISTICS and V$SQL_PLAN_STATISTICS SQL_ID

PLAN_HASH_VALUE

GV$SQL_PLAN_STATISTICS_ALL and V$SQL_PLAN_STATISTICS_ALL SQL_ID

PLAN_HASH_VALUE

OBJECT_ALIAS

OBJECT_TYPE

PROJECTION

TIME

QBLOCK_NAME

REMARKS

GV$SQL_REDIRECTION and V$SQL_REDIRECTION SQL_ID
GV$SQL_SHARED_CURSOR and V$SQL_SHARED_CURSOR SQL_ID

CHILD_ADDRESS

CHILD_NUMBER

ANYDATA_TRANSFORMATION

INCOMPLETE_CURSOR

TOP_LEVEL_RPI_CURSOR

DIFFERENT_LONG_LENGTH

LOGICAL_STANDBY_APPLY

DIFF_CALL_DURN

BIND_UACS_DIFF

PLSQL_CMP_SWITCHS_DIFF

GV$SQL_SHARED_MEMORY and V$SQL_SHARED_MEMORY SQL_FULLTEXT

SQL_ID

GV$SQL_WORKAREA and V$SQL_WORKAREA SQL_ID
GV$SQL_WORKAREA_ACTIVE and V$SQL_WORKAREA_ACTIVE SQL_HASH_VALUE

SQL_ID

GV$SQLAREA and V$SQLAREA SQL_ID

END_OF_FETCH_COUNT

DIRECT_WRITES

APPLICATION_WAIT_TIME

CONCURRENCY_WAIT_TIME

CLUSTER_WAIT_TIME

USER_IO_WAIT_TIME

PLSQL_EXEC_TIME

JAVA_EXEC_TIME

OLD_HASH_VALUE

PROGRAM_ID

GV$SQLTEXT and V$SQLTEXT SQL_ID
GV$SQLTEXT_WITH_NEWLINES and V$SQLTEXT_WITH_NEWLINES SQL_ID
GV$STANDBY_LOG and V$STANDBY_LOG DBID
GV$STATNAME and V$STATNAME STAT_ID
GV$STREAMS_APPLY_COORDINATOR and V$STREAMS_APPLY_COORDINATOR TOTAL_IGNORED

TOTAL_ROLLBACKS

GV$STREAMS_APPLY_READER and V$STREAMS_APPLY_READER LAST_BROWSE_NUM

OLDEST_SCN_NUM

LAST_BROWSE_SEQ

LAST_DEQ_SEQ

GV$STREAMS_APPLY_SERVER and V$STREAMS_APPLY_SERVER TOTAL_ROLLBACKS
GV$STREAMS_CAPTURE and V$STREAMS_CAPTURE LOGMINER_ID

TOTAL_PREFILTER_DISCARDED

TOTAL_PREFILTER_KEPT

TOTAL_PREFILTER_EVALUATIONS

TOTAL_MESSAGES_CREATED

TOTAL_FULL_EVALUATIONS

AVAILABLE_MESSAGE_NUMBER

AVAILABLE_MESSAGE_CREATE_TIME

ELAPSED_REDO_WAIT_TIME

ELAPSED_PAUSE_TIME

GV$SYSSTAT and V$SYSSTAT STAT_ID
GV$SYSTEM_EVENT and V$SYSTEM_EVENT EVENT_ID
GV$SYSTEM_PARAMETER and V$SYSTEM_PARAMETER DISPLAY_VALUE

ISINSTANCE_MODIFIABLE

ISDEPRECATED

HASH

GV$SYSTEM_PARAMETER2 and V$SYSTEM_PARAMETER2 DISPLAY_VALUE

ISINSTANCE_MODIFIABLE

ISDEPRECATED

GV$TABLESPACE and V$TABLESPACE BIGFILE

FLASHBACK_ON

GV$TEMPORARY_LOBS and V$TEMPORARY_LOBS ABSTRACT_LOBS
GV$TEMPSEG_USAGE and V$TEMPSEG_USAGE SQL_ID
GV$TRANSACTION and V$TRANSACTION START_DATE

DSCN_BASE

DSCN_WRAP

START_SCN

DEPENDENT_SCN

XID

PRV_XID

PTX_XID

GV$UNDOSTAT and V$UNDOSTAT MAXQUERYID

ACTIVEBLKS

UNEXPIREDBLKS

EXPIREDBLKS

TUNED_UNDORETENTION

GV$VPD_POLICY and V$VPD_POLICY SQL_ID

See Also:

Part III, "Dynamic Performance Views" for more information about the new columns in these dynamic performance views