[askdba] Re: ORA - 04030
- From: PV Narayanan <PNarayanan@xxxxxxxxxxxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Wed, 29 Sep 2004 14:29:35 +0400
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
>
Other related posts:
