Recursive CPU larger than total CPU used by the database

  • From: Ls Cheng <exriscer@xxxxxxxxx>
  • To: Oracle Mailinglist <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 20 May 2015 19:31:03 +0200

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2015