Hi Jonathan
I do have access to ASH but it doesnt report any useful stuff, only a
session was active.
Let me get the summary output and post it later
Thanks
On Thu, May 21, 2015 at 8:48 PM, Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx
wrote:
This looks like a double-(or more)-counting error, viz: one Oracle process
calling another Oracle process and both of them claiming to own the CPU
usage of the second.
If you're licensed to query v$active_session_history you could try
capturing the content over that time period, then analyzing all the rows
where a session reports itself as on CPU - this might give you a starting
clue about what's happening.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
@jloracle
------------------------------
*From:* oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on
behalf of Ls Cheng [exriscer@xxxxxxxxx]
*Sent:* 20 May 2015 18:31
*To:* Oracle Mailinglist
*Subject:* Recursive CPU larger than total CPU used by the database
Hi
I have a 10.2.0.5 single instance database running in HP-UX.
I have noticed that everyday at same time, between 22:00 and 22:30 the
recursive cpu shown in v$sysstat is larger than DB CPU from Time Model or
CPU used by this session from v$sysstat.
The database claims it consumed 886 second CPU but recursive cpu usage
shows 196759 centiseconds (1967 seconds).
This happens consistently everyday at the same time.
Anyone observed this behaviour before?
Thanks
