Oracle Database Discussions

Hi,

I am having oracle database version 11.0.1.6 on windows server 2003 R2.

My Server Ram size is 12 GB.

select * from V$SGAINFO;


Fixed SGA Size 1335136 No
Redo Buffers 12529664 No
Buffer Cache Size 1073741824 Yes
Shared Pool Size 176160768 Yes
Large Pool Size 8388608 Yes
Java Pool Size 16777216 Yes
Streams Pool Size 8388608 Yes
Shared IO Pool Size 0 Yes
Granule Size 8388608 No
Maximum SGA Size 1297321984 No
Startup overhead in Shared Pool 58720256 No
Free SGA Memory Available 0

I want to increase my memory for oracle because i need to insert 31 billion rows into a table with nologging. I am inserting them chunk by chunk and commit after each chunk. But it is taking 62 hours to insert the rows. So i think if i increase the memory i could reduce the time to insert the rows.

I really am not sure whether i am thinking in the right way. Please advise. If i want to increase the memory please let me know how to increase it.

Thanks in advance