Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Still need help with Parsing/Recursive Calls

Re: Still need help with Parsing/Recursive Calls

From: Bass Chorng <bchorng_at_yahoo.com>
Date: 4 Apr 2002 16:09:45 -0800
Message-ID: <bd9a9a76.0204041609.5f771f5d@posting.google.com>


Note that the difference between your cpu and elapsed time. That means the database spent a lot of time waiting. You should also check v$session_event to determine how oracle spent its wait time on this session. The total time spent in all events waited should be about the same to your total elapsed time minus cpu time.

If you tune this SQL you can only improve within that 139 seconds, however if you tune your database, you can improve within that 1517 seconds - a much better payback. I would be more interested in why it takes that long to wait.

Also the reason it has high recursive time might be because this SQL statement comes from a function, procedure or package. Oracle categorizes these SQLs as recursive calls although they are really regular SQLs. So that might misled you too. I will be *very* surprised if they are indeed recursive calls as the ratio is way too high. The only close possibility is you have LOTS of extents. Received on Thu Apr 04 2002 - 18:09:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US