Tag: Group Blog Posts

SLOB on Steroids – Part 1

SLOB on steroids v0.1: Use it at your own risk. First of all, let me state that I’m falling in love with SLOB :).

Read More >

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.

Read More >

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.

Read More >

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!

Read More >

SQLcode = 1008 When Executing RMAN Commands in 11.2.0.2

A while ago, I was paged by a client having backup job failure. Doing my routine as usual, I started the investigation by looking at the job execution log. Connected to the box was a strange output. Here it is!

Read More >

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…

Read More >

My First Experience with Cassandra – Part 1

The traditional NoCOUG SQL challenge has been launched this year with a twist: In the wake of the “BigData” trend/buzz, it’s now been upgraded to a “SQL and/vs. NoSQL” challenge. I took on the challenge, treading through my SQL comfort zone and thinking of ways I could bend relational algebra to solve the wicked puzzle suggested this year.

Read More >

War Story: Applying Bundle Patch 1 to EM 12 Cloud Control

We have a few clients already using Enterprise Manager 12c Cloud Control. The interface and navigation have improved a lot from the 11g version in my opinion. However, as with any new release of anything, quite a few bugs still need to be fixed. After working with Oracle on some of these bugs last week, we were asked to apply the Bundle Patch 1 (BP1) to one of our clients’ installation. The first thing that I noticed when I started looking for information about BP1 was the amount of warnings from different people I found in MOS and around the internet.

Read More >

Locks, Latches, Mutexes, and CPU Usage

So how is the actual “waiting on lock” implemented? How does session B, waiting for a transaction to commit started by session A, knows that the resource is free for use? To find out how it is implemented, I have traced Oracle foreground processes. I tried this on Oracle RDBMS 11.2.0.3 running on Linux. This is a excerpt of system calls being executed during a session waiting for a lock…

Read More >

Introducing a LinkedIn Group for SLOB Users

This is just a very short blog entry to inform folks that there is an open discussion group over at LinkedIn for SLOB topics of interest.

Read More >
Page 10 of 52« First Page...89101112...20...Last Page »