Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: high tkprof parse counts == real # of hard parses?
[Bjørn Engsig]
> Admittedly, I am no JDCB expert, but I wouldn't expect to see the
> behaviour you see, in particular that each insert seems to produce a
> soft parse. Do you have a non-cached sequence? If you do, that's
> your reason - recursive SYS SQL is (almost) never cached, so your
> update to seq$ will be soft parsed for each use of a non-cached
> sequence number.
Yes, the sequence has a cache of 1000 values right now (the table gets a good number of rows added :) The behavior that I'm seeing across my stored procedures is that even my non-SYS recursive sql isn't being cached (the soft parses are still happening). Admittedly, there's very little looping going on (like the previous procedure that just does the insert-returning/commit), but the soft parse on each exec is still bad.
> I would suggest you run your session with event 10046 traceing turned
> on.
I did, level 12 - that's why the itrprof output has information on wait events. I didn't include the bind information in the itrprof because it 1) didn't appear to be relevant 2) kept the size of the itrprof much more reasonable. If there are different itrprof options that would be more helpful, I still have the raw trace around and would be happy to re-run it.
Thanks!
-- James Manning <jmm_at_sublogic.com> GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: oracle_at_sublogic.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Feb 12 2002 - 07:44:19 CST
![]() |
![]() |