Home » RDBMS Server » Server Administration » Listener / Service terminates while running the heavy queries
Listener / Service terminates while running the heavy queries [message #110197] Fri, 04 March 2005 00:44 Go to next message
vivek_orafaq
Messages: 2
Registered: March 2005
Junior Member
Hi,
We are using Oracle 9204 on Win 2k server having 1 GB Ram.
Whenever we run heavy queries (accessing too many recds), we get ORA 4030 Out of process memory error and thereafter all other process slows down and couple of times we have noticed that either LISTENER or the ORACLE SERVICE terminates.

Can anyone throw some light on it.

What should i do to overcome this problem.
Though developers are changing the code as much as they can but is there anything that can be done on DB side.

Thanks is advance

Vivek.

Report message to a moderator

Re: Listener / Service terminates while running the heavy queries [message #110291 is a reply to message #110197] Fri, 04 March 2005 22:32 Go to previous messageGo to next message
richwa
Messages: 2
Registered: March 2005
Junior Member
Looks to me like your running out of heap or buffer space.

What is the value of your swap space?
What is the value of PGA_AGGREGATE_TARGET?

There should be something after the error that points to the heap or buffer in which Oracle cannot allocate space.

Report message to a moderator

Re: Listener / Service terminates while running the heavy queries [message #110331 is a reply to message #110291] Sat, 05 March 2005 23:25 Go to previous messageGo to next message
oldboy
Messages: 9
Registered: March 2005
Location: Chongqing CHINA
Junior Member
please post your SPFILE.

Report message to a moderator

Re: Listener / Service terminates while running the heavy queries [message #110332 is a reply to message #110331] Sat, 05 March 2005 23:30 Go to previous message
oldboy
Messages: 9
Registered: March 2005
Location: Chongqing CHINA
Junior Member
ORA-04030 out of process memory when trying to allocate string bytes (string,string)

Cause: Operating system process private memory has been exhausted.

Action: See the database administrator or operating system administrator to increase process memory quota. There may be a bug in the application that causes excessive allocations of process memory space.

Report message to a moderator

Previous Topic: Message Queues
Next Topic: reg sql loader and connection string.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 04:01:15 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.