Re: v$session_logops

From: <srivenu_at_hotmail.com>
Date: Thu, 11 Sep 2008 01:10:14 -0700 (PDT)
Message-ID: <ea086111-84c7-44fe-85e2-b75294f22465@r66g2000hsg.googlegroups.com>


Hi,

First of all you need to analyze why you are having so many apache processes ?
whats your application ?
Do you use connection pooling ?

For database side monitoring, you shouldnt be querying v $session_logops for your scenario.
All sessions do not show up there.
There are certain criteria before a session is populated in that view. And even when querying v$session_logops use a filter like where totalwork<>sofar or as michel suggested where time_remaining > 0 In your case, Query v$session or v$session_wait and see the session waits.

regards
srivenu Received on Thu Sep 11 2008 - 03:10:14 CDT

Original text of this message