Home » RDBMS Server » Server Administration » ORA-04030
icon9.gif  ORA-04030 [message #110378] Mon, 07 March 2005 03:05 Go to next message
Bhavindshah34
Messages: 8
Registered: February 2005
Location: Ahmedabad
Junior Member
Hi, freinds

I am continously getting this error .. when my batch running process is
going on..

my sga size is 480M and my pga_aggregate_target=50M and hash_area is
enabled.

I am using Oracle 9.0 on windows 2000 server. Is there any limitation for
oracle on windows 2000 for size of SGA AND pga_aggregate_target...

please let me know as early as possible...

It's too urgent and will be too much helpful for me..

Report message to a moderator

Re: ORA-04030 [message #110385 is a reply to message #110378] Mon, 07 March 2005 03:37 Go to previous message
easywebtech123
Messages: 22
Registered: March 2005
Location: c
Junior Member
Hi,

This is a tipical error in win2k .

just reduce shared pool or buffer cache .
this is win2k limitation.

more details in
http://www.easywebtech.com/oracle/con_err.html

Thanks.

Report message to a moderator

Previous Topic: How to increase the tablespace
Next Topic: How to Setup ???
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 03:57:23 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.