tag:blogger.com,1999:blog-12459003.post6882705545759245536..comments2023-08-03T09:19:28.438-04:00Comments on So What Co-operative: 10.2.0.4 Post MortemJeff Hunterhttp://www.blogger.com/profile/15701602600662849251noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-12459003.post-77170275689010146432008-08-19T15:35:00.000-04:002008-08-19T15:35:00.000-04:00I read the article on the 10.2.0.4 NUMA and db_blo...I read the article on the 10.2.0.4 NUMA and db_block_checking saga and i have a similar but peculiar problem. Maybe I can offer some twist as well. I have similar issues. My issue though has to do with pre page sga- true. I can in fact boot any size SGA so far as I get the huge pages proportionately higher than sga. The ratio is a mystery to me at this moment but hoevers around 65% of the SGA. Unknownhttps://www.blogger.com/profile/14759897069411957186noreply@blogger.comtag:blogger.com,1999:blog-12459003.post-10612155020628358652008-08-11T22:37:00.000-04:002008-08-11T22:37:00.000-04:00What caused those block cache corruptions in the f...<I>What caused those block cache corruptions in the first place?</I><BR/><BR/>Ah yes, the initial block corruptions. Way back when we first moved to X86_64 we were on 9.2.0.X. We would intermittently get ORA-00600 or ORA-07445 error messages that Oracle Support tracked down to corruptions in the db block cache. When the dbwr wrote the block out to disk, dbwr recognized the block as corrupt, Jeff Hunterhttps://www.blogger.com/profile/15701602600662849251noreply@blogger.comtag:blogger.com,1999:blog-12459003.post-84626549433568029652008-08-09T11:44:00.000-04:002008-08-09T11:44:00.000-04:00Oops, sorry I'm a bit late on this one.What caused...Oops, sorry I'm a bit late on this one.<BR/><BR/>What caused those block cache corruptions in the first place? <BR/><BR/>Earlier bug or problem with memory/hardware?Noonshttps://www.blogger.com/profile/07694829378563989648noreply@blogger.comtag:blogger.com,1999:blog-12459003.post-43274834625462143752008-07-30T09:09:00.000-04:002008-07-30T09:09:00.000-04:00Have you tried the _dont_throw_skgmfixup_scaffoldi...Have you tried the _dont_throw_skgmfixup_scaffolding_error=true parameter? ; )<BR/><BR/>Just out of curiosity have you tried creating a similar database using 11g? I would assume that you will have the same issues, but it never hurts to try.<BR/><BR/>Gandolf989Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12459003.post-67641216638218992232008-07-29T23:13:00.000-04:002008-07-29T23:13:00.000-04:00Oh, I had it explicitly set on. We had multiple d...Oh, I had it explicitly set on. We had multiple db block cache corruptions in the past and this has become a standard parameter.Jeff Hunterhttps://www.blogger.com/profile/15701602600662849251noreply@blogger.comtag:blogger.com,1999:blog-12459003.post-81170309800357158062008-07-29T22:24:00.000-04:002008-07-29T22:24:00.000-04:00The interesting thing is that this parameter's com...The interesting thing is that this parameter's comment in x$ksppi is:<BR/>"protect database blocks (true only when debugging)".<BR/><BR/>Which seems to clearly indicate it's not for general consumption. <BR/>Why did 10.2.0.4 have it on in the first place is worrying...Noonshttps://www.blogger.com/profile/07694829378563989648noreply@blogger.com