Posts Categorized: Pythian

Interval Partitioning and Parallel Query Limit Access Paths

Interval partitioning – this ability to create partitions on the fly was introduced in 11g. When the feature came out, there were several nasty bugs. One such particular “limitation” has to do with parallel group by on the partition key. If you want to see just that part, skip towards the end, but I think reading the whole post will offer some insight on how Oracle Parallel Query works.

Building Web Service APIs

A couple of years back, I created WWW::Ohloh::API because it seemed to be a fun thing to do. And trust me, it was. But now, since I’m not using that module personally, I thought it would be a good idea to see if anyone would be willing to co-maintain it. Before I could do that, though, I had to deal with two little problems.

First MySQL/NoSQL/Cloud Latin American Conference

My impressions: Considering that this conference was the first one of its kind in Argentina, I have to say it was great. Small, but great. Not many people knew about the event, but the response was still pretty good. It was a 3-day event with plenty of technical discussions and sessions, and some other sessions came from companies who wanted to share experiences and impressions on what is coming for MySQL technologies.

Oracle Direct NFS: How to Start

First of all, if you are using NFS to store Oracle database data files, I strongly advise you to enable Oracle Direct NFS (DNFS) to access these files. However, if you are not using NFS, DNFS is probably not of interest to you, and you should stop reading here. But, if you want to set it up, let’s go!

How to Upgrade from 11.1.0.7 to 11.2.0.3 on Linux

Recently, I was upgrading a database from 11.1.0.7 to the current 11.2.0.3 version. The database was using ASM, but I should notify at the beginning that the configuration is for a Stand-Alone Server and not RAC. Basically, the first things to be done for this procedure are part of the following checklist…

Help Wanted – A Proposal

What if we added a new field in the META.json — let’s call it x_help_wanted — that would contains all the different types of help a module maintainer could require? Positions like maintainer, co-maintainer, coder, translator, documentation, and tester. We could even have a Dist::Zilla plugin to populate that field for us.

Page 40 of 195« First...102030...3839404142...506070...Last »