Re: Recursive CPU larger than total CPU used by the database

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_at_jlcomp.demon.co.uk
> 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
> _at_jloracle
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on
> behalf of Ls Cheng [exriscer_at_gmail.com]
> *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
>
>
>

--
http://www.freelists.org/webpage/oracle-l