Partnership and Status Table

The Partnership and Status Table (PST) contains the information about all ASM disks in a disk group – disk number, disk status, partner disk number, heartbeat info and the failgroup info (11g and later).

Allocation unit number 1 on every ASM disk is reserved for the PST, but only some (more...)

Talk the Talk

I’m pleased to say that I am now on twitter as JoelJGoodman. I also am pleased to add that I have been confirmed as a speaker at the DOAG conference where i will speak on Global Resource Management in RAC. This is on 19/11/2013 at 15:00 CET. I have been (more...)

Is it just me, or doesn’t anything work in JDeveloper 12c?

Preparing for OpenWorld, I’m updating all my demos to 12c. Unfortunately, my conclusion so far is that nothing works.

The BC tester (now renamed ADF Model Tester) crashes JDeveloper and doesn’t take bind variables. A simple ExecuteWithParams example ignores my parameter value. The list goes on…

Oracle tries to imply (more...)

WebLogic Server – Max Restarts Within Interval

In some situations you have to restart a WebLogic server many times to get something working. A quick and dirty way of restarting a server is to kill the process and let the Node Manager start it up again.

When you kill the process you will see this in the (more...)

I’m not available

I'm happy to say that I'll shortly be starting a new position as a PostgreSQL DBA and Python developer for Zoro Tools!

We software types seem to have hardware envy sometimes. We have "builds" and "engines" and "forges" and "factory functions". But as it turns out, the "Tools" in "Zoro (more...)

Upgrading WebLogic domains

I noticed that in WebLogic 12.1.2 the old domain Upgrade Wizard has been replaced by a new Reconfiguration Wizard.

I have upgraded WebLogic many times, but I have never upgraded a domain.

If you upgrade WebLogic within a major release e.g. 10.3.5 => 10.3. (more...)

Flashback query FTS costs

There has been some information written on the subject already (see this post by Randolf Geist).

In a nutshell, the way optimizer costs full table scans when using flashback query makes it look much more expensive than without. What further complicates the problem is the fact that index access costs (more...)

Data Pump 12c – Pumping Data with the LOGTIME Parameter

Since its release, Oracle Data Pump has been a worthy successor to the traditional exp/imp tools.  However, one area lacking with Data Pump has been something as simple as the ability to identify how long each step of a Data Pump job actually takes.  The log will show (more...)

Oracle Openworld 2013 Session confirmed

Here are the session details for those who will be able to join:

Session ID: HOL10048
Session Title: Continuous Integration Techniques to Support Your SOA Software Development Lifecycle
Venue / Room: Marriott Marquis - Salon 12/13
Date and Time: 9/26/13, 12:30 - 13:30

Looking forward to meeting you!

Oracle 12c OFFSET…FETCH.. bug?

Working on the chapter that covers best ways of manipulating with object collection. Of course, if you talk about pagination of the rowset, it is very tempting to test Oracle 12c new feature - OFFSET…FETCH.

Unfortunately, immediately got an issue. It seems to me that passing a variable to FETCH (more...)

DBA or Developer?

I've always considered myself a developer and a LOWER(DBA). I may have recovered perhaps one database and that was just a sandbox, nothing production worthy. I've built out instances for development and testing and I've installed the software a few hundred times, at least. I've done DBA-like duties, but (more...)

Staying quiet… For a good reason :-)

Please, don't worry - I didn't suddenly disappear from the surface of the world of databases. It just happened that after some years of staying outside of publishing business I've been recruited to make a new book.The tentative name/dates are: PL/SQL Performance Tuning Guide: Tips and Techniques (Oracle Press, (more...)

IPython at Ohio LinuxFest 2013

Are you signed up yet for Ohio LinuxFest on Sep. 13-15? I'll be there to present

IPython for non-Pythonistas

Break out of your (bash) shell! IPython and the IPython Notebook have swept over the Python programming community, but they're not just for Python programmers - they make for high-powered shell (more...)

WebLogic Server configuration backup

The WebLogic server stores its configuration in files in the DOMAIN_HOME/config directory. The main file being config.xml.

The way configuration changes are handled depend on if you are using the domain configuration locking feature. In Production Mode configuration locking is enabled by default and in Development Mode it is (more...)

Configuring ODBC to MySQL from Oracle

Sometimes people want to connect to MySQL from Oracle and copy table data between the databases.  You can do that with Oracle Hetrogenous Services via ODBC.  This post will show how to create an odbc connection to your MySQL database which is the first part of this.

For my example, (more...)

People, Performance and Perception

A commonly heard complaint: “My manager is a control-freak and practice micro-management. He asks for suggestions but provide them all himself. He doesn’t believe in imperfection and try to fit us into his unrealistic expectations. “

Perceiver believes that it is the reality but he might be just focusing on (more...)

Configuring MySQL on EL5, Setting Passwords and Network Access

I find myself installing and running mysql of different versions in different places for different reasons all the time (well often enough to do it and not remember the little things that cost time when setting up)   Its with that in mind, I'm making notes for myself and you (more...)

Allocation Table

Every ASM disk contains at least one Allocation Table (AT) that describes the contents of the disk. The AT has one entry for every allocation unit (AU) on the disk. If an AU is allocated, the Allocation Table will have the extent number and the file number the AU belongs (more...)

Free Space Table

The ASM Free Space Table (FST) provides a summary of which allocation table blocks have free space. It contains an array of bit patterns indexed by allocation table block number. The table is used to speed up the allocation of new allocation units by avoiding reading blocks that are full.


Custom Jersey WADL generation

I had a situation where the auto generated WADL did not match with my Rest services. The first difference was that the response is presented as an object instead of a collection of objects and the second one is that it could not handle JSONWithPadding as response.  Because I use (more...)