Carey Martinez wrote in message <36640879.48621684_at_news.mho.net>...
>Good Morning,
>
>We are in the process of going live with a new database. We would like
>to verify that we have set up out init.ora correctly. Any help would
>be appreciated.
>
>Background:
>___________________________________________________________________________
__
>
>System: Sun Enterprise 4000 connected to Several A5000 Network Arrays
>6 CPU's 256 mhz, 1.5 GB memory
>OS: Solaris 2.5.1 build 7/98 with Veritas File System, 3.2.5, Veritas
>Volume Manager 2.3.4, and Veritas Quick I/O 1.1.2
>Database will be OLTP intensive
>with 25 to 50 consecutive users
>
>___________________________________________________________________________
___
>* Oracle Shared Memory Parameters from system file
>*
>set shmsys:shminfo_shmmax=699998208
>set shmsys:shminfo_shmmin=1
>set semsys:seminfo_semmap=250
>set semsys:seminfo_semmni=500
>set semsys:seminfo_semmns=500
>set semsys:seminfo_semmnu=500
>set semsys:seminfo_semume=100
>set shmsys:shminfo_shmmni=55
>set shmsys:shminfo_shmseg=100
>set shmsys:share_page_table=1
>* vxvm_START (do not remove)
>forceload: drv/vxdmp
>forceload: drv/vxio
>forceload: drv/vxspec
>forceload: drv/sd
>forceload: drv/SUNW,fas
>forceload: drv/sbus
>forceload: drv/fdd
>rootdev:/pseudo/vxio_at_0:0
>set vxio:vol_rootdev_is_volume=1
>___________________________________________________________________________
__
>Init file
>
>###########################################################################
#############################
># Filename: /oracle_home/dbs/inittest.ora
>#
># Notes: This file needs to reside under $ORACLE_HOME/dbs
>#
># Modified: 01/29/98 - - added compatible = 7.3.3.0.0
>#
># Modified: 03/20/98 - - turned on archive logging, fixed incorrect
># archive log path.
># Modified: 05/20/98 - - upped max_enabled_roles to 35.
># Modified: 09/21/98 - - added CURSOR_SPACE_FOR_TIME
># - added CHECKPOINT_PROCESS
># - change OPTIMIZER_MODE to cost based
>(choose)
># - upped log_checkpoint_interval based on
>80M redos.
># - set compatible = 7.3.4.2.0
># Modified: 11/19/98 - - changed the number of processes from 100 to
>50
># Modified: 11/19/98 - - added use_ism=true (for performance tuning)
># Modified: 11/19/98 - - added pre_page_sga=true (for performance
>tuning)
># Modified: 11/19/98 - - added log_archive_buffer_size=128
>#
># Modified: 11/23/98 - - added use_readv = false for quick i/o.
># - changed db_file_multiblock_read_count
>from 32
># to 2048 for quick i/o.
>###########################################################################
####
>
>db_name = test
>
>use_readv = false
>
>async_write = true
>
>async_read = true
>
>max_enabled_roles = 35
>
>db_file_multiblock_read_count = 2048
>
>db_block_size = 4096
>
>db_block_buffers = 122070
>
>db_files = 500
>
>compatible = 7.3.4.2.0
>
>shared_pool_size = 96000000
>
>open_cursors=240
>
>#log_checkpoint_interval = 40000
>log_checkpoint_interval = 80000
>
>processes = 50
>
>use_ism=true
>
>pre_page_sga=true
>
>
>resource_limit=true
>
>dml_locks = 100
>
>log_buffer = 245760
>
>sequence_cache_entries = 30
>
>sequence_cache_hash_buckets = 23
>
>UTL_FILE_DIR = /var/oralog
>
>UTL_FILE_DIR = /opt/projects/pbtool/oralog
>
>SORT_DIRECT_WRITES = TRUE
>
>sort_write_buffer_size = 65536
>
>sort_write_buffers = 16
>
>CHECKPOINT_PROCESS = TRUE
>
>OPTIMIZER_MODE = CHOOSE
>
>CURSOR_SPACE_FOR_TIME = TRUE
>
>REMOTE_OS_AUTHENT = TRUE
>
>audit_trail = db # if you want auditing
># timed_statistics = true # if you want timed statistics
>max_dump_file_size = 10240 # limit trace file size to 5 Meg each
>
># Uncommenting the line below will cause automatic archiving if
>archiving has
># been enabled using ALTER DATABASE ARCHIVELOG.
>log_archive_start = true
>log_archive_dest = /oracle_home/Archive/arch.dbf
>log_archive_format = "T%TS%S.ARC"
>log_archive_buffer_size=128
>
>########################################################################
># COMMENT OUT THE FOLLOWING IF REBUILDING THE DATABASE. ORACLE WILL
># AUTOMATICALLY ADD THE DEFAULT RBS TO THE SYSTEM TABLESPACE.
>########################################################################
>rollback_segments = (rbs_1, rbs_4, rbs_2, rbs_5 rbs_3
>rbs_6,rbs_7,rbs_8,rbs_9,rbs_10,rbs_11,rbs_12,rbs_13,rbs_14,rbs_15,rbs_16,rb
s_17,rbs_18)
>
># Global Naming -- enforce that a dblink has same name as the db it
>connects to
>global_names = FALSE
>
># Edit and uncomment the following line to provide the suffix that
>will be
># appended to the db_name parameter (separated with a dot) and stored
>as the
># global database name when a database is created. If your site uses
># Internet Domain names for e-mail, then the part of your e-mail
>address after
># the '@' is a good candidate for this parameter value.
>
># db_domain = us.acme.com # global database name is
>db_name.db_domain
>
># FOR DEVELOPMENT ONLY, DEFAULT TO SINGLE-PROCESS
># single_process = TRUE
>
># FOR DEVELOPMENT ONLY, ALWAYS TRY TO USE SYSTEM BACKING STORE
>#vms_sga_use_gblpagfil = TRUE
>
>#_db_block_cache_protect = true # memory protect
>buffers
>#event = "10210 trace name context forever, level 2" # data block
>checking
>#event = "10211 trace name context forever, level 2" # index block
>checking
>#event = "10235 trace name context forever, level 1" # memory heap
>checking
>#event = "10049 trace name context forever, level 2" # memory protect
>cursors
>
>
># define parallel server (multi-instance) parameters
>#ifile = ora_system:initps.ora
>
># define three control files by default
>control_files = (cntrltest.dbf,/oracle_home/Data/cntrltest.dbf)
>
Received on Wed Dec 02 1998 - 13:06:13 CST
