Re: flush shared_pool and query performance

From: Á¶µ¿¿í <ukja.dion_at_gmail.com>
Date: Fri, 4 Apr 2008 09:01:01 +0900
Message-ID: <43c2e3d60804031701k5a20cc4cm4f79ec8a589d67a9@mail.gmail.com>


(Repost because of network failure)

Don't be confused. Just trace the sql.
On the first hard parse after flushg shared pool, lots of recursive SQLs are executed either.
In your case, the overhead of parsing the recursive queries seems to have high cost.
On the third hard parse(4567), the recursive SQLs are already parsed so no overhead.

Yes, aboves are just guesswork. You know BAAG, don't you? Just show us your sql trace and tkprof report.

Dion Cho

PS) I can post a long query that consumes more that 10sec to be parsed. :)

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 03 2008 - 19:01:01 CDT

Original text of this message