Re: SQL Group By - Tooooo Slow

From: Robert Miller <rwmiller_at_gte.net>
Date: 1997/05/15
Message-ID: <5lf4vp$pkl$1@news5.gte.net>#1/1

Check out the sort operation...

Check SORT_AREA_SIZE in the initXXXX.ora. Also check Temp space being used by user. Insure temp space is installed as temporary tablespace in create tablespace command.

-- 


Robt



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^~~~~....

Robert Miller         
Oracle DBA  

robt.miller_at_airmail.net
(214) 532.6558



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^~~~~....

Any opinions expressed are my own and do not necessarily
represent any employer.

Received on Thu May 15 1997 - 00:00:00 CDT