Home » RDBMS Server » Server Administration » ora-12801 ORA-04030 -ORA-06512
ora-12801 ORA-04030 -ORA-06512 [message #53582] Mon, 30 September 2002 08:58 Go to next message
Teresa
Messages: 36
Registered: May 2002
Member
Hi there
We are running a job and once in a while I keep getting the following error messages

SQL*Plus: Release 8.1.7.0.0 - Production on Sat Sep 28 08:52:36 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production

SQL>
Session altered.

SQL> 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 begin
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P011
ORA-04030: out of process memory when trying to allocate 1048632 bytes (cursor
work he,kllcqgf:kllsltba)
ORA-06512: at line 20

I don't get because sometimes its fine
any help would be great
Thanks
Teresa
Re: ora-12801 ORA-04030 -ORA-06512 [message #53583 is a reply to message #53582] Mon, 30 September 2002 10:17 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
try increasing ur virtual memory
and sort_area_size.
Previous Topic: unable to open oracle database
Next Topic: Running a Host Command..
Goto Forum:
  


Current Time: Fri Sep 20 03:41:58 CDT 2024