The following is a list of the DB instance parameters for 10.1.0.4 at Tier 0. Please refer to Installation Procedure for 10.2 parameters (a few minor differences can be found there compared to the list here below)

*._recyclebin=FALSE  -> Only for 10.1.0.4
*.cluster_database=TRUE
*.cluster_database_instances=4
*.compatible='10.1.0.4.0'
*.db_block_size=8192
*.db_cache_advice='READY' -> Note can be changed to ON (default)
*.db_create_file_dest='+DATA_DG1'
*.db_domain=..dbdomain..
*.db_file_multiblock_read_count=16 -> Note: may be worth try to tune this to 128 (1 MB IO)
*.db_name=..dbname..
*.db_recovery_file_dest='+recovery_db1'
*.db_recovery_file_dest_size=1099511627776
*.global_names=TRUE
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=+RECOVERY_DB1/..dbname..' 
*.log_archive_format='%t_%s_%r.dbf' -> Note change to 'log%t_%s_%r.arc'
*.log_buffer=10485760 
*.open_cursors=300
*.open_links=4
*.parallel_max_servers=10
*.pga_aggregate_target=1610612736
*.processes=500
*.remote_listener='...listener_alias_here....'
*.remote_login_passwordfile='exclusive'
*.sessions=555 -> NOTE: calculated param by oracle from processes
*.sga_target=1698693120
*.streams_pool_size=200M -> minimun of the Streams pool
*.undo_management='AUTO'
*.undo_retention=1800
*.audit_file_dest='/ORA/dbs00/oracle/admin/..dbname../adump'
*.core_dump_dest='/ORA/dbs00/oracle/admin/..dbname../cdump'
*.background_dump_dest='/ORA/dbs00/oracle/admin/..dbname../bdump'
*.user_dump_dest='/ORA/dbs00/oracle/admin/..dbname../udump'
*.audit_trail='db'
OTHER parameters with instance dependent values: instance_number, local_listener, thread, undo_tablespace

The following is a list of the ASM instance parameters for 10.1.0.4 at T0

*.asm_diskgroups='RECOVERY_DB1','DATA_DG1'
*.asm_diskstring='ORCL:*'
*.cluster_database=true
*.cluster_database_instances=4
*.instance_type='asm'
*.large_pool_size=41943040
*.processes=60
*.remote_login_passwordfile='exclusive'
*.sga_max_size=157286400
*.shared_pool_size=67108864
*.user_dump_dest='/ORA/dbs00/oracle/admin/+ASM/udump'
*.background_dump_dest='/ORA/dbs00/oracle/admin/+ASM/bdump'
*.core_dump_dest='/ORA/dbs00/oracle/admin/+ASM/cdump'
OTHER parameters: instance_number
NOTE: -> Note: may be worth try to tune *.db_cache_size=50000000 (default is 24M)


This topic: PSSGroup > PhysicsDatabasesSection > LCG3DWiki > DatabaseSetup > KeyParams
Topic revision: r5 - 2006-03-10 - LucaCanali
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback