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 10.2.0.2. 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

ASMM, we hardly knew ye.

Yesterday I finally busted a cap in ASMM's proverbial ass, setting sga_target back to 0 and manually configuring the various SGA member pool sizes. After my first problems with ASMM, I began reading more and more about "immaturities" with ASMM which I hadn't come across before, particularly with rapid-fire SGA... [Read More]