Re: Newbie DBA Problem: Hitting Temp Hard

From: Martin Rapier <m.rapier_at_sheffield.ac.uk>
Date: 2000/05/17
Message-ID: <01bfc00a$70214de0$f811a78f@ad1mer.shef.ac.uk>#1/1

billmil_at_my-deja.com wrote in article <8fp3co$acv$1_at_nnrp1.deja.com>...
>
> > Compare the number of sorts in memory vs the number on disk.
>
> How do I perform this compairson? Via the v_$sort_usage table?

No, just look in v$sysstat and look for the memory/disk sort statistics. The relevant rows will be something like:

sorts (disk) 512 
sorts (memory) 1374596 
sorts (rows) 48276295

Which is what it was on our system approx 30 seconds ago.

Something like

select name,value
from v$sysstat
where name like 'sorts%';

should do the trick.

Cheers
Martin. Received on Wed May 17 2000 - 00:00:00 CDT