The Oracle session count is going to match the thread count configured across all the queues. If you want to research what queues are running into blocks (not enough threads), look at the per thread server statistics. If you want to know whether your servers are able to effectively use as many threads as you have configured, look at the kernel statistics for your arserverd process. On Solaris you can look into mpstat and sar.
Axton Grams On Tue, Jan 19, 2010 at 4:25 PM, Haque, Rezaul R < rezaul.ha...@chartercom.com> wrote: > ** > > Guys, > > I am in a dilemma to decide to set how many oracle session according to > Remedy Thread count that we have in our system. > > right now we have Fast = 15, List = 30 and some Private = 10, Private = > 10, Private = 2 and Private = 1 and Of course Admin = 1, Alert =1 > > DBA saying we are maxed out 300 ( currently set in database). How can I > judge what would be ideal oracle session count according to my thread count. > > Please advice > > > > Thanks > > Rezaul > > > > E-MAIL CONFIDENTIALITY NOTICE: > > > > > > > > The contents of this e-mail message and > any attachments are intended solely for the > addressee(s) and may contain confidential > and/or legally privileged information. If you > are not the intended recipient of this message > or if this message has been addressed to you > in error, please immediately alert the sender > by reply e-mail and then delete this message > and any attachments. If you are not the > intended recipient, you are notified that > any use, dissemination, distribution, copying, > or storage of this message or any attachment > is strictly prohibited. > > > > > > > > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"