AW: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
- From: Petr Novak <Petr.Novak@xxxxxxxxxxxx>
- To: "exriscer@xxxxxxxxx" <exriscer@xxxxxxxxx>, Oracle Mailinglist <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 Nov 2012 14:35:27 +0000
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@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx]" im
Auftrag von "Ls Cheng [exriscer@xxxxxxxxx]
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » AW: DB CPU is much lower than CPU Time Reported by TOP SQL consumers - Petr Novak
