Home » RDBMS Server » Performance Tuning » ORA-0430 Error for SQL
ORA-0430 Error for SQL [message #65662] Wed, 24 November 2004 23:58
Milind Deshpande
Messages: 93
Registered: May 2004
Member
Hi All,

I have this problem in the SQL. Whenever i run it I get ORA-0430 error.the query is like this :-

Select
TAFM.MEMBERSHIP_ID,
TAFM. LAST_MODIFIED_DATE,
TOA.MODIFIED_Z
from
CUS.TACCOUNT@DT.LINK TACCT,
CUS.TORG_AFFILIATION@DT.LINK TOA,
TAFFL_MEMBERSHIP TAFM
where
TO_DATE(TO_CHAR(TAFM. LAST_MODIFIED_DATE,'DD/MM/YYYY'
),'DD/MM/YYYY') <>
TO_DATE(TO_CHAR(NVL(TOA. MODIFIED_Z, TAFM.CREATED_DATE),'DD/MM/YYYY'
),'DD/MM/YYYY') AND
TACCT.ORG_ID_C = TOA.ORG_ID_C AND
TACCT.ORG_NME_SEQ_C = TOA.ORG_NME_SEQ_C AND
TACCT.ACCT_ID_C = TAFM.ENTITY_ID and
TOA.AFFLN_ID_C = TAFM.AFFL_ID AND
AFFLN_SUB_ID_C IS NULL

The Erroe that i get when i execute this query :-

'ORA-04030: out of process memory when trying to allocate 72 bytes
(callheap,qerrmbv[[]]: qerrmObnd)'

Can anybody help me on this that why this error is coming because if this is a memory error than I cant increase the memory that is the problem. SO,can in any way this query can be tuned so that it absorbs less bytes(Memory).

This is the explain plan of the query:-

SELECT STATEMENT, GOAL = FIRST_ROWS   398 1 130  
 NESTED LOOPS   398 1 130  
  NESTED LOOPS   397 1 91  
   TABLE ACCESS FULL ARROW TAFFL_MEMBERSHIP 395 544166 19045810  
   REMOTE   2 1 56  
  REMOTE   2 1 39  

Pls. help me on this it is urgent.

Thanks in advance

Milind.

 

 
Previous Topic: interpreting SQL raw trace data
Next Topic: Tuning help:-URGENT
Goto Forum:
  


Current Time: Thu Mar 28 16:31:25 CDT 2024