Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
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
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

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

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

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


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