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]
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]
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]
Oracle SQL Developer 1.1.3 is out
Kris Rice announced the release of Oracle SQL Developer 1.1.3, with "about 200 bug fixes in this build."Full list of bug fixes is here.