Bug series: intro. statistics_level ALL, db_cache_advice and crash

This is the first post on daily bugs encountered by me. Got to keep track of them. I believe I’ve ran into this bug years before and now it happened again.

And the bug is:

Databases affected: at least 10.2.0.4, 11.2.0.2

set statistics_level=all ,

then db cache advisor is turned on behind the scenes,

then database crashes (after restart in my case) with core dump ORA-7445 [kcbsacc].

Oracle bug and metalink article is:
“Bug 9903826 – ORA-7445 [kcbsacc] and PMON crashing with ORA-7445 [kcbsslc] Causing Instance to Terminate [ID 9903826.8]”

Solution is:
set db_cache_advice = off

Principles violated (by me as DBA of course):

– keep it simple principle. If features can be turned off – turn them off. Start db in “safe mode” (windows talk)

– memory fails, read the (bleeped) manual principle: Oracle has got “aggregated parameters”: turn one ON and then you need to turn a few of them OFF to keep the system clean.

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

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