How much space is needed for Oracle sorting?
From: SCOVERBY_at_DELPHI.COM <(SCOVERBY_at_DELPHI.COM)>
Date: 1995/05/04
Message-ID: <3ob785$obl_at_news2.delphi.com>#1/1
Sheyboygan, WI Received on Thu May 04 1995 - 00:00:00 CEST
Date: 1995/05/04
Message-ID: <3ob785$obl_at_news2.delphi.com>#1/1
We are experiencing running out of tablespace when we are performing
'order by's' in select's.
I calculated my tablesize by multiplying average_rowlenth *
number_of_rows
gathered from an analyze table. I deduced the sort size by running the
'order by' query and monitoring the sys.dba_free_space view.
Any 'real life' experiences with tablespace needed for sorts?
Scott Overby scoverby_at_delphi.comSDS
Sheyboygan, WI Received on Thu May 04 1995 - 00:00:00 CEST