Few Important init.ora parameters for 11g database

Important init.ora parameters for 11g database.

Two new memory-related parameters—memory_target and memory_max_target—provide support for the new automatic memory management
/*IMP: If you also set the sga_target and the pga_aggregate_target parameters, the database will consider them the minimum values for the
SGA and PGA allocations of memory. The memory_target parameter can take a value anywhere between the sum of SGA and PGA to the high
value set by the memory_max_target parameter. /*

The plsql_code_type parameter lets you turn on PL/SQL native compilation : PL/SQL native compilation is very faster mechanism as compared to older.

The diagnostic_dest parameter lets you set the ADR base directory.This parameter replaces the traditional background_dump_dest, user_
dump_dest, and core_dump_dest parameters. The diagnostic_dest parameter’s value defaults to $ORACLE_BASE. The diagnostic_dest
parameter is recommended but not mandatory. If you do set this parameter, the database will ignore any *_dump_dest parameters you may have set.

The result_cache_mode parameter supports result caching, a major new feature. In addition to the result_cache_mode parameter, you
have other result cache–related initialization parameters, such as the result_cache_max_result, result_cache_max_size, and
result_cache_remote_expiration parameters. The new parameters client_result_cache_size and client_result_cache_lag
support the new client-side result caching feature.

The ddl_time_lockout parameter enables you to control the duration for which a DDL statement will wait for a DML lock. A new capability to control the length of time a DDL statement will wait for a necessary DML lock.

The db_securefile parameter enables you to specify whether to treat a LOB file as a traditional Oracle LOB or the new Oracle SecureFiles format.
Oracle SecureFiles is a new Oracle Database 11g feature that offers a more efficient approach to storing file content such as images, audio, video, PDFs, and spreadsheets.

The db_ultra_safe parameter enables you to control three corruptionchecking parameters—db_block_checking, db_block_checksum,
and db_lost_write_protect.

The sec_case_sensitive_logon parameter lets you manage the enabling and disabling of password case sensitivity in the database. By
default, Oracle Database 11g enforces password case sensitivity.

The parameter sec_max_failed_login_attempts enables you to specify the maximum number of times a client can make a connection attempt.

No comments:

Post a Comment