Hi vinod, Please try and reduce your shared_pool_size by 100MB and bounce the DB and try. BTW , since when you started getting this problem? Best regards P.V.Narayanan "Vinod Gopinath BMMI IS" <vinodg@xxxxxxxxxxx> Sent by: askdba-bounce@xxxxxxxxxxxxx 29/09/2004 01:14 PM Please respond to askdba@xxxxxxxxxxxxx To <askdba@xxxxxxxxxxxxx> cc Subject [askdba] Re: ORA - 04030 PVN This is a production server. Can't bounce the db. F.Y.I Total System Global Area 1415279884 bytes Fixed Size 70924 bytes Variable Size 1117241344 bytes Database Buffers 245530624 bytes Redo Buffers 52436992 bytes Do I need to change any parameter. If that's the case then I can change and keep it ready. /- Vin -----Original Message----- From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx] On Behalf Of PV Narayanan Sent: Wednesday, September 29, 2004 11:21 AM To: askdba@xxxxxxxxxxxxx Cc: askdba@xxxxxxxxxxxxx; askdba-bounce@xxxxxxxxxxxxx Subject: [askdba] Re: ORA - 04030 Hi vinod, Can you reduce your SGA size and try? Best regards P.V.Narayanan "Vinod Gopinath BMMI IS" <vinodg@xxxxxxxxxxx>=20 Sent by: askdba-bounce@xxxxxxxxxxxxx 29/09/2004 11:57 AM Please respond to askdba@xxxxxxxxxxxxx To <askdba@xxxxxxxxxxxxx> cc Subject [askdba] Re: ORA - 04030 Ganesh, I couldn't make out any thing from the O/p I had send you. If you could explain and tell me what needs to be done. When I go to task manager, the graph showing the memory area does not have any significant growth or there in no movement in that graph at all. FYI this box has 4GB ram. Do you require any oracle parameter to be changed. /- Vin -----Original Message----- From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx] On Behalf Of Ganesh Raja Sent: Wednesday, September 29, 2004 10:45 AM To: askdba@xxxxxxxxxxxxx Subject: [askdba] Re: ORA - 04030 Vinod, It appears that u dont have any memory left for operations ...=3D20 On Wed, 29 Sep 2004 09:15:45 +0300, Vinod Gopinath BMMI IS <vinodg@xxxxxxxxxxx> wrote: > Ganesh, > Here's the o/p >=3D20 > 655360 bytes total conventional memory > 655360 bytes available to MS-DOS > 633952 largest executable program size >=3D20 > 1048576 bytes total contiguous extended memory > 0 bytes available contiguous extended memory > 931840 bytes available XMS memory > MS-DOS resident in High Memory Area >=3D20 > /- Vin > -----Original Message----- > From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx] > On Behalf Of Ganesh Raja > Sent: Tuesday, September 28, 2004 5:06 PM > To: askdba@xxxxxxxxxxxxx > Subject: [askdba] Re: ORA - 04030 >=3D20 > Vinod, >=3D20 > The Issue seems to be a Memory Problem with your OS .. It is not able > to Allocate Server Process Memory ... Can U check with Mem command > what is the free memory ... >=3D20 > Cheers > Ganesh R >=3D20 > On Tue, 28 Sep 2004 16:51:16 +0300, Vinod Gopinath BMMI IS > <vinodg@xxxxxxxxxxx> wrote: > > Ganesh, > > ORA-04030: out of process memory when trying to allocate bytes > > (,):cannot establish connection to "CS3" > > /- Vin > >=3D3D20 > > -----Original Message----- > > From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx] > > On Behalf Of Ganesh Raja > > Sent: Tuesday, September 28, 2004 4:18 PM > > To: askdba@xxxxxxxxxxxxx > > Subject: [askdba] Re: ORA - 04030 > >=3D3D20 > > Can U give us more texts from the error message.=3D3D3D20 > >=3D3D20 > > Cheers > > Ganesh R > >=3D3D20 > > On Tue, 28 Sep 2004 16:13:34 +0300, Vinod Gopinath BMMI IS > > <vinodg@xxxxxxxxxxx> wrote: > > > Hello, > > > Am facing problems (ORA - 04030) on a box having Win NT with Oracle > > > 8.1.6. When I go and view Task Manager, there are hardly any process > > > being used. Can any body help me. > > > /- Vinod > > >=3D3D3D20 > > > > >=3D3D20 > > >=3D20 >