What's New in Oracle Database Reference?This section describes new features of Oracle Database 11g release 1 (11.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 11g Release 1 (11.1) New Features
The following initialization parameters are new to release 11.1:
ASM_PREFERRED_READ_FAILURE_GROUPS
CLIENT_RESULT_CACHE_LAG
CLIENT_RESULT_CACHE_SIZE
COMMIT_LOGGING
COMMIT_WAIT
CONTROL_MANAGEMENT_PACK_ACCESS
DB_LOST_WRITE_PROTECT
DB_SECUREFILE
DB_ULTRA_SAFE
DDL_LOCK_TIMEOUT
DIAGNOSTIC_DEST
GLOBAL_TXN_PROCESSES
JAVA_JIT_ENABLED
LDAP_DIRECTORY_SYSAUTH
MEMORY_MAX_TARGET
MEMORY_TARGET
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES
OPTIMIZER_USE_INVISIBLE_INDEXES
OPTIMIZER_USE_PENDING_STATISTICS
OPTIMIZER_USE_SQL_PLAN_BASELINES
PARALLEL_IO_CAP_ENABLED
PLSCOPE_SETTINGS
REDO_TRANSPORT_USER
RESOURCE_MANAGER_CPU_ALLOCATION
RESULT_CACHE_MAX_RESULT
RESULT_CACHE_MAX_SIZE
RESULT_CACHE_MODE
RESULT_CACHE_REMOTE_EXPIRATION
SEC_CASE_SENSITIVE_LOGON
SEC_MAX_FAILED_LOGIN_ATTEMPTS
SEC_PROTOCOL_ERROR_FURTHER_ACTION
SEC_PROTOCOL_ERROR_TRACE_ACTION
SEC_RETURN_SERVER_RELEASE_BANNER
XML_DB_EVENTS
See Also:
Part I, "Initialization Parameters" for more information about these initialization parameters
The following static data dictionary views are new to release 11.1:
ALL_ Views DBA_ Views USER_ Views
DBA_ADDM_FDG_BREAKDOWN USER_ADDM_FDG_BREAKDOWN
DBA_ADDM_FINDINGS USER_ADDM_FINDINGS
DBA_ADDM_INSTANCES USER_ADDM_INSTANCES
DBA_ADDM_SYSTEM_DIRECTIVES
DBA_ADDM_TASK_DIRECTIVES USER_ADDM_TASK_DIRECTIVES
DBA_ADDM_TASKS USER_ADDM_TASKS
DBA_ADVISOR_DIR_DEFINITIONS
DBA_ADVISOR_DIR_INSTANCES
DBA_ADVISOR_DIR_TASK_INST USER_ADVISOR_DIR_TASK_INST
DBA_ADVISOR_EXEC_PARAMETERS USER_ADVISOR_EXEC_PARAMETERS
DBA_ADVISOR_EXECUTION_TYPES
DBA_ADVISOR_EXECUTIONS USER_ADVISOR_EXECUTIONS
DBA_ADVISOR_FDG_BREAKDOWN USER_ADVISOR_FDG_BREAKDOWN
DBA_ADVISOR_FINDING_NAMES
DBA_ADVISOR_SQLA_COLVOL USER_ADVISOR_SQLA_COLVOL
DBA_ADVISOR_SQLA_TABLES USER_ADVISOR_SQLA_TABLES
DBA_ADVISOR_SQLA_TABVOL USER_ADVISOR_SQLA_TABVOL
DBA_ADVISOR_SQLA_WK_SUM USER_ADVISOR_SQLA_WK_SUM
DBA_ADVISOR_SQLPLANS USER_ADVISOR_SQLPLANS
DBA_ADVISOR_SQLSTATS USER_ADVISOR_SQLSTATS
DBA_ARGUMENTS
ALL_ASSEMBLIES DBA_ASSEMBLIES USER_ASSEMBLIES
DBA_AUTOTASK_CLIENT
DBA_AUTOTASK_CLIENT_HISTORY
DBA_AUTOTASK_CLIENT_JOB
DBA_AUTOTASK_OPERATION
DBA_AUTOTASK_SCHEDULE
DBA_AUTOTASK_TASK
DBA_AUTOTASK_WINDOW_CLIENTS
DBA_AUTOTASK_WINDOW_HISTORY
ALL_CHANGE_PROPAGATION_SETS
ALL_CHANGE_PROPAGATIONS
ALL_CHANGE_SETS
ALL_CHANGE_SOURCES
ALL_CHANGE_TABLES
ALL_COL_PENDING_STATS DBA_COL_PENDING_STATS USER_COL_PENDING_STATS
DBA_COMPARISON USER_COMPARISON
DBA_COMPARISON_COLUMNS USER_COMPARISON_COLUMNS
DBA_COMPARISON_ROW_DIF USER_COMPARISON_ROW_DIF
DBA_COMPARISON_SCAN USER_COMPARISON_SCAN
DBA_COMPARISON_SCAN_SUMMARY USER_COMPARISON_SCAN_SUMMARY
DBA_COMPARISON_SCAN_VALUES USER_COMPARISON_SCAN_VALUES
DBA_CPOOL_INFO
DBA_CQ_NOTIFICATION_QUERIES USER_CQ_NOTIFICATION_QUERIES
ALL_CUBE_ATTR_VISIBILITY DBA_CUBE_ATTR_VISIBILITY USER_CUBE_ATTR_VISIBILITY
ALL_CUBE_ATTRIBUTES DBA_CUBE_ATTRIBUTES USER_CUBE_ATTRIBUTES
ALL_CUBE_BUILD_PROCESSES DBA_CUBE_BUILD_PROCESSES USER_CUBE_BUILD_PROCESSES
ALL_CUBE_CALCULATED_MEMBERS DBA_CUBE_CALCULATED_MEMBERS USER_CUBE_CALCULATED_MEMBERS
ALL_CUBE_DIM_LEVELS DBA_CUBE_DIM_LEVELS USER_CUBE_DIM_LEVELS
ALL_CUBE_DIM_MODELS DBA_CUBE_DIM_MODELS USER_CUBE_DIM_MODELS
ALL_CUBE_DIM_VIEW_COLUMNS DBA_CUBE_DIM_VIEW_COLUMNS USER_CUBE_DIM_VIEW_COLUMNS
ALL_CUBE_DIM_VIEWS DBA_CUBE_DIM_VIEWS USER_CUBE_DIM_VIEWS
ALL_CUBE_DIMENSIONALITY DBA_CUBE_DIMENSIONALITY USER_CUBE_DIMENSIONALITY
ALL_CUBE_DIMENSIONS DBA_CUBE_DIMENSIONS USER_CUBE_DIMENSIONS
ALL_CUBE_HIER_LEVELS DBA_CUBE_HIER_LEVELS USER_CUBE_HIER_LEVELS
ALL_CUBE_HIER_VIEW_COLUMNS DBA_CUBE_HIER_VIEW_COLUMNS USER_CUBE_HIER_VIEW_COLUMNS
ALL_CUBE_HIER_VIEWS DBA_CUBE_HIER_VIEWS USER_CUBE_HIER_VIEWS
ALL_CUBE_HIERARCHIES DBA_CUBE_HIERARCHIES USER_CUBE_HIERARCHIES
ALL_CUBE_MEASURES DBA_CUBE_MEASURES USER_CUBE_MEASURES
ALL_CUBE_VIEW_COLUMNS DBA_CUBE_VIEW_COLUMNS USER_CUBE_VIEW_COLUMNS
ALL_CUBE_VIEWS DBA_CUBE_VIEWS USER_CUBE_VIEWS
ALL_CUBES DBA_CUBES USER_CUBES
DBA_EPG_DAD_AUTHORIZATION USER_EPG_DAD_AUTHORIZATION
DBA_FLASHBACK_ARCHIVE USER_FLASHBACK_ARCHIVE
DBA_FLASHBACK_ARCHIVE_TABLES USER_FLASHBACK_ARCHIVE_TABLES
DBA_FLASHBACK_ARCHIVE_TS
DBA_FLASHBACK_TXN_REPORT USER_FLASHBACK_TXN_REPORT
DBA_FLASHBACK_TXN_STATE USER_FLASHBACK_TXN_STATE
DBA_HIST_BASELINE_DETAILS
DBA_HIST_BASELINE_METADATA
DBA_HIST_BASELINE_TEMPLATE
DBA_HIST_CLUSTER_INTERCON
DBA_HIST_COLORED_SQL
DBA_HIST_EVENT_HISTOGRAM
DBA_HIST_IC_CLIENT_STATS
DBA_HIST_IC_DEVICE_STATS
DBA_HIST_INTERCONNECT_PINGS
DBA_HIST_IOSTAT_FILETYPE
DBA_HIST_IOSTAT_FILETYPE_NAME
DBA_HIST_IOSTAT_FUNCTION
DBA_HIST_IOSTAT_FUNCTION_NAME
DBA_HIST_MEM_DYNAMIC_COMP
DBA_HIST_MEMORY_RESIZE_OPS
DBA_HIST_MEMORY_TARGET_ADVICE
DBA_HIST_MUTEX_SLEEP
DBA_HIST_PERSISTENT_QUEUES
DBA_HIST_PERSISTENT_SUBS
DBA_HIST_RSRC_CONSUMER_GROUP
DBA_HIST_RSRC_PLAN
ALL_IDENTIFIERS DBA_IDENTIFIERS USER_IDENTIFIERS
ALL_IND_PENDING_STATS DBA_IND_PENDING_STATS USER_IND_PENDING_STATS
DBA_INVALID_OBJECTS
ALL_JAVA_COMPILER_OPTIONS DBA_JAVA_COMPILER_OPTIONS USER_JAVA_COMPILER_OPTIONS
DBA_LOGSTDBY_UNSUPPORTED_TABLE
ALL_MEASURE_FOLDER_CONTENTS DBA_MEASURE_FOLDER_CONTENTS USER_MEASURE_FOLDER_CONTENTS
ALL_MEASURE_FOLDERS DBA_MEASURE_FOLDERS USER_MEASURE_FOLDERS
ALL_MINING_MODEL_ATTRIBUTES DBA_MINING_MODEL_ATTRIBUTES USER_MINING_MODEL_ATTRIBUTES
ALL_MINING_MODEL_SETTINGS DBA_MINING_MODEL_SETTINGS USER_MINING_MODEL_SETTINGS
ALL_MINING_MODELS DBA_MINING_MODELS USER_MINING_MODELS
ALL_MVIEW_DETAIL_PARTITION DBA_MVIEW_DETAIL_PARTITION USER_MVIEW_DETAIL_PARTITION
ALL_MVIEW_DETAIL_SUBPARTITION DBA_MVIEW_DETAIL_SUBPARTITION USER_MVIEW_DETAIL_SUBPARTITION
DBA_NETWORK_ACL_PRIVILEGES USER_NETWORK_ACL_PRIVILEGES
DBA_NETWORK_ACLS
DBA_OLDIMAGE_COLUMNS USER_OLDIMAGE_COLUMNS
DBA_REGISTRY_DATABASE
DBA_REGISTRY_DEPENDENCIES
DBA_REGISTRY_PROGRESS
DBA_RSRC_CAPABILITY
DBA_RSRC_CATEGORIES
DBA_RSRC_INSTANCE_CAPABILITY
DBA_RSRC_IO_CALIBRATE
DBA_RSRC_STORAGE_POOL_MAPPING
ALL_SCHEDULER_CREDENTIALS DBA_SCHEDULER_CREDENTIALS USER_SCHEDULER_CREDENTIALS
DBA_SCHEDULER_JOB_ROLES
ALL_SCHEDULER_REMOTE_DATABASES DBA_SCHEDULER_REMOTE_DATABASES
ALL_SCHEDULER_REMOTE_JOBSTATE DBA_SCHEDULER_REMOTE_JOBSTATE USER_SCHEDULER_REMOTE_JOBSTATE
DBA_SQL_MANAGEMENT_CONFIG
DBA_SQL_PATCHES
DBA_SQL_PLAN_BASELINES
ALL_STAT_EXTENSIONS DBA_STAT_EXTENSIONS USER_STAT_EXTENSIONS
ALL_STREAMS_COLUMNS DBA_STREAMS_COLUMNS
DBA_STREAMS_TP_COMPONENT
DBA_STREAMS_TP_COMPONENT_LINK
DBA_STREAMS_TP_COMPONENT_STAT
DBA_STREAMS_TP_DATABASE
DBA_STREAMS_TP_PATH_BOTTLENECK
DBA_STREAMS_TP_PATH_STAT
DBA_SUBSCR_REGISTRATIONS USER_SUBSCR_REGISTRATIONS
ALL_SYNC_CAPTURE DBA_SYNC_CAPTURE
ALL_SYNC_CAPTURE_PREPARED_TABS DBA_SYNC_CAPTURE_PREPARED_TABS
ALL_SYNC_CAPTURE_TABLES DBA_SYNC_CAPTURE_TABLES
ALL_TAB_HISTGRM_PENDING_STATS DBA_TAB_HISTGRM_PENDING_STATS USER_TAB_HISTGRM_PENDING_STATS
ALL_TAB_PENDING_STATS DBA_TAB_PENDING_STATS USER_TAB_PENDING_STATS
ALL_TAB_STAT_PREFS DBA_TAB_STAT_PREFS USER_TAB_STAT_PREFS
DBA_TEMP_FREE_SPACE
ALL_TRIGGER_ORDERING DBA_TRIGGER_ORDERING USER_TRIGGER_ORDERING
DBA_USERS_WITH_DEFPWD
DBA_WORKLOAD_CAPTURES
DBA_WORKLOAD_CONNECTION_MAP
DBA_WORKLOAD_FILTERS
DBA_WORKLOAD_REPLAY_DIVERGENCE
DBA_WORKLOAD_REPLAYS
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 11.1:
GV$ Views V$ Views
GV$ASM_ATTRIBUTE V$ASM_ATTRIBUTE
GV$ASM_DISK_IOSTAT V$ASM_DISK_IOSTAT
GV$CALLTAG V$CALLTAG
GV$CLIENT_RESULT_CACHE_STATS V$CLIENT_RESULT_CACHE_STATS
GV$CORRUPT_XID_LIST V$CORRUPT_XID_LIST
GV$CPOOL_CC_INFO V$CPOOL_CC_INFO
GV$CPOOL_CC_STATS V$CPOOL_CC_STATS
GV$CPOOL_STATS V$CPOOL_STATS
GV$DETACHED_SESSION V$DETACHED_SESSION
GV$DIAG_INFO V$DIAG_INFO
GV$DNFS_CHANNELS V$DNFS_CHANNELS
GV$DNFS_FILES V$DNFS_FILES
GV$DNFS_SERVERS V$DNFS_SERVERS
GV$DNFS_STATS V$DNFS_STATS
GV$DYNAMIC_REMASTER_STATS V$DYNAMIC_REMASTER_STATS
GV$ENCRYPTED_TABLESPACES V$ENCRYPTED_TABLESPACES
GV$ENCRYPTION_WALLET V$ENCRYPTION_WALLET
V$FLASHBACK_TXN_GRAPH
V$FLASHBACK_TXN_MODS
GV$FOREIGN_ARCHIVED_LOG V$FOREIGN_ARCHIVED_LOG
GV$FS_FAILOVER_HISTOGRAM V$FS_FAILOVER_HISTOGRAM
GV$FS_FAILOVER_STATS V$FS_FAILOVER_STATS
GV$HM_CHECK V$HM_CHECK
GV$HM_CHECK_PARAM V$HM_CHECK_PARAM
GV$HM_FINDING V$HM_FINDING
GV$HM_INFO V$HM_INFO
GV$HM_RECOMMENDATION V$HM_RECOMMENDATION
GV$HM_RUN V$HM_RUN
GV$INCMETER_CONFIG V$INCMETER_CONFIG
GV$INCMETER_INFO V$INCMETER_INFO
GV$INCMETER_SUMMARY V$INCMETER_SUMMARY
GV$IOFUNCMETRIC V$IOFUNCMETRIC
GV$IOFUNCMETRIC_HISTORY V$IOFUNCMETRIC_HISTORY
GV$IOSTAT_CONSUMER_GROUP V$IOSTAT_CONSUMER_GROUP
GV$IOSTAT_FILE V$IOSTAT_FILE
GV$IOSTAT_FUNCTION V$IOSTAT_FUNCTION
GV$IOSTAT_NETWORK V$IOSTAT_NETWORK
GV$IO_CALIBRATION_STATUS V$IO_CALIBRATION_STATUS
GV$IR_FAILURE V$IR_FAILURE
GV$IR_FAILURE_SET V$IR_FAILURE_SET
GV$IR_MANUAL_CHECKLIST V$IR_MANUAL_CHECKLIST
GV$IR_REPAIR V$IR_REPAIR
GV$LOBSTAT V$LOBSTAT
GV$MEMORY_CURRENT_RESIZE_OPS V$MEMORY_CURRENT_RESIZE_OPS
GV$MEMORY_DYNAMIC_COMPONENTS V$MEMORY_DYNAMIC_COMPONENTS
GV$MEMORY_RESIZE_OPS V$MEMORY_RESIZE_OPS
GV$MEMORY_TARGET_ADVICE V$MEMORY_TARGET_ADVICE
GV$NFS_CLIENTS V$NFS_CLIENTS
GV$NFS_LOCKS V$NFS_LOCKS
GV$NFS_OPEN_FILES V$NFS_OPEN_FILES
V$OBJECT_PRIVILEGE
GV$PERSISTENT_PUBLISHERS V$PERSISTENT_PUBLISHERS
GV$PERSISTENT_QUEUES V$PERSISTENT_QUEUES
GV$PERSISTENT_SUBSCRIBERS V$PERSISTENT_SUBSCRIBERS
GV$PROCESS_GROUP V$PROCESS_GROUP
GV$PX_INSTANCE_GROUP V$PX_INSTANCE_GROUP
GV$REDO_DEST_RESP_HISTOGRAM V$REDO_DEST_RESP_HISTOGRAM
GV$RESULT_CACHE_DEPENDENCY V$RESULT_CACHE_DEPENDENCY
GV$RESULT_CACHE_MEMORY V$RESULT_CACHE_MEMORY
GV$RESULT_CACHE_OBJECTS V$RESULT_CACHE_OBJECTS
GV$RESULT_CACHE_STATISTICS V$RESULT_CACHE_STATISTICS
GV$RMAN_COMPRESSION_ALGORITHM V$RMAN_COMPRESSION_ALGORITHM
V$RMAN_ENCRYPTION_ALGORITHMS
GV$RSRCMGRMETRIC V$RSRCMGRMETRIC
GV$RSRCMGRMETRIC_HISTORY V$RSRCMGRMETRIC_HISTORY
GV$SECUREFILE_TIMER V$SECUREFILE_TIMER
V$SESSION_FIX_CONTROL
GV$SQL_CS_HISTOGRAM V$SQL_CS_HISTOGRAM
GV$SQL_CS_SELECTIVITY V$SQL_CS_SELECTIVITY
GV$SQL_CS_STATISTICS V$SQL_CS_STATISTICS
GV$SQL_FEATURE V$SQL_FEATURE
GV$SQL_FEATURE_DEPENDENCY V$SQL_FEATURE_DEPENDENCY
GV$SQL_FEATURE_HIERARCHY V$SQL_FEATURE_HIERARCHY
GV$SQL_HINT V$SQL_HINT
GV$SQL_MONITOR V$SQL_MONITOR
GV$SQL_PLAN_MONITOR V$SQL_PLAN_MONITOR
GV$SQLFN_ARG_METADATA V$SQLFN_ARG_METADATA
GV$SQLFN_METADATA V$SQLFN_METADATA
GV$SSCR_SESSIONS V$SSCR_SESSIONS
GV$STREAMS_MESSAGE_TRACKING V$STREAMS_MESSAGE_TRACKING
GV$SUBSCR_REGISTRATION_STATS V$SUBSCR_REGISTRATION_STATS
V$SYSTEM_FIX_CONTROL
V$WAIT_CHAINS
GV$WORKLOAD_REPLAY_THREAD V$WORKLOAD_REPLAY_THREAD
V$XS_SESSION
V$XS_SESSION_ATTRIBUTE
V$XS_SESSION_ROLE
See Also:
Part III, "Dynamic Performance Views" for more information about these dynamic performance views
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment