Re: QueuePool and ORA-12519
From: joel garry <joel-garry_at_home.com>
Date: Tue, 17 Aug 2010 08:56:31 -0700 (PDT)
Message-ID: <8f3cf135-9490-470e-b5b7-7087efada78e_at_x24g2000pro.googlegroups.com>
On Aug 16, 7:20 am, sajuptpm <sajup..._at_gmail.com> wrote:
> how can i find optimal Queue pool size?
Date: Tue, 17 Aug 2010 08:56:31 -0700 (PDT)
Message-ID: <8f3cf135-9490-470e-b5b7-7087efada78e_at_x24g2000pro.googlegroups.com>
On Aug 16, 7:20 am, sajuptpm <sajup..._at_gmail.com> wrote:
> how can i find optimal Queue pool size?
MOS Note: 557416.1 tells how to diagnose these issues, and suggests looking at what is now called shared server. For the systems I've been on, shared server has been inappropriate, but from the little you've given us it and perhaps cman might be appropriate for you. Or perhaps your application just isn't very nice, overwhelming the db with unnecessary connection requests.
It might help us help you if you specified such information as your exact operating system and oracle version and patch level, and maybe even relevant information about the app.
jg
-- _at_home.com is bogus. http://www.signonsandiego.com/news/2010/aug/12/how-did-san-diego-teen-earn-38000-through-his-own-/Received on Tue Aug 17 2010 - 10:56:31 CDT