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 T0

*._recyclebin=FALSE
*.cluster_database=TRUE
*.cluster_database_instances=4
*.compatible='10.1.0.4.0'
*.db_block_size=8192
*.db_cache_advice='READY'
*.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'
*.log_buffer=10485760
*.nls_length_semantics='BYTE'
*.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: instance_number, 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: r1 - 2006-02-07 - 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