Before messing with your thread count or database settings, I would verify that the connections are actually coming from arserverd. Database connections can come from plenty of other places: users connecting directly to the database, ETL tools, database links, etc.
I have even seen cases where arserverd connections end up orphaned and stay open on the database side. In some cases it actually took a db restart to clear them up. Juan Ingles On Tue, Jan 19, 2010 at 3:27 PM, Axton <[email protected]> wrote: > ** 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 < > [email protected]> 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: [email protected] ARSlist: "Where the Answers >> Are"_ > > > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
