Oracle Database Discussions

Hello all,

I am using Oracle 10g on Linux box. I am geeting this error where creating a table

SQL> CREATE TABLE tmp_netic_tx nologging parallel 4 AS 
     Select * from netic_txt where code=5;

ORA-12801: error signaled in parallel query server P003
ORA-04030: out of process memory when trying to allocate 6440 bytes (kxs-heap-w,Scan compression ctx)

SQL> show parameter sga_
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sga_max_size                         big integer 7G
sga_target                           big integer 7G
 
SQL> show parameter pga_
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target                 big integer 7G

thanks in advance

rgds
saaz

Edited by: Saaz Ena on Jun 14, 2010 11:14 AM