Oracle Databaseリファレンスの新機能

ここでは、Oracle Database 11g リリース1（11.1）の新機能について説明し、追加情報の参照先を示します。以前のリリースのOracle Databaseにおける新機能の詳細は、該当するリリースのマニュアルを参照してください。

このマニュアルでは、次の項で新機能について説明します。

• Oracle Database 11g リリース1（11.1）の新機能

Oracle Database 11g リリース1（11.1）の新機能

リリース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

関連項目 これらの初期化パラメータの詳細は、第I部「初期化パラメータ」を参照してください。

リリース11.1では、次の静的データ・ディクショナリ・ビューに新しい列が追加されています。

ALL_ビュー	DBA_ビュー	USER_ビュー
	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

関連項目: これらの静的データ・ディクショナリ・ビューの詳細は、第II部「静的データ・ディクショナリ・ビュー」を参照してください。

リリース11.1では、次の動的パフォーマンス・ビューが追加されています。

GV$ビュー	V$ビュー
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

関連項目: これらの動的パフォーマンス・ビューの詳細は、第III部「動的パフォーマンス・ビュー」を参照してください。