How parameter "processes" in initXXXX.ora affect Oracle

From: Harry Sheng <hsheng_at_innovance.com>
Date: Fri, 5 Oct 2001 17:45:55 -0400
Message-ID: <SYpv7.65076$TW.352343@tor-nn1.netcom.ca>

Hi, group

Could anyone give me some idea on how Oracle instance is affected by parameter "processes" in initXXXX.ora?
I am doing a fresh install of Oracle8.1.7 on Solaris2.7. I consistently get an ORA-03113 error. I figured out that
the parameter "processes" in init.ora causes the problem. The default value for "processes" is 50. I have to reduce
it to 30 to clear the problem.
My Solaris box is "Enterprise 420r". I believe that I have far more than enough resource to support 50 Oracle
user processes on my box. Here is the exact copy of my "init.ora" file.

---

---

db_name = "imsb"
instance_name = imsb
global_names = true

db_domain = innovance.com
service_names = imsb.innovance.com

control_files = ("/opt/oracle/oradata/imsb/control01.ctl", "/opt/oracle/oradata/imsb/control02.ctl", "/opt/oracle/oradata/imsb/control03.ctl")

db_block_size = 8192
db_block_buffers = 100

log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
log_buffer = 32768

processes = 30

max_dump_file_size = 10000

# log_archive_start = true
# log_archive_dest_1 = "location=/opt/oracle/admin/imsb/arch"
# log_archive_format = arch_%t_%s.arc

#rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6 )

# transactions = 40
# transactions_per_rollback_segment = 10

background_dump_dest = /opt/oracle/admin/imsb/bdump
core_dump_dest = /opt/oracle/admin/imsb/cdump
user_dump_dest = /opt/oracle/admin/imsb/udump

compatible = "8.1.0"
sort_area_size = 65536
sort_area_retained_size = 65536

# remote_login_passwordfile = none

---

---

Harry Sheng Received on Fri Oct 05 2001 - 16:45:55 CDT