Re: 100M table created a giga byte temp tablespace!

as statet above.... sort area size. if you have THAT amount of free memory on
your DB server you should generally think about tuning the SGA (read 'server concepts'
and 'server tuning')... dramatical increase of performance to expect :-)

regards,
--marcus

Robert Chung schrieb in Nachricht <36d60012.9980703_at_news.mindspring.com>...
>
>I have a table that takes up a little more than 100 MBytes. One of
>the user executed a SQL statement that processes every single row in
>the table and produces some report. (It sums numbers grouping by
>concatenated primary key with four columns.) Nothing fancy. Nothing
>more. But this SQL statement causes temporary tablespace to grow over
>a giga bytes. While Oracle is processing SQL statement, I observed
>operating system, and it said it had over 400Mbyes of free memory.
>Obviously, Oracle is hitting hard disks big time for temporary
>tablespace, but not using all those free memory. Is there something
>that I should do to fix this? Thanks in advance.
>
>
>
>
Received on Sun Feb 28 1999 - 11:38:28 CST