AW: DB CPU is much lower than CPU Time Reported by TOP SQL consumers

From: Petr Novak <Petr.Novak_at_trivadis.com>
Date: Tue, 13 Nov 2012 14:35:27 +0000
Message-ID: <09011014EB621E4CBC2536B62A1B64075AD1CA58_at_smxc002.trivadis.com>

Hallo Cheng ,

for example, if you insert row in a table and trigger makes some work , you will see the ressource consumption twice in statspack - the 'master' insert and the statements from trigger. Or if you run a job , you will see the job consumption and consumption of the statements from this job. I would check the statements text and look for dependencies, if some sql is executed behind of some other.

Best Regards,
Petr

---

Von: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org]&quot; im Auftrag von &quot;Ls Cheng [exriscer_at_gmail.com] Gesendet: Dienstag, 13. November 2012 14:20 An: Oracle Mailinglist
Betreff: Re: DB CPU is much lower than CPU Time Reported by TOP SQL consumers

Hi
I have 16 CPU so figure, 57600 seconds per hour CPU power.

But I am not looking weather I am CPU or IO bounded. I wonder why sql cpu time is much larger than db cpu reported

TIA
--

LSC
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 13 2012 - 15:35:27 CET