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
Oracle Database 10g Release 1 (10.1) New Features

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
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_WORKSPACE_SESSIONS`
`ALL_WORKSPACES`	`DBA_WORKSPACES`	`USER_WORKSPACES`

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`</