Tuesday, September 23, 2008

New initialization Parameters in Oracle 11g


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

Oracle initializatoin parameters


More Oracle DBA tips, please visit Oracle DBA Tips 

New Data Dictionary views in Oracle 11g

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

Oracle data dictionary views

Oracle dynamic performance views