ORA-07445 [STRLEN()+24] Running Command 'Show Parameter' (Doc ID 1078807.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 10-Jan-2012***

Symptoms

After entering 'show parameter...' in sqlplus, received an ORA-3113 error

The alert log also reports this error at the same time:
ORA-07445: exception encountered: core dump [strlen()+24] [SIGSEGV] [Address not mapped to object] [0x00038001D] [] []

Trace file indicates the failing sql is:
SELECT NAME NAME_COL_PLUS_SHOW_PARAM, DECODE(TYPE,1,'boolean',2,'string',3,'integer',4,'file',5,'number', 6,'big integer', 'unknown') TYPE,DISPLAY_VALUE VALUE_COL_PLUS_SHOW_PARAM
FROM V$PARAMETER
WHERE UPPER(NAME) LIKE UPPER('%sga%')
ORDER BY NAME_COL_PLUS_SHOW_PARAM,ROWNUM

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