Re: v$session_logops

From: <>
Date: Thu, 11 Sep 2008 01:10:14 -0700 (PDT)
Message-ID: <>


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.

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

Original text of this message