LOL/SQL?

It started with the LOLCATS. Then we had the ORLY thing and the "in ur base" thing. It's all one big conglomeration now, and it has belched forth LOLCODE. I'm told there is a parser/compiler for LOLCODE, but my head hurts just thinking about it.But it does beg the question... [Read More]

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