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]

Wherefore art thou, Development DBA?

Highlander Doug Burns wrote a great piece last month entitled "What use is a Development DBA?" that really hits home for me. I have a lot of minor and not-so-minor conflicts with the developers on my team (read about "the compound keys" for some perspective).As Doug says, a lot of... [Read More]