max_servers num_sql_socks

Could anybody sched a light onto max_servers and num_sql_socks selection criteria ? (Oracle 9.2.0.4 is used). How many of them should one set up in order to optimize processor/memory usage? I had max_servers=32 and num_sql_socks=18 till today. A lot of There are no DB handles to use! messages

Re: max_servers num_sql_socks

Alexander Serkin [EMAIL PROTECTED] wrote: Could anybody sched a light onto max_servers and num_sql_socks selection criteria ? (Oracle 9.2.0.4 is used). How many of them should one set up in order to optimize processor/memory usage? The defaults should be good for most systems. Now they

Re: max_servers num_sql_socks

Alan DeKok wrote: ... A 386 should be able to handle that. Find out why your DB is so slow, and fix it. The problem comes up after about 15 records are created in the acct table. The table is indexed. I've attached accounting schemasql.conf. May be some DBAs are here in the list? Any