Pythian Group

Welcome to Log Buffer, the weekly roundup of database industry news.

For your reading pleasure this week we have Log Buffer #196:

Charles Hooper blogs about an in-depth investigation on what can cause Oracle to ignore a hint.

Doug Burns reminds his readers that there are only two weeks left to submit papers for UKOUG. The deadline is Aug. 2.
Read the rest of this entry . . .

We’re well into summer and almost at our 200th edition of Log Buffer, a blog of blogs about the database world.

Remember if you find a link or interesting blog post that you think Log Buffer should mention, send a note to the editor at Log Buffer and be sure to include the link, and a short note outlining why you think that particular post would be of value to other DBAs, or what you learned from reading it.

Now on to our weekly reading in Log Buffer #194:
Read the rest of this entry . . .

It’s Friday, and summer’s here. While it seems the industry is slowing down to a lazy pace, there is still some action so let’s splash right in to this week’s edition of Log Buffer DBA industry news in Log Buffer #192.

Alex Gorbachev had a few minutes to suggest the following interesting tidbits to me before running off to attend Oracle ACE Director activities at ODTUG/Kaleidoscope this weekend. One of these days we’ll have to see if he can share some of what goes on behind closed doors at those hush hush sessions.
Read the rest of this entry . . .

[yanick@enkidu shuck]$ perl -MFile::Find::Rule \
    -e'INIT{@ARGV=File::Find::Rule->file->name("*.news")->in("blogs")}'

Remember me mentioning David Wheeler’s CPAN-like project for PostgreSQL? Well, by now it has an official name — PGXN — and the ball has now been set into motion. This is going to be good.

bingos decided to take the Dist::Zilla leap this week. A few plugins have already been churned out as the result.

Danger Will Robinson! If you are using File::chdir, David Golden warns that Perl 5.13.1 broke it by fixing a tied variable-related bug. Things are expected to be back to normal with Perl 5.13.2.

Read the rest of this entry . . .

Welcome to Log Buffer, the weekly roundup of database blogs.

Kicking off this week in Log Buffer #191 are posts from Alisher Yuldashev:

Randolf Geist blogs on an Advanced Oracle Troubleshooting Session – PGA/UGA memory fragmentation for when a batch process takes significantly longer than expected.

James Morle talks about an example of a misleading average in Log File Sync and AWR – Not Good Bedfellows.

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.

Robert Catteral continues to recap session highlights from the International DB2 Users Group Conference last month in Nuggets from DB2 by the Bay, Part 3, following Parts 1 & 2.

Chen Shapira contributed Cloning Oracle Home from RAC to Stand-Alone.

On In Recovery, Paul Randal wrote the whitepaper Proven SQL Server Architectures for High Availability and Disaster Recovery he wrote for the Spring SQL Server release has been published.

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.

[yanick@enkidu shuck]$  perl -MWWW::Robot
my $robot = WWW::Robot->new(
    NAME => 'shuck', VERSION => 0.1, EMAIL => 'blogger@pythian.com' );
$robot->addHook( 'follow-url-test' => sub { 1 } );
$robot->addHook( 'invoke-on-contents' => sub { print $_[5] if rand() > 0.5 } );
$robot->run( 'http://blogs.perl.com' );
^D

First, Inigo Tejedor reminds us that we have until Thursday June 3rd (yes, tomorrow) to fill out the Perl programming survey. If you haven’t done so already, what are you waiting for? Stop reading this blog entry right now and go do your duty. No, seriously, go!

And no peeking back until you’re done!

… so, survey’s filled out? Good. Now we can continue.

Read the rest of this entry . . .

Welcome to Log Buffer, the weekly roundup of database blogs. We’re back this week with a short Log Buffer #190. Only ten more issues, and we’ll be celebrating our 200th edition post.

Chen Shapira was eager to share news early this week, sending along her favorite picks on Tuesday.

Prof. Neil Gunther doesn’t like the way commercial load testing software distributes think times.
Read the rest of this entry . . .

Welcome to Log Buffer, a weekly review of the database industry. This week’s issue Log Buffer #189 is generously published by Iggy Fernandez, editor of the quarterly journal of the Northern California Oracle User Group (NoCOUG).

As always, if you’d like to host your own issue of Log Buffer, simply reach out to the Log Buffer coordinator.

Please enjoy Iggy’s issue of Log Buffer #189.

It’s Friday already, and we know what that means! Log Buffer, the industry’s weekly review of database blogs is here again for your reading pleasure in the 188th issue.

Starting off this week’s issue is a request from Mark Grennan a DBA who would like to let the community know about his blog MySQL Fan Boy, where he wrote an interesting post on including a script to replace MySQL table files on a live system, making it faster and limiting locking on large table loads. Also a post this week on whether MariaDB is a drop in replacement for MySQL.

Read the rest of this entry . . .

Welcome to the 186th Edition of Log Buffer. Lots to report this week, so read on…

In Oracle news:

We begin with Gary Myers at the Sydney Oracle Lab who mixes GUI and CLI and shows how to manage your database from EMACS. You have to read a post that starts with: “There is a place of shadow, a place between the dark lands of the command-line interface, and the shining brightness of the GUI. In the days of yore, many dwelled in the shadow lands, but almost all have been attracted to the lights of SQL Developer…”
Read the rest of this entry . . .