RE: CPU Per Exec - SQL Ordered By CPU Time
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: "oracledbawannabe@xxxxxxxxx" <oracledbawannabe@xxxxxxxxx>, "harel.safra@xxxxxxxxx" <harel.safra@xxxxxxxxx>, "Oracle-L@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 24 Nov 2010 11:12:08 -0700
I'm not sure on this - I thought that time waiting in the CPU run queue was
included in the v$sql.cpu_time and "CPU used by this session" stats, but
according to slide 20 here, it looks like maybe the time in the CPU run queue
is actually accounted for in the IO wait event instead:
http://www.oracle.com/technetwork/database/features/manageability/db-perf-tuning-ow08-131582.pdf
________________________________
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
Other related posts:
