Date: Thu, 11 Sep 2008 01:10:14 -0700 (PDT)
First of all you need to analyze why you are having so many apache
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.
srivenu Received on Thu Sep 11 2008 - 03:10:14 CDT