CSALTER requires a clean CSSCAN

Following up to my last post, it turns out that CSALTER requires you to have clean data and produce a clean CSSCAN within 7 days prior to running the character set migration script.If the CSSCAN isn't clean, you'll get this:Checking data validility... Exceptional data found in scanner result PL/SQL procedure... [Read More]

Changing Oracle Database Character Sets

Our big application database has a character set of USASCII7, something left over from before my time here (approaching 6 years now). We've recently seen "errors" in some of the applications caused by characters being loaded into the database that are outside of the USASCII7 domain, namely "ú" and "ñ".... [Read More]

An end to my Oracle listener hanging

Over the weekend I have become obsessed with two things: the Allman Brothers Band and Jeremy Schneider's diagnosis of the listener/ONS bug found in Oracle The former due to "Jessica" being in the playlist for Guitar Hero II, the latter because not only did it provide me a rhyme... [Read More]

Tuning the PGA: The Follow-Up

I know that all 3 of you have been shivering with anticiPATION at how my PGA tuning experiment went. Today is your lucky day.I did indeed raise the value of pga_aggregate_target to 512MB. The cache hit ratio rose to near 80%, but the estimated over-allocations was quickly into the tens... [Read More]
Tags: tuning pga oracle

ASM, we hardly knew ye

Not only did I recently wave goodbye to ASMM, I've also parted ways with ASM and have gone back to traditional filesystem-based storage.The reason is basically that it simply was not playing nice with our Hitachi disk. The SA worked with Hitachi to try and get things working but in... [Read More]
Tags: asm oracle