Path: news.f.de.plusline.net!news-fra1.dfn.de!news.tele.dk!feed118.news.tele.dk!postnews.google.com!q2g2000cwa.googlegroups.com!not-for-mail From: "jshen.cad@gmail.com" Newsgroups: comp.databases.oracle.server Subject: Re: How to increase MAX number of connections for Oracle DB server? Date: 2 Feb 2007 10:44:29 -0800 Organization: http://groups.google.com Lines: 115 Message-ID: <1170441869.051322.79670@q2g2000cwa.googlegroups.com> References: <1170428506.545818.24500@v33g2000cwv.googlegroups.com> <1170428948.496209.81020@h3g2000cwc.googlegroups.com> <1170430046.234622.183380@l53g2000cwa.googlegroups.com> <1170432299.100352.70660@j27g2000cwj.googlegroups.com> <1170441576.950865.235810@k78g2000cwa.googlegroups.com> NNTP-Posting-Host: 60.186.169.94 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1170441874 17557 127.0.0.1 (2 Feb 2007 18:44:34 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 2 Feb 2007 18:44:34 +0000 (UTC) In-Reply-To: <1170441576.950865.235810@k78g2000cwa.googlegroups.com> User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: q2g2000cwa.googlegroups.com; posting-host=60.186.169.94; posting-account=0RFBmA0AAAC5AwU180nzZqkh2PMZ6Mvn Xref: news.f.de.plusline.net comp.databases.oracle.server:193518 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