RE: CPU_TIME > ELAPSED_TIME

Just because it's simple doesn't mean it wouldn't run on multiple CPUs. It could be executed concurrently by multiple sessions.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Eagle Fan

But this query is very simple, it's doing index unique scan on PK index. buffer gets per execution is only 3.

I can't image it run on multiple CPU at one time.

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.

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