Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to increase MAX number of connections for Oracle DB server?
In pfile initp65db.ora , the configuration is : (should I just change
parameter process=128 to 1200 ?)
......
control_files = ("/oracle/oradata/pin65db/control/rlvcontrol01", "/ oracle/oradata/pin65db/control/rlvcontrol02", "/oracle/oradata/pi n65db/control/rlvcontrol03")
#log_file_name_convert = ("/oracle/oradata/pindb-stdby","/oracle/
oradata/pindb")
#db_file_name_convert = ("/oracle/oradata/pindb-stdby","/oracle/
oradata/pindb")
open_cursors = 500
max_enabled_roles = 30
db_block_buffers = 1200000
#shared_pool_size = 500000000
shared_pool_size = 600000000
#large_pool_size = 614400
large_pool_size = 30M
java_pool_size = 0
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 128
log_buffer = 5242880
# audit_trail = false # if you want auditing
# timed_statistics = false # if you want timed statistics
# max_dump_file_size = 10000 # limit trace file size to 5M each
# Uncommenting the lines below will cause automatic archiving if
archiving has
# been enabled using ALTER DATABASE ARCHIVELOG.
# log_archive_start = true
# log_archive_dest_1 = "location=/oracle/app/oracle/admin/pindb/arch"
# log_archive_format = arch_%t_%s.arc
log_archive_start = true log_archive_dest_1 = "location=/arch/pin65db" log_archive_format = arch_%t_%s.arc
#DBCA uses the default database value (30) for max_rollback_segments
#100 rollback segments (or more) may be required in the future
#Uncomment the following entry when additional rollback segments are
created and made online
#max_rollback_segments = 101
# If using private rollback segments, place lines of the following
# form in each of your instance-specific init.ora files:
rollback_segments =
(PINROLL00,PINROLL01,PINROLL02,PINROLL03,PINROLL04,PINROLL05,PINROLL06,PINROLL07,PINROLL08,PINROLL09,PINROLL10,P
INROLL11,PINROLL12,PINROLL13,PINROLL14,PINROLL15,PINROLL16,PINROLL17,PINROLL18,PINROLL19,PINROLL20,PINROLL21,PINROLL22,PINROLL23,PIN
ROLL24,PINROLL25,PINROLL26,PINROLL27,PINROLL28,PINROLL29,PINROLL30,PINROLL31,PINROLL32,PINROLL33,PINROLL34,PINROLL35,PINROLL36,PINRO
LL37,PINROLL38,PINROLL39,PINROLL40,PINROLL41,PINROLL42,PINROLL43,PINROLL44,PINROLL45,PINROLL46,PINROLL47,PINROLL48,PINROLL49,PINROLL
50,PINROLL51,PINROLL52,PINROLL53,PINROLL54,PINROLL55,PINROLL56,PINROLL57,PINROLL58,PINROLL59,PINROLL60,PINROLLBIG,PINROLL61,PINROLL6
2,PINROLL63,PINROLL64,PINROLL65,PINROLL66,PINROLL67,PINROLL68,PINROLL69,PINROLL70,PINROLL71,PINROLL72,PINROLL73,PINROLL74,PINROLL75,
PINROLL76,PINROLL77,PINROLL78,PINROLL79,PINROLL80,PINROLL81,PINROLL82,PINROLL83,PINROLL84,PINROLL85,PINROLL86,PINROLL87,PINROLL88,PI
NROLL89,PINROLL90,PINROLL91,PINROLL92,PINROLL93,PINROLL94,PINROLL95,PINROLL96,PINROLL97,PINROLL98,PINROLL99)
# Global Naming -- enforce that a dblink has same name as the db it
connects to
global_names = true
# Uncomment the following line if you wish to enable the Oracle Trace
product
# to trace server activity. This enables scheduling of server
collections
# from the Oracle Enterprise Manager Console.
# Also, if the oracle_trace_collection_name parameter is non-null,
# every session will write to the named collection, as well as
enabling you
# to schedule future collections from the console.
# oracle_trace_enable = true
# define directories to store trace and alert files
background_dump_dest = /oracle/app/oracle/admin/pin65db/bdump
core_dump_dest = /oracle/app/oracle/admin/pin65db/cdump
#Uncomment this parameter to enable resource management for your
database.
#The SYSTEM_PLAN is provided by default with the database.
#Change the plan name if you have created your own resource plan.#
resource_manager_plan = system_plan
user_dump_dest = /oracle/app/oracle/admin/pin65db/udump
db_block_size = 4096
remote_login_passwordfile = exclusive
os_authent_prefix = ""
compatible = "8.1.0"
sort_area_size = 65536
sort_area_retained_size = 65536
disk_asynch_io = TRUE
db_files=1024
#lock_sga=true
db_block_lru_latches=12
audit_trail = false
transaction_auditing = false
optimizer_mode = rule
db_file_multiblock_read_count = 16
dbwr_io_slaves=4
parallel_execution_message_size=8192
sort_multiblock_read_count = 8
UTL_FILE_DIR=/oracle/migrate
Received on Fri Feb 02 2007 - 12:44:29 CST