Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to increase MAX number of connections for Oracle DB server?

Re: How to increase MAX number of connections for Oracle DB server?

From: <jshen.cad_at_gmail.com>
Date: 2 Feb 2007 10:44:29 -0800
Message-ID: <1170441869.051322.79670@q2g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US