Recursive CPU larger than total CPU used by the database

From: Ls Cheng <exriscer_at_gmail.com>
Date: Wed, 20 May 2015 19:31:03 +0200
Message-ID: <CAJ2-Qb92CGxyzWnf57yDHoUhbobmacqgDZN1N+Q0WTGsO9Qugg_at_mail.gmail.com>

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

Received on Wed May 20 2015 - 19:31:03 CEST

This message: [ Message body ]
Next message: Randolf Geist: "Re: Temp Space performance"
Previous message: Kevin Hale Boyes: "JDBC Thin Driver and Tomcat"
Next in thread: Jonathan Lewis: "RE: Recursive CPU larger than total CPU used by the database"
Reply: Jonathan Lewis: "RE: Recursive CPU larger than total CPU used by the database"
Reply: Jonathan Lewis: "RE: Recursive CPU larger than total CPU used by the database"
Maybe reply: Tim Gorman: "Re: Recursive CPU larger than total CPU used by the database"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message