Re: CPU_TIME > ELAPSED_TIME
- From: "Eagle Fan" <eagle.f@xxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- Date: Wed, 24 Oct 2007 13:56:25 +0800
If it's executed concurrently by multiple sessions, I think elapsed time
will be count multiple times as well.
On 10/24/07, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote:
>
> 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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *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.
>
--
Eagle Fan
Oracle DBA
Other related posts:
