WARNING: This web is not used anymore. Please use PDBService.KeyParams instead!
 

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.04
*.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=''
*.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=FALSE
*.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
*.parallel_max_servers=0
*.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
*.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)
Edit | Attach | Watch | Print version | History: r5 < r4 < r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r3 - 2006-02-17 - LucaCanali
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

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