ORA-07445: exception encountered: core dump
Hi,
My ERP database 10g alert log file is giving error:
Mon Apr 14 07:44:28 2014
Errors in file /oraclebin/oraprod/PROD/db/tech_st/10.2.0/admin/PROD_proddb/udump/prod_ora_11114.trc:
ORA-07445: exception encountered: core dump [ldxsnfcom()+339] [SIGSEGV] [Address not mapped to object] [0x2ABF980AE450] [] []
When i checked the trace file it has a query. I donot know how to resolve this error and why it is coming.
*** 2014-04-14 07:44:28.299
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ldxsnfcom()+339] [SIGSEGV] [Address not mapped to object] [0x2ABF980AE450] [] []
Current SQL statement for this session:
SELECT * FROM ( SELECT PAF.PERSON_ID,PAF.POSITION_ID,PAF.EFFECTIVE_START_DATE,PAF.LAST_UPDATE_DATE ,PPF.EMPLOYEE_NUMBER ,PPF.FULL_NAME ,PPOS.ACTUAL_TERMINATION_DATE, XXHR_GRADE_VALUE.GET_JOB_TITLE(82,PAF.PERSON_ID,PAF.EFFECTIVE_START_DATE-1) OLD_JOB, XXHR_GRADE_VALUE.GET_JOB_TITLE(82,PAF.PERSON_ID,PAF.EFFECTIVE_START_DATE) NEW_JOB, XXHR_GRADE_VALUE.GET_ORG_NAME(82,PAF.PERSON_ID,PAF.EFFECTIVE_START_DATE-1) OLD_BU, XXHR_GRADE_VALUE.GET_ORG_NAME(82,PAF.PERSON_ID,PAF.EFFECTIVE_START_DATE) NEW_BU, REPLACE(XXHR_GRADE_VALUE.GET_POSITION(82,PAF.PERSON_ID,PAF.EFFECTIVE_START_DATE), '|' ,' - ') NEW_POSITION, XXHR_GRADE_VALUE.GET_POSITION_AR(82,PAF.PERSON_ID,PAF.EFFECTIVE_START_DATE) NEW_POSITION_AR FROM PER_ASSIGNMENTS_F PAF,PER_PEOPLE_F PPF,PER_PERIODS_OF_SERVICE PPOS WHERE PAF.PRIMARY_FLAG = 'Y' AND (PAF.PERSON_ID,PAF.EFFECTIVE_START_DATE) IN (SELECT PERSON_ID,MAX(EFFECTIVE_START_DATE) FROM PER_ASSIGNMENTS_F GROUP BY PERSON_ID ) AND PAF.PERSON_ID = PPF.PERSON_ID AND PAF.EFFECTIVE_START_DATE BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE AND PAF.PERSON_ID = PPOS.PERSON_ID AND PPOS.ACTUAL_TERMINATION_DATE IS NULL ) WHERE OLD_JOB IS NOT NULL AND (OLD_JOB <> NEW_JOB OR OLD_BU <> NEW_BU ) AND TRUNC(LAST_UPDATE_DATE) >= TO_DATE('25-feb-2014','dd-mon-rrrr') AND POSITION_ID NOT IN ( SELECT POSITION_ID FROM XX_NEW_EMP_EMAIL_HIST WHERE NVL(STATUS,'N') = 'Y' AND TYPE = 'POS' AND