Welcome to Log Buffer, the weekly roundup of database blogs.
Randolf Geist blogs on an Advanced Oracle Troubleshooting Session – PGA/UGA memory fragmentation for when a batch process takes significantly longer than expected.
And a few faves from Bradd Piontek:
Marco Gralike, on Blog.Gralike.Com, revisits Enabling and Disabling Database Options, a small item that is easily overlooked. Marco also notes a cool tool: VirtualBox Appliance which makes a great start-up test environment. Word of caution however, it’s for testing purposes only.
On Askdba.org, Amit advises on downloading Oracle software directly to server in a post based on Pythian’s downloading from OTN directly to your database server. Watch for future posts from Brad on how he does it via Firefox, and edelivery.oracle.com.
Alex Gorbachev is spreading the word about The Ultimate SQL Tune-off with Jonathan Lewis and Kyle Hailey, two of his most respected Oracle performance experts, believing the session should be interesting to all DBAs, not just Oracle.
Moving to MySQL world, Vadim Tkachenko continues storage benchmarking of MySQL FlashCache (very much like Oracle FlashCache but for MySQL InnoDB engine). This time he is using FusionIO cards for FlashCache.
And, to round things off, Ronald Bradford writes about When SET GLOBAL affects SESSION scope.
Have a great weekend everyone.
Interested in working with Vanessa? Schedule a tech call.