What's New in Oracle Database Reference?

This section describes new features of Oracle Database 10g release 1 (10.1) and provides pointers to additional information. 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 1 (10.1) New Features

Oracle Database 10g Release 1 (10.1) New Features

The following initialization parameters are new to this release:

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:

Chapter 1, " Initialization Parameters" for more information about these initialization parameters

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

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_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_ROLLSTAT`
	`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`

The following dynamic performance views are new to this release:

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:

Chapter 4, " Dynamic Performance (V$) Views" and Chapter 5, " Dynamic Performance (V$) Views: V$NLS_PARAMETERS to V$WAITSTAT" for more information about these dynamic performance views

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

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` `TPROP` `SEGSPARE1` `TFLAGS`
`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:

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

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:

Chapter 4, " Dynamic Performance (V$) Views" for more information about the new columns in these dynamic performance views