Hi Bruce,
Not sure whether you got a response on this, so here
is one. First of all, I am hoping that you have some
kind of performance problem on your hand, that you are
trying to solve and that led you to checking out the
wait events in your database. If so, great. If not
our discussion is
Hi Gaja,
I notice that you have advised Bruce to increase
SORT_AREA_SIZE to gain proformance lost due to
frequent allocation of temp segments. I too belived in
the theory that disk sorts are always faster than
memory sorts untill I stumbled on my own problem
which leaves me a little confused.
Hi Bruce
You need to find what blocks are hanging from the particular latch. You could get this information by joining x$bh and v$session_wait tables while the sessions are waiting for this latch.
select distinct ts#, file#, dbarfil,dbablk from x$bh
where hladdr in
(select p1raw from
Hi Johnson,
I think you may be reading just a tad bit too much
into what I wrote regarding the SORT_AREA_SIZE
increase recommendation. The rationale for that was
not based on disk sorts are always faster than memory
sorts or vice versa. It was based on the fact that
data for global temporary
Hi Gaja and thanks also to Riyaj,
If I didn't make it clear before we were having a major performance problem.
A package call that should (ie normally / used to) take less than 1 second
starting taking between 20 - 60 seconds.
I appreciate your comments on logical IO and will look into that