ORA-07445 [kkqctdrvJPPD()+2776] [SIGSEGV]

ORA-07445: exception encountered: core dump [kkqctdrvJPPD()+2776] [SIGSEGV] [ADDR:0x0] [PC:0x1BC3E18] [Address not mapped to object] []

SELECT operation cannot be performed on custom views in my case, resulting in above error.  Version affected 11.1.0.7. The view was making use of pushed join predicates.

This ora-7445 is due to the explicitly hint push_predicate in the query because of which optimizer not able to calculate cost correctly.

Possible Workaround

Set any of the following parameters at session level:

“_push_join_union_view” = false

or,

“_optimizer_push_pred_cost_based” = false

or,

“_optimizer_cost_based_transformation” = off

I tried the second one as that helped me.

Please also see Bug 7497640

Advertisements

About mpoojari
Oracle Database/Applications Administrator

Leave a Reply

Please log in using one of these methods to post your comment:

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: