RE: Monitoring process usage

From: Kellyn Pedersen <kjped1313_at_yahoo.com>
Date: Tue, 2 Feb 2010 12:19:48 -0800 (PST)
Message-ID: <243115.83774.qm_at_web32003.mail.mud.yahoo.com>

I'm also on this train-  what about a new code release/application that is not closing cursors in a way that Oracle needs them closed,  (I always try to word this in a way that won't offend too many developers of .net and such...:)) 

Kellyn Pedersen
Multi-Platform DBA
I-Behavior Inc.
http://www.linkedin.com/in/kellynpedersen www.dbakevlar.blogspot.com
 
"Go away before I replace you with a very small and efficient shell script..."

• On Tue, 2/2/10, Michael McMullen <ganstadba_at_hotmail.com> wrote:

From: Michael McMullen <ganstadba_at_hotmail.com> Subject: RE: Monitoring process usage
To: "'oracle-l L'" <oracle-l_at_freelists.org> Date: Tuesday, February 2, 2010, 11:35 AM

Are we assuming that the app is properly tuned? I'm always hesitant to up the process value. Sometimes an index on a slow query is all that is needed. I find that # of processes blowing up is usually a sign of a bigger problem.

Mike

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 02 2010 - 14:19:48 CST