Re: flush shared_pool and query performance
Date: Fri, 4 Apr 2008 09:01:01 +0900
(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.
PS) I can post a long query that consumes more that 10sec to be parsed. :)Received on Thu Apr 03 2008 - 19:01:01 CDT