What's New in Oracle9i Database Reference?

This section describes new features of Oracle9i release 2 (9.2) and provides pointers to additional information. New features information from previous releases is also retained to help those users upgrading to the current release.

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

Oracle9i Release 2 (9.2) New Features in Oracle9i Database Reference

The following initialization parameters are new to this release:

`AUDIT_SYS_OPERATIONS`	`DG_BROKER_CONFIG_FILE``n`
`DG_BROKER_START`	`FILE_MAPPING`
`FILESYSTEMIO_OPTIONS`	`LOG_PARALLELISM`
`OLAP_PAGE_POOL_SIZE`	`OPTIMIZER_DYNAMIC_SAMPLING`
`STATISTICS_LEVEL`

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
`ALL_APPLY`	`DBA_APPLY`
`ALL_APPLY_CONFLICT_COLUMNS`	`DBA_APPLY_CONFLICT_COLUMNS`
`ALL_APPLY_DML_HANDLERS`	`DBA_APPLY_DML_HANDLERS`
`ALL_APPLY_ERROR`	`DBA_APPLY_ERROR`
	`DBA_APPLY_INSTANTIATED_OBJECTS`
`ALL_APPLY_KEY_COLUMNS`	`DBA_APPLY_KEY_COLUMNS`
`ALL_APPLY_PARAMETERS`	`DBA_APPLY_PARAMETERS`
`ALL_APPLY_PROGRESS`	`DBA_APPLY_PROGRESS`
	`DBA_AQ_AGENT_PRIVS`	`USER_AQ_AGENT_PRIVS`
	`DBA_AQ_AGENTS`
	`DBA_AW_PS`	`USER_AW_PS`
	`DBA_AWS`	`USER_AWS`
`ALL_CAPTURE`	`DBA_CAPTURE`
`ALL_CAPTURE_PARAMETERS`	`DBA_CAPTURE_PARAMETERS`
`ALL_CAPTURE_PREPARED_DATABASE`	`DBA_CAPTURE_PREPARED_DATABASE`
`ALL_CAPTURE_PREPARED_SCHEMAS`	`DBA_CAPTURE_PREPARED_SCHEMAS`
`ALL_CAPTURE_PREPARED_TABLES`	`DBA_CAPTURE_PREPARED_TABLES`
`ALL_CONS_OBJ_COLUMNS`	`DBA_CONS_OBJ_COLUMNS`	`USER_CONS_OBJ_COLUMNS`
`ALL_EVALUATION_CONTEXT_TABLES`	`DBA_EVALUATION_CONTEXT_TABLES`	`USER_EVALUATION_CONTEXT_TABLES`
`ALL_EVALUATION_CONTEXT_VARS`	`DBA_EVALUATION_CONTEXT_VARS`	`USER_EVALUATION_CONTEXT_VARS`
`ALL_EVALUATION_CONTEXTS`	`DBA_EVALUATION_CONTEXTS`	`USER_EVALUATION_CONTEXTS`
`ALL_JAVA_ARGUMENTS`	`DBA_JAVA_ARGUMENTS`	`USER_JAVA_ARGUMENTS`
`ALL_JAVA_CLASSES`	`DBA_JAVA_CLASSES`	`USER_JAVA_CLASSES`
`ALL_JAVA_DERIVATIONS`	`DBA_JAVA_DERIVATIONS`	`USER_JAVA_DERIVATIONS`
`ALL_JAVA_FIELDS`	`DBA_JAVA_FIELDS`	`USER_JAVA_FIELDS`
`ALL_JAVA_IMPLEMENTS`	`DBA_JAVA_IMPLEMENTS`	`USER_JAVA_IMPLEMENTS`
`ALL_JAVA_INNERS`	`DBA_JAVA_INNERS`	`USER_JAVA_INNERS`
`ALL_JAVA_LAYOUTS`	`DBA_JAVA_LAYOUTS`	`USER_JAVA_LAYOUTS`
`ALL_JAVA_METHODS`	`DBA_JAVA_METHODS`	`USER_JAVA_METHODS`
`ALL_JAVA_NCOMPS`	`DBA_JAVA_NCOMPS`	`USER_JAVA_NCOMPS`
`ALL_JAVA_RESOLVERS`	`DBA_JAVA_RESOLVERS`	`USER_JAVA_RESOLVERS`
`ALL_JAVA_THROWS`	`DBA_JAVA_THROWS`	`USER_JAVA_THROWS`
`ALL_LOB_TEMPLATES`	`DBA_LOB_TEMPLATES`	`USER_LOB_TEMPLATES`
	`DBA_LOGSTDBY_EVENTS`
	`DBA_LOGSTDBY_LOG`
	`DBA_LOGSTDBY_NOT_UNIQUE`
	`DBA_LOGSTDBY_PARAMETERS`
	`DBA_LOGSTDBY_PROGRESS`
	`DBA_LOGSTDBY_SKIP`
	`DBA_LOGSTDBY_SKIP_TRANSACTION`
	`DBA_LOGSTDBY_UNSUPPORTED`
`ALL_OBJ_COLATTRS`	`DBA_OBJ_COLATTRS`	`USER_OBJ_COLATTRS`
`ALL_PROPAGATION`	`DBA_PROPAGATION`
`ALL_PUBLISHED_COLUMNS`	`DBA_PUBLISHED_COLUMNS`	`USER_PUBLISHED_COLUMNS`
	`DBA_REGISTRY`	`USER_REGISTRY`
`ALL_REGISTRY_BANNERS`
	`DBA_REGISTRY_HIERARCHY`
`ALL_RULE_SET_RULES`	`DBA_RULE_SET_RULES`	`USER_RULE_SET_RULES`
`ALL_RULE_SETS`	`DBA_RULE_SETS`	`USER_RULE_SETS`
`ALL_RULES`	`DBA_RULES`	`USER_RULES`
`ALL_STREAMS_GLOBAL_RULES`	`DBA_STREAMS_GLOBAL_RULES`
`ALL_STREAMS_SCHEMA_RULES`	`DBA_STREAMS_SCHEMA_RULES`
`ALL_STREAMS_TABLE_RULES`	`DBA_STREAMS_TABLE_RULES`
`ALL_SUBPARTITION_TEMPLATES`	`DBA_SUBPARTITION_TEMPLATES`	`USER_SUBPARTITION_TEMPLATES`
`ALL_XML_SCHEMAS`	`DBA_XML_SCHEMAS`	`USER_XML_SCHEMAS`
`ALL_XML_TAB_COLS`	`DBA_XML_TAB_COLS`	`USER_XML_TAB_COLS`
`ALL_XML_TABLES`	`DBA_XML_TABLES`	`USER_XML_TABLES`
`ALL_XML_VIEW_COLS`	`DBA_XML_VIEW_COLS`	`USER_XML_VIEW_COLS`
`ALL_XML_VIEWS`	`DBA_XML_VIEWS`	`USER_XML_VIEWS`

See Also:

Chapter 2, "Static Data Dictionary Views" for more information about these static data dictionary views

The following dynamic performance views are new to this release:

`GV$AW_CALC`	`V$AW_CALC`
`GV$AW_OLAP`	`V$AW_OLAP`
`GV$AW_SESSION_INFO`	`V$AW_SESSION_INFO`
`GV$BACKUP_SPFILE`	`V$BACKUP_SPFILE`
`GV$DATABASE_BLOCK_CORRUPTION`	`V$DATABASE_BLOCK_CORRUPTION`
`GV$DATABASE_INCARNATION`	`V$DATABASE_INCARNATION`
`GV$DATAGUARD_STATUS`	`V$DATAGUARD_STATUS`
`GV$LIBRARY_CACHE_MEMORY`	`V$LIBRARY_CACHE_MEMORY`
`GV$LOGMNR_STATS`	`V$LOGMNR_STATS`
`GV$MAP_COMP_LIST`	`V$MAP_COMP_LIST`
`GV$MAP_ELEMENT`	`V$MAP_ELEMENT`
`GV$MAP_EXT_ELEMENT`	`V$MAP_EXT_ELEMENT`
`GV$MAP_FILE`	`V$MAP_FILE`
`GV$MAP_FILE_EXTENT`	`V$MAP_FILE_EXTENT`
`GV$MAP_FILE_IO_STACK`	`V$MAP_FILE_IO_STACK`
`GV$MAP_LIBRARY`	`V$MAP_LIBRARY`
`GV$MAP_SUBELEMENT`	`V$MAP_SUBELEMENT`
`GV$MTTR_TARGET_ADVICE`	`V$MTTR_TARGET_ADVICE`
`GV$PGA_TARGET_ADVICE`	`V$PGA_TARGET_ADVICE`
`GV$PGA_TARGET_ADVICE_HISTOGRAM`	`V$PGA_TARGET_ADVICE_HISTOGRAM`
`GV$SEGMENT_STATISTICS`	`V$SEGMENT_STATISTICS`
`GV$SEGSTAT`	`V$SEGSTAT`
`GV$SEGSTAT_NAME`	`V$SEGSTAT_NAME`
`GV$SGA_CURRENT_RESIZE_OPS`	`V$SGA_CURRENT_RESIZE_OPS`
`GV$SGA_DYNAMIC_COMPONENTS`	`V$SGA_DYNAMIC_COMPONENTS`
`GV$SGA_DYNAMIC_FREE_MEMORY`	`V$SGA_DYNAMIC_FREE_MEMORY`
`GV$SGA_RESIZE_OPS`	`V$SGA_RESIZE_OPS`
`GV$SHARED_POOL_ADVICE`	`V$SHARED_POOL_ADVICE`
`GV$SQL_PLAN_STATISTICS`	`V$SQL_PLAN_STATISTICS`
`GV$SQL_PLAN_STATISTICS_ALL`	`V$SQL_PLAN_STATISTICS_ALL`
`GV$SQL_WORKAREA_HISTOGRAM`	`V$SQL_WORKAREA_HISTOGRAM`
`GV$STATISTICS_LEVEL`	`V$STATISTICS_LEVEL`
`GV$STREAMS_APPLY_COORDINATOR`	`V$STREAMS_APPLY_COORDINATOR`
`GV$STREAMS_APPLY_READER`	`V$STREAMS_APPLY_READER`
`GV$STREAMS_APPLY_SERVER`	`V$STREAMS_APPLY_SERVER`
`GV$STREAMS_CAPTURE`	`V$STREAMS_CAPTURE`
`GV$TEMPSEG_USAGE`	`V$TEMPSEG_USAGE`

See Also:

Chapter 3, "Dynamic Performance (V$) Views" 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_IND_SUBPARTITIONS`	`HIGH_VALUE` `HIGH_VALUE_LENGTH`
`ALL_LOBS`	`RETENTION` `FREEPOOLS`
`ALL_MVIEWS`	`UNKNOWN_PREBUILT` `UNKNOWN_PLSQL_FUNC` `UNKNOWN_EXTERNAL_TABLE` `UNKNOWN_CONSIDER_FRESH` `UNKNOWN_IMPORT`
`ALL_NESTED_TABLES`	`ELEMENT_SUBSTITUTABLE`
`ALL_PART_TABLES`	`DEF_COMPRESSION`
`ALL_QUEUE_TABLES`	`SECURE`
`ALL_TAB_PARTITIONS`	`COMPRESSION`
`ALL_TAB_SUBPARTITIONS`	`HIGH_VALUE` `HIGH_VALUE_LENGTH` `COMPRESSION`
`ALL_VARRAYS`	`ELEMENT_SUBSTITUTABLE`
`DBA_FGA_AUDIT_TRAIL`	`USERHOST` `CLIENT_ID` `EXT_NAME`
`DBA_IND_SUBPARTITIONS`	`HIGH_VALUE` `HIGH_VALUE_LENGTH`
`DBA_LOBS`	`RETENTION` `FREEPOOLS`
`DBA_MVIEWS`	`UNKNOWN_PREBUILT` `UNKNOWN_PLSQL_FUNC` `UNKNOWN_EXTERNAL_TABLE` `UNKNOWN_CONSIDER_FRESH` `UNKNOWN_IMPORT`
`DBA_NESTED_TABLES`	`ELEMENT_SUBSTITUTABLE`
`DBA_PART_TABLES`	`DEF_COMPRESSION`
`DBA_QUEUE_TABLES`	`SECURE`
`DBA_TAB_PARTITIONS`	`COMPRESSION`
`DBA_TAB_SUBPARTITIONS`	`HIGH_VALUE` `HIGH_VALUE_LENGTH` `COMPRESSION`
`DBA_TABLESPACES`	`FORCE_LOGGING`
`DBA_VARRAYS`	`ELEMENT_SUBSTITUTABLE`
`USER_IND_SUBPARTITIONS`	`HIGH_VALUE` `HIGH_VALUE_LENGTH`
`USER_LOBS`	`RETENTION` `FREEPOOLS`
`USER_MVIEWS`	`UNKNOWN_PREBUILT` `UNKNOWN_PLSQL_FUNC` `UNKNOWN_EXTERNAL_TABLE` `UNKNOWN_CONSIDER_FRESH` `UNKNOWN_IMPORT`
`USER_NESTED_TABLES`	`ELEMENT_SUBSTITUTABLE`
`USER_PART_TABLES`	`DEF_COMPRESSION`
`USER_QUEUE_TABLES`	`SECURE`
`USER_TAB_PARTITIONS`	`COMPRESSION`
`USER_TAB_SUBPARTITIONS`	`HIGH_VALUE` `HIGH_VALUE_LENGTH` `COMPRESSION`
`USER_TABLESPACES`	`FORCE_LOGGING`
`USER_VARRAYS`	`ELEMENT_SUBSTITUTABLE`

See Also:

Chapter 2, "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 this release:

Dynamic Performance View	New Columns
`GV$ARCHIVE_DEST` and `V$ARCHIVE_DEST`	`DEST_NAME` `NET_TIMEOUT` `REGISTER` `REMOTE_TEMPLATE`
`GV$ARCHIVE_DEST_STATUS` and `V$ARCHIVE_DEST_STATUS`	`DEST_NAME` `PROTECTION_MODE` `SRL`
`GV$ARCHIVED_LOG` and `V$ARCHIVED_LOG`	`ACTIVATION#`
`GV$BACKUP_CORRUPTION` and `V$BACKUP_CORRUPTION`	`CORRUPTION_TYPE`
`GV$COPY_CORRUPTION` and `V$COPY_CORRUPTION`	`CORRUPTION_TYPE`
`GV$DATABASE` and `V$DATABASE`	`PROTECTION_MODE` `PROTECTION_LEVEL` `DATAGUARD_BROKER` `GUARD_STATUS` `SUPPLEMENTAL_LOG_DATA_MIN` `SUPPLEMENTAL_LOG_DATA_PK` `SUPPLEMENTAL_LOG_DATA_UI` `FORCE_LOGGING`
`GV$DATAFILE_COPY` and `V$DATAFILE_COPY`	`SCANNED`
`GV$DB_CACHE_ADVICE` and `V$DB_CACHE_ADVICE`	`SIZE_FACTOR`
`GV$DB_OBJECT_CACHE` and `V$DB_OBJECT_CACHE`	`CHILD_LATCH`
`GV$FILE_CACHE_TRANSFER` and `V$FILE_CACHE_TRANSFER`	`CR_TRANSFERS` `CUR_TRANSFERS`
`GV$LATCH_CHILDREN` and `V$LATCH_CHILDREN`	`MISSES_WAITLIST` `SLEEPS_WAITLIST` `WAIT_TIME_WAITLIST`
`GV$LATCH_PARENT` and `V$LATCH_PARENT`	`MISSES_WAITLIST` `SLEEPS_WAITLIST` `WAIT_TIME_WAITLIST`
`GV$LOGMNR_CALLBACK` and `V$LOGMNR_CALLBACK`	`STATE` `TYPE` `CAPABILITY`
`GV$LOGMNR_CONTENTS` and `V$LOGMNR_CONTENTS`	`PXIDUSN` `PXIDSLT` `PXIDSQN`
`GV$LOGMNR_REGION` and `V$LOGMNR_REGION`	`MEMSTATE` `STATE`
`GV$LOGSTDBY` and `V$LOGSTDBY`	`HIGH_SCN`
`GV$PGASTAT` and `V$PGASTAT`	`UNIT`
`GV$PROCESS` and `V$PROCESS`	`PGA_FREEABLE_MEM`
`GV$ROLLSTAT` and `V$ROLLSTAT`	`LATCH`
`GV$SQL` and `V$SQL`	`FETCHES` `CHILD_LATCH`
`GV$SQL_PLAN` and `V$SQL_PLAN`	`SEARCH_COLUMNS` `ACCESS_PREDICATES` `FILTER_PREDICATES`
`GV$SQL_SHARED_CURSOR` and `V$SQL_SHARED_CURSOR`	`NO_TRIGGER_MISMATCH` `FLASHBACK_CURSOR`
`GV$SQL_WORKAREA` and `V$SQL_WORKAREA`	`MAX_TEMPSEG_SIZE` `LAST_TEMPSEG_SIZE`
`GV$SQL_WORKAREA_ACTIVE` and `V$SQL_WORKAREA_ACTIVE`	`TEMPSEG_SIZE` `TABLESPACE` `SEGRFNO#` `SEGBLK#`
`GV$SQLAREA` and `V$SQLAREA`	`FETCHES` `CHILD_LATCH`

See Also:

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

Oracle9i Release 1 (9.0.1) New Features in Oracle9i Database Reference

The following initialization parameters are new to this release:

`ARCHIVE_LAG_TARGET`	`CIRCUITS`
`CLUSTER_INTERCONNECTS`	`CLUSTER_DATABASE`
`CLUSTER_DATABASE_INSTANCES`	`DB_``n``K_CACHE_SIZE`
`DB_CACHE_ADVICE`	`DB_CACHE_SIZE`
`DB_CREATE_FILE_DEST`	`DB_CREATE_ONLINE_LOG_DEST_``n`
`DB_KEEP_CACHE_SIZE`	`DB_RECYCLE_CACHE_SIZE`
`DISPATCHERS`	`DRS_START`
`FAL_CLIENT`	`FAL_SERVER`
`FAST_START_MTTR_TARGET`	`GLOBAL_CONTEXT_POOL_SIZE`
`LOG_ARCHIVE_DEST_``n` (`n` = 6, 7, ... 10)	`LOG_ARCHIVE_DEST_STATE_``n` (`n` = 6, 7, ... 10)
`LOGMNR_MAX_PERSISTENT_SESSIONS`	`MAX_DISPATCHERS`
`MAX_SHARED_SERVERS`	`NLS_LENGTH_SEMANTICS`
`NLS_NCHAR_CONV_EXCP`	`NLS_TIMESTAMP_FORMAT`
`NLS_TIMESTAMP_TZ_FORMAT`	`PGA_AGGREGATE_TARGET`
`PLSQL_COMPILER_FLAGS`	`PLSQL_NATIVE_C_COMPILER`
`PLSQL_NATIVE_LIBRARY_DIR`	`PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT`
`PLSQL_NATIVE_LINKER`	`PLSQL_NATIVE_MAKE_FILE_NAME`
`PLSQL_NATIVE_MAKE_UTILITY`	`REMOTE_ARCHIVE_ENABLE`
`REMOTE_LISTENER`	`SGA_MAX_SIZE`
`SHARED_SERVER_SESSIONS`	`SHARED_SERVERS`
`SPFILE`	`STANDBY_FILE_MANAGEMENT`
`STANDBY_PRESERVES_NAMES`	`trace_enabled`
`UNDO_MANAGEMENT`	`UNDO_RETENTION`
`UNDO_SUPPRESS_ERRORS`	`UNDO_TABLESPACE`
`WORKAREA_SIZE_POLICY`

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_APPLICATION_ROLES`	`USER_APPLICATION_ROLES`
	`DBA_ATTRIBUTE_TRANSFORMATIONS`	`USER_ATTRIBUTE_TRANSFORMATIONS`
`ALL_AUDIT_POLICIES`	`DBA_AUDIT_POLICIES`	`USER_AUDIT_POLICIES`
`ALL_BASE_TABLE_MVIEWS`	`DBA_BASE_TABLE_MVIEWS`	`USER_BASE_TABLE_MVIEWS`
`ALL_EXTERNAL_LOCATIONS`	`DBA_EXTERNAL_LOCATIONS`	`USER_EXTERNAL_LOCATIONS`
`ALL_EXTERNAL_TABLES`	`DBA_EXTERNAL_TABLES`	`USER_EXTERNAL_TABLES`
	`DBA_FGA_AUDIT_TRAIL`
	`DBA_GLOBAL_CONTEXT`
`ALL_INDEXTYPE_COMMENTS`	`DBA_INDEXTYPE_COMMENTS`	`USER_INDEXTYPE_COMMENTS`
`ALL_JOIN_IND_COLUMNS`	`DBA_JOIN_IND_COLUMNS`	`USER_JOIN_IND_COLUMNS`
`ALL_LOG_GROUP_COLUMNS`	`DBA_LOG_GROUP_COLUMNS`	`USER_LOG_GROUP_COLUMNS`
`ALL_LOG_GROUPS`	`DBA_LOG_GROUPS`	`USER_LOG_GROUPS`
	`DBA_MVIEW_LOG_FILTER_COLS`
`ALL_MVIEW_LOGS`	`DBA_MVIEW_LOGS`	`USER_MVIEW_LOGS`
`ALL_MVIEW_REFRESH_TIMES`	`DBA_MVIEW_REFRESH_TIMES`	`USER_MVIEW_REFRESH_TIMES`
`ALL_OPERATOR_COMMENTS`	`DBA_OPERATOR_COMMENTS`	`USER_OPERATOR_COMMENTS`
`ALL_PENDING_CONV_TABLES`	`DBA_PENDING_CONV_TABLES`	`USER_PENDING_CONV_TABLES`
`ALL_POLICY_CONTEXTS`	`DBA_POLICY_CONTEXTS`	`USER_POLICY_CONTEXTS`
`ALL_POLICY_GROUPS`	`DBA_POLICY_GROUPS`	`USER_POLICY_GROUPS`
`ALL_PROCEDURES`	`DBA_PROCEDURES`	`USER_PROCEDURES`
	`DBA_PROXIES`	`USER_PROXIES`
	`DBA_REGISTERED_MVIEW_GROUPS`
`ALL_REGISTERED_MVIEWS`	`DBA_REGISTERED_MVIEWS`	`USER_REGISTERED_MVIEWS`
	`DBA_REPCAT_EXCEPTIONS`
	`DBA_REPEXTENSIONS`
	`DBA_REPSITES_NEW`
	`DBA_RESUMABLE`	`USER_RESUMABLE`
`ALL_SECONDARY_OBJECTS`	`DBA_SECONDARY_OBJECTS`	`USER_SECONDARY_OBJECTS`
`ALL_SOURCE_TAB_COLUMNS`	`DBA_SOURCE_TAB_COLUMNS`	`USER_SOURCE_TAB_COLUMNS`
`ALL_SOURCE_TABLES`	`DBA_SOURCE_TABLES`	`USER_SOURCE_TABLES`
`ALL_SQLJ_TYPE_ATTRS`	`DBA_SQLJ_TYPE_ATTRS`	`USER_SQLJ_TYPE_ATTRS`
`ALL_SQLJ_TYPE_METHODS`	`DBA_SQLJ_TYPE_METHODS`	`USER_SQLJ_TYPE_METHODS`
`ALL_SQLJ_TYPES`	`DBA_SQLJ_TYPES`	`USER_SQLJ_TYPES`
`ALL_STORED_SETTINGS`	`DBA_STORED_SETTINGS`	`USER_STORED_SETTINGS`
`ALL_SUBSCRIBED_COLUMNS`	`DBA_SUBSCRIBED_COLUMNS`	`USER_SUBSCRIBED_COLUMNS`
`ALL_SUBSCRIBED_TABLES`	`DBA_SUBSCRIBED_TABLES`	`USER_SUBSCRIBED_TABLES`
`ALL_SUBSCRIPTIONS`	`DBA_SUBSCRIPTIONS`	`USER_SUBSCRIPTIONS`
`ALL_TAB_COLS`	`DBA_TAB_COLS`	`USER_TAB_COLS`
	`DBA_TEMPLATE_REFGROUPS`
	`DBA_TEMPLATE_TARGETS`
	`DBA_TRANSFORMATIONS`	`USER_TRANSFORMATIONS`
`ALL_TYPE_VERSIONS`	`DBA_TYPE_VERSIONS`	`USER_TYPE_VERSIONS`
	`DBA_UNDO_EXTENTS`

See Also:

Chapter 2, "Static Data Dictionary Views" for more information about these static data dictionary views

The following dynamic performance views are new to this release:

`GV$ACTIVE_SESS_POOL_MTH`	`V$ACTIVE_SESS_POOL_MTH`
`GV$ARCHIVE_DEST_STATUS`	`V$ARCHIVE_DEST_STATUS`
`GV$ARCHIVE_GAP`	`V$ARCHIVE_GAP`
`GV$CACHE_TRANSFER`	`V$CACHE_TRANSFER`
`GV$CLASS_CACHE_TRANSFER`	`V$CLASS_CACHE_TRANSFER`
`GV$CR_BLOCK_SERVER`	`V$CR_BLOCK_SERVER`
`GV$ENQUEUE_STAT`	`V$ENQUEUE_STAT`
`GV$FILE_CACHE_TRANSFER`	`V$FILE_CACHE_TRANSFER`
`GV$GC_ELEMENT`	`V$GC_ELEMENT`
`GV$GC_ELEMENTS_WITH_COLLISIONS`	`V$GC_ELEMENTS_WITH_COLLISIONS`
`GV$GCSHVMASTER_INFO`	`V$GCSHVMASTER_INFO`
`GV$GCSPFMASTER_INFO`	`V$GCSPFMASTER_INFO`
`GV$GES_BLOCKING_ENQUEUE`	`V$GES_BLOCKING_ENQUEUE`
`GV$GES_CONVERT_LOCAL`	`V$GES_CONVERT_LOCAL`
`GV$GES_CONVERT_REMOTE`	`V$GES_CONVERT_REMOTE`
`GV$GES_ENQUEUE`	`V$GES_ENQUEUE`
`GV$GES_LATCH`	`V$GES_LATCH`
`GV$GES_RESOURCE`	`V$GES_RESOURCE`
`GV$GES_STATISTICS`	`V$GES_STATISTICS`
`GV$GES_TRAFFIC_CONTROLLER`	`V$GES_TRAFFIC_CONTROLLER`
`GV$GLOBALCONTEXT`	`V$GLOBALCONTEXT`
`GV$HVMASTER_INFO`	`V$HVMASTER_INFO`
`GV$LOGMNR_CALLBACK`	`V$LOGMNR_CALLBACK`
`GV$LOGMNR_LOGFILE`	`V$LOGMNR_LOGFILE`
`GV$LOGMNR_PROCESS`	`V$LOGMNR_PROCESS`
`GV$LOGMNR_REGION`	`V$LOGMNR_REGION`
`GV$LOGMNR_SESSION`	`V$LOGMNR_SESSION`
`GV$LOGMNR_TRANSACTION`	`V$LOGMNR_TRANSACTION`
`GV$LOGSTDBY`	`V$LOGSTDBY`
`GV$LOGSTDBY_STATS`	`V$LOGSTDBY_STATS`
`GV$MANAGED_STANDBY`	`V$MANAGED_STANDBY`
`GV$MVREFRESH`	`V$MVREFRESH`
	`V$OBJECT_USAGE`
`GV$PGASTAT`	`V$PGASTAT`
`GV$QUEUEING_MTH`	`V$QUEUEING_MTH`
`GV$REPLPROP`	`V$REPLPROP`
`GV$REPLQUEUE`	`V$REPLQUEUE`
`GV$RESUMABLE`	`V$RESUMABLE`
`GV$RMAN_CONFIGURATION`	`V$RMAN_CONFIGURATION`
`GV$SHARED_SERVER_MONITOR`	`V$SHARED_SERVER_MONITOR`
`GV$SPPARAMETER`	`V$SPPARAMETER`
`GV$SQL_PLAN`	`V$SQL_PLAN`
`GV$SQL_REDIRECTION`	`V$SQL_REDIRECTION`
`GV$SQL_WORKAREA`	`V$SQL_WORKAREA`
`GV$SQL_WORKAREA_ACTIVE`	`V$SQL_WORKAREA_ACTIVE`
`GV$STANDBY_LOG`	`V$STANDBY_LOG`
`GV$TEMP_CACHE_TRANSFER`	`V$TEMP_CACHE_TRANSFER`
`GV$TIMEZONE_NAMES`	`V$TIMEZONE_NAMES`
`GV$UNDOSTAT`	`V$UNDOSTAT`
`GV$VPD_POLICY`	`V$VPD_POLICY`

See Also:

Chapter 3, "Dynamic Performance (V$) Views" 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`	`DEPENDENCIES`
`ALL_ARGUMENTS`	`CHAR_LENGTH` `CHAR_USED`
`ALL_ASSOCIATIONS`	`INTERFACE_VERSION`
`ALL_CLUSTERS`	`DEPENDENCIES`
`ALL_CONSTRAINTS`	`INDEX_OWNER` `INDEX_NAME` `INVALID` `VIEW_RELATED`
`ALL_DIMENSIONS`	`COMPILE_STATE`
`ALL_IND_COLUMNS`	`CHAR_LENGTH`
`ALL_IND_PARTITIONS`	`DOMIDX_OPSTATUS` `PARAMETERS`
`ALL_INDEXES`	`JOIN_INDEX`
`ALL_INDEXTYPE_OPERATORS`	`OPERATOR_SCHEMA`
`ALL_INDEXTYPES`	`INTERFACE_VERSION` `PARTITIONING`
`ALL_MVIEWS`	`USE_NO_INDEX`
`ALL_OBJECT_TABLES`	`DEPENDENCIES`
`ALL_OPBINDINGS`	`PROPERTY`
`ALL_OUTLINES`	`SIGNATURE`
`ALL_PART_INDEXES`	`DEF_PARAMETERS`
`ALL_POLICIES`	`POLICY_GROUP` `STATIC_POLICY`
`ALL_REPCAT_TEMPLATE_OBJECTS`	`DDL_NUM`
`ALL_REPCAT_TEMPLATE_SITES`	`INSTANTIATION_DATE`
`ALL_REPCOLUMN`	`CTYPE_TOID` `CTYPE_OWNER` `CTYPE_HASHCODE` `CTYPE_MOD` `TOP` `CHAR_LENGTH` `CHAR_USED`
`ALL_REPDDL`	`DDL_NUM`
`ALL_REPFLAVOR_COLUMNS`	`TYPE_TOID` `TYPE_OWNER` `TYPE_HASHCODE` `TYPE_MOD` `TOP`
`ALL_REPOBJECT`	`NESTED_TABLE`
`ALL_SUMDELTA`	`SEQUENCE`
`ALL_TAB_COL_STATISTICS`	`OWNER`
`ALL_TAB_COLUMNS`	`CHAR_LENGTH` `CHAR_USED` `V80_FMT_IMAGE` `DATA_UPGRADED`
`ALL_TAB_PRIVS`	`HIERARCHY`
`ALL_TAB_PRIVS_MADE`	`HIERARCHY`
`ALL_TAB_PRIVS_RECD`	`HIERARCHY`
`ALL_TABLES`	`DEPENDENCIES`
`ALL_TYPE_ATTRS`	`INHERITED`
`ALL_TYPE_METHODS`	`FINAL` `INSTANTIABLE` `OVERRIDING` `INHERITED`
`ALL_TYPES`	`FINAL` `INSTANTIABLE` `SUPERTYPE_OWNER` `SUPERTYPE_NAME` `LOCAL_ATTRIBUTES` `LOCAL_METHODS` `TYPEID`
`ALL_USTATS`	`PARTITION_NAME`
`ALL_VIEWS`	`SUPERVIEW_NAME`
`DBA_ALL_TABLES`	`DEPENDENCIES`
`DBA_ASSOCIATIONS`	`INTERFACE_VERSION`
`DBA_AUDIT_EXISTS`	`CLIENT_ID` `SESSION_CPU`
`DBA_AUDIT_OBJECT`	`CLIENT_ID` `SESSION_CPU`
`DBA_AUDIT_SESSION`	`CLIENT_ID` `SESSION_CPU`
`DBA_AUDIT_STATEMENT`	`CLIENT_ID` `SESSION_CPU`
`DBA_AUDIT_TRAIL`	`CLIENT_ID` `SESSION_CPU`
`DBA_CLUSTERS`	`DEPENDENCIES`
`DBA_CONSTRAINTS`	`INDEX_OWNER` `INDEX_NAME` `INVALID` `VIEW_RELATED`
`DBA_CONTEXT`	`TYPE`
`DBA_DIMENSIONS`	`COMPILE_STATE`
`DBA_IND_COLUMNS`	`CHAR_LENGTH`
`DBA_IND_PARTITIONS`	`DOMIDX_OPSTATUS` `PARAMETERS`
`DBA_INDEXES`	`JOIN_INDEX`
`DBA_INDEXTYPE_OPERATORS`	`OPERATOR_SCHEMA`
`DBA_INDEXTYPES`	`INTERFACE_VERSION` `PARTITIONING`
`DBA_MVIEWS`	`USE_NO_INDEX`
`DBA_OBJECT_TABLES`	`DEPENDENCIES`
`DBA_OPBINDINGS`	`PROPERTY`
`DBA_OUTLINES`	`SIGNATURE`
`DBA_PART_INDEXES`	`DEF_PARAMETERS`
`DBA_POLICIES`	`POLICY_GROUP` `STATIC_POLICY`
`DBA_REPCAT_TEMPLATE_OBJECTS`	`DDL_NUM`
`DBA_REPCAT_TEMPLATE_SITES`	`INSTANTIATION_DATE`
`DBA_REPCOLUMN`	`CTYPE_TOID` `CTYPE_OWNER` `CTYPE_HASHCODE` `CTYPE_MOD` `TOP` `CHAR_LENGTH` `CHAR_USED`
`DBA_REPDDL`	`DDL_NUM`
`DBA_REPFLAVOR_COLUMNS`	`TYPE_TOID` `TYPE_OWNER` `TYPE_HASHCODE` `TYPE_MOD` `TOP`
`DBA_REPOBJECT`	`NESTED_TABLE`
`DBA_RSRC_PLAN_DIRECTIVES`	`ACTIVE_SESS_POOL_P1` `QUEUEING_P1` `SWITCH_GROUP` `SWITCH_TIME` `SWITCH_ESTIMATE` `MAX_EST_EXEC_TIME` `UNDO_POOL`
`DBA_RSRC_PLANS`	`ACTIVE_SESS_POOL_MTH` `QUEUEING_MTH`
`DBA_TAB_COL_STATISTICS`	`OWNER`
`DBA_TAB_COLUMNS`	`CHAR_LENGTH` `CHAR_USED` `V80_FMT_IMAGE` `DATA_UPGRADED`
`DBA_TAB_PRIVS`	`HIERARCHY`
`DBA_TABLES`	`DEPENDENCIES`
`DBA_TABLESPACES`	`BLOCK_SIZE` `SEGMENT_SPACE_MANAGEMENT`
`DBA_TYPE_ATTRS`	`INHERITED`
`DBA_TYPE_METHODS`	`FINAL` `INSTANTIABLE` `OVERRIDING` `INHERITED`
`DBA_TYPES`	`FINAL` `INSTANTIABLE` `SUPERTYPE_OWNER` `SUPERTYPE_NAME` `LOCAL_ATTRIBUTES` `LOCAL_METHODS` `TYPEID`
`DBA_USTATS`	`PARTITION_NAME`
`DBA_VIEWS`	`SUPERVIEW_NAME`
`USER_ALL_TABLES`	`DEPENDENCIES`
`USER_ARGUMENTS`	`CHAR_LENGTH` `CHAR_USED`
`USER_ASSOCIATIONS`	`INTERFACE_VERSION`
`USER_AUDIT_OBJECT`	`CLIENT_ID` `SESSION_CPU`
`USER_AUDIT_SESSION`	`CLIENT_ID` `SESSION_CPU`
`USER_AUDIT_STATEMENT`	`CLIENT_ID` `SESSION_CPU`
`USER_AUDIT_TRAIL`	`CLIENT_ID` `SESSION_CPU`
`USER_CLUSTERS`	`DEPENDENCIES`
`USER_CONSTRAINTS`	`INDEX_OWNER` `INDEX_NAME` `INVALID` `VIEW_RELATED`
`USER_DIMENSIONS`	`COMPILE_STATE`
`USER_IND_COLUMNS`	`CHAR_LENGTH`
`USER_IND_PARTITIONS`	`DOMIDX_OPSTATUS` `PARAMETERS`
`USER_INDEXES`	`JOIN_INDEX`
`USER_INDEXTYPE_OPERATORS`	`OPERATOR_SCHEMA`
`USER_INDEXTYPES`	`INTERFACE_VERSION` `PARTITIONING`
`USER_MVIEWS`	`USE_NO_INDEX`
`USER_OBJECT_TABLES`	`DEPENDENCIES`
`USER_OPBINDINGS`	`PROPERTY`
`USER_OUTLINES`	`SIGNATURE`
`USER_PART_INDEXES`	`DEF_PARAMETERS`
`USER_POLICIES`	`POLICY_GROUP` `STATIC_POLICY`
`USER_REPCAT_TEMPLATE_OBJECTS`	`DDL_NUM`
`USER_REPCAT_TEMPLATE_SITES`	`INSTANTIATION_DATE`
`USER_REPCOLUMN`	`CTYPE_TOID` `CTYPE_OWNER` `CTYPE_HASHCODE` `CTYPE_MOD` `TOP` `CHAR_LENGTH` `CHAR_USED`
`USER_REPDDL`	`DDL_NUM`
`USER_REPFLAVOR_COLUMNS`	`TYPE_TOID` `TYPE_OWNER` `TYPE_HASHCODE` `TYPE_MOD` `TOP`
`USER_REPOBJECT`	`NESTED_TABLE`
`USER_REPPARAMETER_COLUMN`	`SNAME`
`USER_TAB_COLUMNS`	`CHAR_LENGTH` `CHAR_USED` `DATA_UPGRADED` `V80_FMT_IMAGE`
`USER_TAB_PRIVS`	`HIERARCHY`
`USER_TAB_PRIVS_MADE`	`HIERARCHY`
`USER_TAB_PRIVS_RECD`	`HIERARCHY`
`USER_TABLES`	`DEPENDENCIES`
`USER_TABLESPACES`	`BLOCK_SIZE` `SEGMENT_SPACE_MANAGEMENT`
`USER_TYPE_ATTRS`	`INHERITED`
`USER_TYPE_METHODS`	`FINAL` `INSTANTIABLE` `OVERRIDING` `INHERITED`
`USER_TYPES`	`FINAL` `INSTANTIABLE` `SUPERTYPE_OWNER` `SUPERTYPE_NAME` `LOCAL_ATTRIBUTES` `LOCAL_METHODS` `TYPEID`
`USER_USTATS`	`PARTITION_NAME`
`USER_VIEWS`	`SUPERVIEW_NAME`

See Also:

Chapter 2, "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 this release:

Dynamic Performance View	New Columns
`GV$ARCHIVE` and `V$ARCHIVE`	`ISCURRENT`
`GV$ARCHIVE_DEST` and `V$ARCHIVE_DEST`	`ARCHIVER` `SCHEDULE` `LOG_SEQUENCE` `DELAY_MINS` `PROCESS` `MANIFEST` `FAILURE_COUNT` `MAX_FAILURE` `ALTERNATE` `DEPENDENCY` `REGISTER` `QUOTA_SIZE` `QUOTA_USED` `MOUNTID` `TRANSMIT_MODE` `AFFIRM` `TYPE`
`GV$ARCHIVED_LOG` and `V$ARCHIVED_LOG`	`DEST_ID` `APPLIED` `STATUS` `DICTIONARY_BEGIN` `DICTIONARY_END` `END_OF_REDO` `BACKUP_COUNT` `ARCHIVAL_THREAD#`
`GV$BACKUP_SET` and `V$BACKUP_SET`	`KEEP` `KEEP_UNTIL` `KEEP_OPTIONS`
`GV$BUFFER_POOL` and `V$BUFFER_POOL`	`BLOCK_SIZE` `RESIZE_STATE` `CURRENT_SIZE` `TARGET_SIZE` `TARGET_BUFFERS` `PREV_SIZE` `PREV_BUFFERS`
`GV$BUFFER_POOL_STATISTICS` and `V$BUFFER_POOL_STATISTICS`	`BLOCK_SIZE`
`GV$CIRCUIT` and `V$CIRCUIT`	`PCIRCUIT`
`GV$DATABASE` and `V$DATABASE`	`STANDBY_MODE` `REMOTE_ARCHIVE` `ACTIVATION#` `DATABASE_ROLE` `ARCHIVELOG_CHANGE#` `SWITCHOVER_STATUS`
`GV$DATAFILE` and `V$DATAFILE`	`BLOCK1_OFFSET` `AUX_NAME`
`GV$DATAFILE_COPY` and `V$DATAFILE_COPY`	`STATUS` `KEEP` `KEEP_UNTIL` `KEEP_OPTIONS`
`GV$DB_CACHE_ADVICE` and `V$DB_CACHE_ADVICE`	`BLOCK_SIZE` `ADVICE_STATUS`
`GV$DELETED_OBJECT` and `V$DELETED_OBJECT`	`OBJECT_DATA`
`GV$FILESTAT` and `V$FILESTAT`	`SINGLEBLKRDS` `SINGLEBLKRDTIM`
`GV$INSTANCE` and `V$INSTANCE`	`ACTIVE_STATE`
`GV$INSTANCE_RECOVERY` and `V$INSTANCE_RECOVERY`	`TARGET_MTTR` `ESTIMATED_MTTR` `CKPT_BLOCK_WRITES`
`GV$LATCH` and `V$LATCH`	`WAIT_TIME`
`GV$LATCH_CHILDREN` and `V$LATCH_CHILDREN`	`WAIT_TIME`
`GV$LATCH_MISSES` and `V$LATCH_MISSES`	`LOCATION`
`GV$LATCH_PARENT` and `V$LATCH_PARENT`	`WAIT_TIME`
`GV$LOGFILE` and `V$LOGFILE`	`TYPE`
`GV$LOGMNR_CONTENTS` and `V$LOGMNR_CONTENTS`	`CSCN` `COMMIT_TIMESTAMP` `TX_NAME` `OPERATION_CODE` `SEQUENCE#` `REDO_VALUE` `UNDO_VALUE` `SQL_COLUMN_TYPE` `SQL_COLUMN_NAME` `REDO_LENGTH` `REDO_OFFSET` `UNDO_LENGTH` `UNDO_OFFSET`
`GV$LOGMNR_LOGS` and `V$LOGMNR_LOGS`	`DICTIONARY_BEGIN` `DICTIONARY_END`
`GV$MLS_PARAMETERS` and `V$MLS_PARAMETERS`	`UPDATE_COMMENT`
`GV$PARAMETER` and `V$PARAMETER`	`UPDATE_COMMENT`
`GV$PARAMETER2` and `V$PARAMETER2`	`ORDINAL` `UPDATE_COMMENT`
`GV$PROCESS` and `V$PROCESS`	`PGA_USED_MEM` `PGA_ALLOC_MEM` `PGA_MAX_MEM`
`GV$PROXY_DATAFILE` and `V$PROXY_DATAFILE`	`KEEP` `KEEP_UNTIL` `KEEP_OPTIONS`
`GV$RECOVER_FILE` and `V$RECOVER_FILE`	`ONLINE_STATUS`
`GV$RSRC_CONSUMER_GROUP` and `V$RSRC_CONSUMER_GROUP`	`QUEUE_LENGTH` `CURRENT_UNDO_CONSUMPTION`
`GV$SESSION` and `V$SESSION`	`CURRENT_QUEUE_DURATION` `CLIENT_IDENTIFIER`
`GV$SESSION_EVENT` and `V$SESSION_EVENT`	`TIME_WAITED_MICRO`
`GV$SORT_USAGE` and `V$SORT_USAGE`	`USERNAME`
`GV$SQL` and `V$SQL`	`PLAN_HASH_VALUE` `CPU_TIME` `ELAPSED_TIME` `OUTLINE_SID` `CHILD_ADDRESS` `SQLTYPE` `REMOTE` `OBJECT_STATUS` `LITERAL_HASH_VALUE` `LAST_LOAD_TIME` `IS_OBSOLETE`
`GV$SQL_SHARED_CURSOR` and `V$SQL_SHARED_CURSOR`	`LOGMINER_SESSION_MISMATCH` `INCOMP_LTRL_MISMATCH` `OVERLAP_TIME_MISMATCH` `USER_BIND_PEEK_MISMATCH` `TYPCHK_DEP_MISMATCH`
`GV$SQLAREA` and `V$SQLAREA`	`CPU_TIME` `ELAPSED_TIME` `IS_OBSOLETE`
`GV$SYSTEM_EVENT` and `V$SYSTEM_EVENT`	`TIME_WAITED_MICRO`
`GV$SYSTEM_PARAMETER` and `V$SYSTEM_PARAMETER`	`UPDATE_COMMENT`
`GV$SYSTEM_PARAMETER2` and `V$SYSTEM_PARAMETER2`	`ORDINAL` `UPDATE_COMMENT`
`GV$TABLESPACE` and `V$TABLESPACE`	`INCLUDED_IN_DATABASE_BACKUP`
`GV$TEMPSTAT` and `V$TEMPSTAT`	`SINGLEBLKRDS` `SINGLEBLKRDTIM`
`GV$TRANSACTION` and `V$TRANSACTION`	`NAME`

See Also:

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