Validation of Sort Sizes in an Oracle10g Database
Appendix A: All Initialization Parameters
Download 3.53 Mb.
|
Appendix A: All Initialization ParametersIn this appendix I list all of the initialization parameters, both documented and undocumented for the TEST environment. Documented Initialization ParametersMon Sep 05 page 1 INIT.ORA PARAMETER LISTING NUM TYPE NAME VALUE ---- ----- ------------------------------------- ------------------------------ 660 1 O7_DICTIONARY_ACCESSIBILITY FALSE 317 6 __db_cache_size 717225984 96 6 __java_pool_size 8388608 94 6 __large_pool_size 4194304 92 6 __shared_pool_size 234881024 208 3 active_instance_count #### 3 aq_tm_processes 0 450 3 archive_lag_target 0 #### 2 asm_diskgroups #### 2 asm_diskstring #### 3 asm_power_limit 1 761 2 audit_file_dest /home/oracle/DBHome1/rdbms/aud it 666 1 audit_sys_operations FALSE 779 2 audit_trail TRUE 750 2 background_core_dump partial 751 2 background_dump_dest /home/oracle/admin/test/bdump 167 1 backup_tape_io_slaves FALSE 712 3 bitmap_merge_area_size 1048576 802 1 blank_trimming FALSE 349 2 buffer_pool_keep 350 2 buffer_pool_recycle 679 3 circuits 469 1 cluster_database FALSE 472 3 cluster_database_instances 1 180 2 cluster_interconnects 672 3 commit_point_strength 1 389 2 compatible 10.1.0.2.0 303 3 control_file_record_keep_time 7 296 2 control_files /home/oracle/oradata/test/con trol01.ctl, /home/oracle/orada ta/test/control02.ctl, /home/ oracle/oradata/test/control03 .ctl
754 2 core_dump_dest /home/oracle/admin/test/cdump 42 3 cpu_count 2 711 3 create_bitmap_area_size 8388608 653 2 create_stored_outlines 714 2 cursor_sharing EXACT 690 1 cursor_space_for_time FALSE 323 6 db_16k_cache_size 0 320 6 db_2k_cache_size 0 324 6 db_32k_cache_size 0 321 6 db_4k_cache_size 0 322 6 db_8k_cache_size 0 304 3 db_block_buffers 0 630 1 db_block_checking FALSE 308 1 db_block_checksum TRUE Mon Sep 05 page 2 INIT.ORA PARAMETER LISTING NUM TYPE NAME VALUE ---- ----- ------------------------------------- ------------------------------ 309 3 db_block_size 8192 378 2 db_cache_advice ON 318 6 db_cache_size 0 473 2 db_create_file_dest 474 2 db_create_online_log_dest_1 475 2 db_create_online_log_dest_2 476 2 db_create_online_log_dest_3 477 2 db_create_online_log_dest_4 478 2 db_create_online_log_dest_5 668 2 db_domain 465 3 db_file_multiblock_read_count 32 301 2 db_file_name_convert 464 3 db_files 200 557 3 db_flashback_retention_target 1440 325 6 db_keep_cache_size 0 787 2 db_name test 479 2 db_recovery_file_dest /home/oracle/flash_recovery_ar ea
480 6 db_recovery_file_dest_size 2147483648 326 6 db_recycle_cache_size 0 789 2 db_unique_name test 331 3 db_writer_processes 7 163 3 dbwr_io_slaves 0 576 1 ddl_wait_for_locks FALSE #### 2 dg_broker_config_file1 /home/oracle/DBHome1/dbs/dr1hf dwh.dat
#### 2 dg_broker_config_file2 /home/oracle/DBHome1/dbs/dr2hf dwh.dat
#### 1 dg_broker_start FALSE 160 1 disk_asynch_io TRUE 675 2 dispatchers (PROTOCOL=TCP) (SERVICE=testX DB)
670 3 distributed_lock_timeout 60 575 3 dml_locks 2924 #### 1 drs_start FALSE 119 3 enqueue_resources 3000 45 2 event 440 2 fal_client 441 2 fal_server 522 3 fast_start_io_target 0 523 3 fast_start_mttr_target 0 625 2 fast_start_parallel_rollback LOW 185 1 file_mapping FALSE 152 2 fileio_network_adapters 154 2 filesystemio_options none 778 2 fixed_date Mon Sep 05 page 3 INIT.ORA PARAMETER LISTING NUM TYPE NAME VALUE ---- ----- ------------------------------------- ------------------------------ 486 2 gc_files_to_locks 197 3 gcs_server_processes 0 667 2 global_context_pool_size 669 1 global_names FALSE 739 3 hash_area_size 131072 58 3 hi_shared_memory_address 0 #### 1 hs_autoregister TRUE 791 4 ifile 44 2 instance_groups 673 2 instance_name test 585 3 instance_number 0 113 2 instance_type RDBMS 104 3 java_max_sessionspace_size 0 97 6 java_pool_size 0 103 3 java_soft_sessionspace_limit 0 706 3 job_queue_processes 10 95 6 large_pool_size 0 654 2 ldap_directory_access NONE 25 3 license_max_sessions 0 663 3 license_max_users 0 26 3 license_sessions_warning 0 681 2 local_listener 19 2 lock_name_space 61 1 lock_sga FALSE 397 2 log_archive_config 405 2 log_archive_dest 407 2 log_archive_dest_1 416 2 log_archive_dest_10 408 2 log_archive_dest_2 409 2 log_archive_dest_3 410 2 log_archive_dest_4 411 2 log_archive_dest_5 412 2 log_archive_dest_6 413 2 log_archive_dest_7 414 2 log_archive_dest_8 415 2 log_archive_dest_9 417 2 log_archive_dest_state_1 enable 426 2 log_archive_dest_state_10 enable 418 2 log_archive_dest_state_2 enable 419 2 log_archive_dest_state_3 enable 420 2 log_archive_dest_state_4 enable 421 2 log_archive_dest_state_5 enable 422 2 log_archive_dest_state_6 enable 423 2 log_archive_dest_state_7 enable 424 2 log_archive_dest_state_8 enable 425 2 log_archive_dest_state_9 enable 406 2 log_archive_duplex_dest 434 2 log_archive_format %t_%s_%r.dbf 433 1 log_archive_local_first TRUE 427 3 log_archive_max_processes 2 Mon Sep 05 page 4 INIT.ORA PARAMETER LISTING NUM TYPE NAME VALUE ---- ----- ------------------------------------- ------------------------------ 430 3 log_archive_min_succeed_dest 1 399 1 log_archive_start FALSE 432 3 log_archive_trace 0 445 3 log_buffer 524288 447 3 log_checkpoint_interval 0 448 3 log_checkpoint_timeout 1800 528 1 log_checkpoints_to_alert FALSE 302 2 log_file_name_convert 538 3 logmnr_max_persistent_sessions 1 387 3 max_commit_propagation_delay 700 678 3 max_dispatchers 753 2 max_dump_file_size UNLIMITED 657 3 max_enabled_roles 150 677 3 max_shared_servers 140 2 nls_calendar 146 2 nls_comp 137 2 nls_currency 136 2 nls_date_format 135 2 nls_date_language 145 2 nls_dual_currency 139 2 nls_iso_currency 132 2 nls_language AMERICAN 147 2 nls_length_semantics BYTE 148 2 nls_nchar_conv_excp FALSE 138 2 nls_numeric_characters 134 2 nls_sort 133 2 nls_territory AMERICA 141 2 nls_time_format 143 2 nls_time_tz_format 142 2 nls_timestamp_format 144 2 nls_timestamp_tz_format 764 3 object_cache_max_size_percent 10 763 3 object_cache_optimal_size 102400 #### 6 olap_page_pool_size 0 790 3 open_cursors 300 771 3 open_links 4 772 3 open_links_per_instance 4 960 3 optimizer_dynamic_sampling 2 777 2 optimizer_features_enable 10.1.0.3 872 3 optimizer_index_caching 0 871 3 optimizer_index_cost_adj 100 795 2 optimizer_mode ALL_ROWS 793 2 os_authent_prefix ops$ 655 1 os_roles FALSE 847 1 parallel_adaptive_multi_user TRUE 849 1 parallel_automatic_tuning FALSE 729 3 parallel_execution_message_size 2148 726 2 parallel_instance_group 721 3 parallel_max_servers 40 708 3 parallel_min_percent 0 Mon Sep 05 page 5 INIT.ORA PARAMETER LISTING NUM TYPE NAME VALUE ---- ----- ------------------------------------- ------------------------------ 720 3 parallel_min_servers 0 470 1 parallel_server FALSE 471 3 parallel_server_instances 1 848 3 parallel_threads_per_cpu 2 939 6 pga_aggregate_target 1073741824 702 2 plsql_code_type INTERPRETED 698 2 plsql_compiler_flags INTERPRETED, NON_DEBUG 704 1 plsql_debug FALSE 699 2 plsql_native_library_dir 700 3 plsql_native_library_subdir_count 0 705 3 plsql_optimize_level 2 697 1 plsql_v2_compatibility FALSE 701 2 plsql_warnings DISABLE:ALL 56 1 pre_page_sga FALSE 20 3 processes 600 881 2 query_rewrite_enabled TRUE 882 2 query_rewrite_integrity enforced 656 2 rdbms_server_dn 467 1 read_only_open_delayed FALSE 529 3 recovery_parallelism 0 396 2 remote_archive_enable true 693 2 remote_dependencies_mode TIMESTAMP 682 2 remote_listener 662 2 remote_login_passwordfile EXCLUSIVE 658 1 remote_os_authent FALSE 659 1 remote_os_roles FALSE 579 1 replication_dependency_tracking TRUE 24 1 resource_limit FALSE 171 2 resource_manager_plan 627 3 resumable_timeout 0 600 2 rollback_segments 689 2 serial_reuse disable 674 2 service_names test 691 3 session_cached_cursors 0 766 3 session_max_open_files 10 21 3 sessions 665 52 6 sga_max_size 1073741824 285 6 sga_target 1073741824 749 2 shadow_core_dump partial 57 3 shared_memory_address 0 100 6 shared_pool_reserved_size 11744051 93 6 shared_pool_size 0 680 3 shared_server_sessions 676 3 shared_servers 1 #### 1 skip_unusable_indexes TRUE 695 2 smtp_out_server 781 3 sort_area_retained_size 0 780 3 sort_area_size 65536 788 2 sp_name test 112 2 spfile /home/oracle/DBHome1/dbs/spfil Mon Sep 05 page 6 INIT.ORA PARAMETER LISTING NUM TYPE NAME VALUE ---- ----- ------------------------------------- ---------------------- etest.ora 800 1 sql92_security FALSE 792 1 sql_trace FALSE 913 2 sql_version NATIVE #### 2 sqltune_category DEFAULT 431 2 standby_archive_dest ?/dbs/arch 482 2 standby_file_management MANUAL 807 2 star_transformation_enabled TRUE 981 2 statistics_level TYPICAL 98 6 streams_pool_size 104857600 161 1 tape_asynch_io TRUE 517 3 thread 0 23 3 timed_os_statistics 0 22 1 timed_statistics TRUE 124 1 trace_enabled TRUE 2 2 tracefile_identifier 597 3 transactions 731 598 3 transactions_per_rollback_segment 5 608 2 undo_management AUTO 621 3 undo_retention 900 609 2 undo_tablespace UNDOTBSP2 59 1 use_indirect_data_buffers FALSE 752 2 user_dump_dest /home/oracle/admin/test/udump 694 2 utl_file_dir 941 2 workarea_size_policy AUTO
Download 3.53 Mb. Share with your friends:
|