Oracle Error: ORA-04030

[Former Member]

Hello everyone. We are having production problem and need to fix. If anyone has run into this problem can you please post ASAP we need to resolve...... our shipping is being held up. When we run this specific program we keep on getting:

The exception must either be prevented, caught within the procedure

"DATA_SELECT"

"(FORM)", or declared in the procedure's RAISING clause.

To prevent the exception, note the following:

Database error text........: "ORA-04030: out of process memory when tryin to

allocate 64512 bytes (sort subheap,sort key)"

Internal call code.........: "[RSQL/FTCH/VLPMA ]"

Please check the entries in the system log (Transaction SM21).

You may able to find an interim solution to the problem

in the SAP note system. If you have access to the note system yourself,

use the following search criteria:

-

---

"DBIF_RSQL_SQL_ERROR" CX_SY_OPEN_SQL_DBC

"SDRQCR21" or "SDRQCR21"

"DATA_SELECT"

-

---

Thank you so much for your help.

Billy

[former_member185954 · Accepted solution]

Hello,

this looks like a memory issue, what is your OS ?

Have a look at the central note : Note 502782 - Composite SAP Note ora-4030

Regards,

Siddhesh

[Former Member · Accepted solution]

Thanks for your reply........... I will check the note...........

Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.8.0 - Production

System: Microsoft Windows Server 2003 Enterprise Edition

-

---

[Former Member · Accepted solution]

Excellent Siddhesh we did:

Restart work processes regularly (Note 101717)

You can release the memory allocated by the Oracle shadow processes by regularly restarting SAP work processes. This is of limited use if you use the automatic PGA administration, since the automatic PGA administration releases memory that is no longer required anyway.

and everything is working now..............

Thank you soooooooooooooooooooooo much........

Billy