Ora-7445 [Xplpredtotext()] While Query From V$SQL_PLAN (Doc ID 551140.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.6.0
This problem can occur on any platform.

Symptoms


When attempting to select from V$SQL_PLAN, the following error occurs:

ORA-07445: exception encountered: core dump [xplPredToText()+156] [SIGSEGV] [unknown code] [0x4000000005] [] []
Current SQL statement for this session:
SELECT P.hash_value, P.CHILD_NUMBER , to_char(p.id,'990')||decode(access_predicates,null,null,'A')||decode(filter_predicates,null,null,'F') as ID , P.COST, P.CARDINALITY , LPAD(' ',depth)||P.OPERATION||' '||P.OPTIONS||' '||P.OBJECT_NAME|| decode(P.OPTIMIZER,NULL,NULL,' '||P.OPTIMIZER)|| DECODE(P.PARTITION_START,NULL,' ',':')|| TRANSLATE(P.PARTITION_START,'(NRUMBE','(NR')|| DECODE(P.PARTITION_STOP,NULL,' ','-')|| TRANSLATE(P.PARTITION_STOP,'(NRUMBE','(NR') , P.POSITION, s.LAST_STARTS, s.LAST_OUTPUT_ROWS , ROUND(S.LAST_ELAPSED_TIME/1000000,2) , S.LAST_CR_BUFFER_GETS , S.LAST_CU_BUFFER_GETS , S.LAST_DISK_READS , S.LAST_DISK_WRITES FROM V$SQL_PLAN P, V$SQL_PLAN_STATISTICS S where p.hash_value = :p1 and S.ADDRESS(+) = P.ADDRESS and s.hash_value(+) = p.hash_value and s.child_number(+) = p.child_number AND S.OPERATION_ID(+) = P.ID order by P.CHILD_NUMBER, p.id

----- Call Stack Trace -----
sigreturn
xplPredToText
xplGetPredicates
xplMakeRow
xplFetchRow
kqlfgx

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms