Hi,

I would say that 10Gb seems a bit small, but that totaly depends of the design of your warehouse/marts, the queries executed against the db and the available hash/sort or PGA memory. So I dont think that its possible, with the given information to say if yes or no 10Gb are to small.

If you are using 9i and have set WORKAREA_SIZE_POLICY to AUTO you may have a look at the following document:

Automatic PGA Memory Managment in 9i
http://metalink.oracle.com/metalink/...&p_id=223730.1

When executing queries you could also have a look at V$SQL_WORKAREA_ACTIVE using the following query (for more details see the Metalink note):

Code:
SELECT to_number(decode(SID, 65535, NULL, SID)) sid,
operation_type OPERATION,trunc(EXPECTED_SIZE/1024) ESIZE,
trunc(ACTUAL_MEM_USED/1024) MEM, 
trunc(MAX_MEM_USED/1024) "MAX MEM",        
NUMBER_PASSES PASS, trunc(TEMPSEG_SIZE/1024) TSIZE 
FROM V$SQL_WORKAREA_ACTIVE ORDER BY 1,2;
HTH
Mike