tailieunhanh - oracle Applications DBA Field Guide phần 3

Tham khảo tài liệu 'oracle applications dba field guide phần 3', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | 36 CHAPTER 2 CONFIGURATION Table 2-15. Continued Initialization Parameter Recommended Value Description Compatible Version dependent The version of the database. For example or . _system_trig_enabled TRUE Enables system triggers. O7_dictionary_accessibility Version dependent This parameter enables data dictionary querying. For Oracle Applications it can be set to FALSE. For versions and lower this parameter must be set to TRUE. nls_date_format DD-MON-RR Default date format. nls_sort BINARY When set to BINARY the collating sequence for the ORDER BY clause is based on the numeric values of characters. nls_comp BINARY When set to BINARY comparisons in the WHERE clause and in PL SQL blocks are binary. nls_length_semantics BYTE Required for NLS and character sets. max_enabled_roles 100 Some applications require max_enabled_roles to be set. This must be set to 100 for Oracle Applications. background_dump_dest Environment dependent Destination for background dump files. core_dump_dest Environment dependent Destination for core dump files. user_dump_dest Environment dependent Destination for user trace and dump files. cursor_sharing EXACT Determines which types of SQL statements can share cursors. It must be set to EXACT for Oracle Applications. aq_tm_processes 1 Enables time monitoring of queue messages. job_queue_processes 2 Maximum number of processes created for execution of jobs. CHAPTER 2 CONFIGURATION 37 Initialization Parameter Recommended Value Description Log_archive_start TRUE Enables automatic archive logging. db_file_multiblock_read_count 8 Maximum number of blocks read during an I O scan. optimizer_max_permutations 200 Maximum number of table permutations considered for optimizing joins in order to reduce parse time. query_rewrite_enabled TRUE Enables query rewriting. _sort_elimination_cost_ratio 5 Affects cost based optimizer. _like_with_bind_as_equality TRUE Affects cost based optimizer. _fast_full_scan_enabled FALSE Affects cost