Re: v$session_logops

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