Skip to content
July 30, 2012 / doganay

ORA-07445: exception encountered: core dump [opiptp()+60] [SIGSEGV]

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


Problem:

The following error logged at the alert log file:

ORA-07445: Exception encountered: CORE Dump [opiptp()+60] [SIGSEGV] [Address not mapped to object] [...


Solution:

There are 3 possible workarounds:

1. Set the parameter “_optimizer_connect_by_cost_based” to false , at the database level :

SQL> alter system set "_optimizer_connect_by_cost_based" = false scope=both ;

or

2. Set the parameter “_optimizer_connect_by_cost_based” to false , at the session level :

SQL> alter session set "_optimizer_connect_by_cost_based" = false;

or

3. Add /*+ NO_CONNECT_BY_COST_BASED */ hint to the query, instead of setting the parameter

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: