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 Thu Feb 25 1999 - 20:22:21 CST
