Posts Categorized: Pythian

Log Buffer #265, A Carnival of the Vanities for DBAs

The weather is changing, clocks are being adjusted, and the changes at the technological front are as usual rapid, frequent, and over-whelming. Keeping up with such rapid-fire changes is a project in itself. In the database triangle of Oracle, SQL Server, and MySQL, patches, updates, features, tricks, and tips are booming, and so is this Log Buffer Edition.

COLLABORATE 12 Looms on the Horizon

Many readers of these BLOG posts are seasoned attendees/presenters at this IOUG/OAUG/Quest collaborative event held every spring. User group events are one of the best stomping ground for hungry IT specialists, thirsting for news on late-breaking solutions and more traditional technologies.

Oracle VM: What If You Have Only 1 HDD System?

In my previous post, I described how to install Oracle VM and Oracle VM Manager on the same sandbox. However, to start playing with Oracle VM v3 you need to configure some storage to be used for new VM hosts. The problem is that Oracle states that you should allocate a full HDD for VM host storage. If you have just one HDD in your system, then you are in trouble since part of it is already occupied by the Dom0 host.

Mutating the Zilla

By now, I have a few Dist::Zilla plugins interacting with the distribution’s changelog. Each time I get the changelog, I parse it into a CPAN::Changes object, do something to it, and save it again. It’s actually not even as hard as it sounds. Have a look.

Disabling Oracle triggers on a per-session basis

The method of disabling triggers requires Oracle or, plus execute permissions on sys.dbms_xstream_gg. Since it’s a call to an XStream package, it may also require a XStream license. So if I haven’t scared you away yet, here’s a quick testcase:

Oracle Database Appliance — Storage expansion with NFS (dNFS, HCC)

The biggest objection to Oracle Database Appliance (ODA) we hear from customers is about 4TB usable space limit (tripple mirrored 12TB of raw storage). I think most of the times this is more a perceived barrier rather than objective — more along the lines of being afraid to hit the limit if the system grows a lot. Nevertheless, Oracle has been always listening customers’ concerns when it comes to purchasing barriers. Of course, this time is no exception.

Page 60 of 207« First...102030...5859606162...708090...Last »