My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.