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>
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