Re: SOS!!!....Process running out of memory.

hi,Vinod Gopinath BMMI IS

  your sga is too large, you must reduce the sga for example : shared_pool_size = 300m ,increase the buffer cache ,total sga = 1.2G

Best regards

msn: biti_rainy_at_hotmail.com
a dba from alibaba(china)

• from the mail----- Hello, I have oracle 8.1.6 on WinNT Patch 4 with 4 CPU's and 4 Gig ram. I feel I have tuned the db correctly. I am getting the error

ERROR:
ORA-04030: out of process memory when trying to allocate 4000012 bytes (session
shared_pool_size = 1048556000
shared_pool_reserved_size = 104855600
# Earlier this was 8.1.5
compatible = 8.1.6
optimizer_index_caching = 20
optimizer_index_cost_adj = 90

Can some one help me. Its urgent.
- Vin
>--
>http://www.freelists.org/webpage/oracle-l
>
>.

--
http://www.freelists.org/webpage/oracle-l