Validation of Sort Sizes in an Oracle10g Database


Appendix A: All Initialization Parameters



Download 3.53 Mb.
Page3/17
Date28.05.2018
Size3.53 Mb.
#50899
1   2   3   4   5   6   7   8   9   ...   17

Appendix A: All Initialization Parameters


In this appendix I list all of the initialization parameters, both documented and undocumented for the TEST environment.

Documented Initialization Parameters


Mon 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
259 rows selected.



Download 3.53 Mb.

Share with your friends:
1   2   3   4   5   6   7   8   9   ...   17




The database is protected by copyright ©ininet.org 2022
send message

    Main page