Re: SOS!!!....Process running out of memory.
- From: "biti_rainy" <biti_rainy@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, "vinodg" <vinodg@xxxxxxxxxxx>
- Date: Sun, 3 Oct 2004 22:21:11 +0800
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@xxxxxxxxxxx
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
>--
>//www.freelists.org/webpage/oracle-l
>
>.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
