Administrators across the database technologies find themselves at the center stage of that and they are sharing tips and tricks regarding that in their blogs. This Log Buffer Edition touches that and much more in Log Buffer #246.
I returned from AUSOUG conference in Perth (Australia) just last week. This blog is my report from the conference for the days 0 and 1.
Since I was using a version of 11 already, an experimental upgrade was not a problem. With the BE (boot environments) feature, one could boot into any version safely. BE is an awesome feature. Need to install a patch? Install into a boot environment – any problems reboot into the old environment. BEs leverage ZFS snapshots to create a clone of your boot disk, install any patches onto it and allow you to switch flawlessly between the two.
Pythian continues to have a busy quarter with events right up to the end of the 2011 calendar year. If you happened to miss us at a past event, email firstname.lastname@example.org to reconnect or request a copy of the any of the presentations we’ve made through 2011 or earlier.
If you ever used SQL server Database Engine Tuning Advisor then you know you have few options as a source of analysis workload, here they are.
While Oracle does supply a list of RPMs that must be installed on a Linux system, that information does not help you in determining which Oracle files are dependent on the RPMs in question. If the list of RPMs to be updated is small, it may even be that that few, if any of the Oracle files on a server may be affected. Here’s how that can be determined.
If you do any performance tuning , and everyone does, then you’ll come to a point where you want to know if your tables have sufficient indexes to serve the queries fast, here’s how.
The presentation deadline for UKOUG is 8 days away. I have been madly preparing for 2 presentations, one on my best friend (rman) and the other on my co-best friend (the physical standby). Both of these topics have been perennial favourites for me and many of my attendees. I find with both of these items, there is always something more to learn.
Git::CPAN::Patch could already seed a local repository with the latest distribution of a module, or its whole BackPAN history, or its GitPAN mirror. But with version 0.7.0, it can now go straight for the meat and clone the distribution’s officil git repository, provided that it’s specified in its META.json or META.yml. Please allow me to demonstrate:
Getting stuck on technical problems is a norm in the life of any IT professional and DBAs are no exception. With evolving databases and their streaming new features make it more challenging. Blogs often provide the Eureka moment for those problems. So sit back and enjoy this Log Buffer Edition, which is Log Buffer #245.