Grow Oracle Linux Root Filesystem

It is always the case that in my Linux VM installations I run out of root file system space and need to grow it (I can hear you experienced admin, I should create another filesystem for my use and not use root file system for my joy). Here are the steps to grow root filesystem for Oracle Linux running on VMware:

Click on the wrench symbol to go to your virtual machine configuration menu

Screen Shot 2012-12-31 at 1.02.46 AM

Choose Hard Disk (SCSI) menu to increase the size of an availabe virtual disk (in this case your root file system disk)

Screen Shot 2012-12-31 at 1.07.12 AMGrow your virtual disk (more...)

End of 2012

Year in review As we end 2012, in closing I have not posted much due to work and many activities wrapping up the year. My new Oracle R12 EBS book is available and ready for folks to learn the tips and tricks for Oracle R12 Financials from Oracle Press. Each year I pursue a new goal and try to master or improve a skill or ability. This keeps me sharp and motivated and happy. Last (more...)

TROUG 2012 değerlendirme

2013 ‘e ışık tutması açısından, 2012 ‘de TROUG ile yaşadığınız deneyim paralelinde sizlerin geri beslemelerini merak ediyorum. Hatırlatma amaçlı 2012 ‘de ne gibi aktiviteler gerçekleşti sitemiz anasayfadaki “Geçmiş Etkinlikler” bölümünü inceleyebilirsiniz:

ADF Mobile : Device Interaction API – Pictures, GPS and Email With Attachments

During the AMIS ADF Masterclass I showed how to take a picture from within an ADF Mobile application, attach it to an Email and send that email out to several recipients. To top it of, I even added the GPS coordinates to the subject, so you know where the picture (more...)

Build an 11gR2 RAC cluster in VirtualBox in 1 Hour using OVM templates

[I originally posted this over at the Pythian blog. If you're not following it, you should! Way more content, by far smarter people than lil ol' me.]

After reviewing my blog post about running EBS OVM templates in VirtualBox, two of my teammates suggested that I work on something with potentially broader appeal. Their basic message was, "This is really cool for us EBS nerds, but what about the Core DBAs?"

So how does "11gR2 RAC in an hour" sound? :-) In this post, I'll demonstrate how to deploy the pre-built Oracle VM templates to create a two-node (more...)

Timing: rowsource statistics. Part 2: Overhead and inconsistent time

Timing sampling frequency:
Number of calls getting timestamp depends of parameter _rowsource_statistics_sampfreq (default is 128).

  • If this parameter is set to 0, there are no time calculations in rowsource statistics. The functions qerstSnapStats()/qerstUpdateStats()do not get timestamp
  • If this parameter is set to 1, time is calculated always. Every pair qerstSnapStats()/qerstUpdateStats() gets timestamp (this is the case in the excerpts above).
  • If this parameter is set to N (as default value 128) then timestamp will be got every N tuples. It means that only N call of qerstSnapStats()/qerstUpdateStats() on some rowsource level will get (more...)

Timing: query execution statistics (rowsource statistics). Part 1: How it works

This is the first (but not last) blogpost of my explanation of timing. This stuff is about timing in query execution statistics which also called rowsource statistics.

Here I am explaining

  • why reported actual time (“A-Time” or “time=” in sql trace) can be inconsistent,
  • why execution time with statistics_level=all can be longer,
  • and how exactly it works.

This stuff covers versions 10g and later if another is not mentioned.

Merry Christmas and Happy New Year 2013! ;-)


The rowsource statistics are figures as time spent during execution of rowsource (a step of execution plan), number of returned rows, number of (more...)

crontab backups: a simple, time-saving holiday gift idea for DBAs and sysadmins

[I originally posted this over at the Pythian blog. If you're not following it, you should! Way more content, by far smarter people than lil ol' me.]

It's holiday season in many parts of the world, but it's not all parties and egg-nog. Caretakers of critical IT systems often have significant work to do as those systems roll over into a new year. In some cases, we're just monitoring to make sure nothing unusual happens. In other cases, however, we're making the unusual happen: running those batch jobs and backups that only fire once per year.

So what happens (more...)

Configuring outbound SSL for the SOA Suite

A customer had a situation where they had to call a remote Web Service from the SOA Suite via https. (One-way TLS/SSL). The developers had deployed the SOA Application so I had to configure the SOA Suite to trust the key used for SSL. For unknown reasons the normal Weblogic (more...)

UKOUG 2012

My third time visiting the annual UKOUG conference in Birmingham started all wrong. At Schiphol Airport, the usual luggage check routine took place: laptop out of the suitcase, wallet/keys/belt apart, toothpaste apart. And afterwards putting everything back in. But I forgot to close the wheeled suitcase and when putting it on the ground, my MacBook Pro fell out. A quick inspection revealed that

Poem: "Wrong Address" – a tribute to victims of Newtown massacre

When I dropped you off at the school last Friday
Your eyes were so bright
Face so charming;
You told me with your sweet voice
The weekend plans of your choice
The ballet class on Saturday
Bowling on friend’s birthday;
Helping your (more...)

Continuous Scrolling in ADF Tables

One of the more promising patterns in Web UI development is Continuous Scrolling. Popular sites such as Twitter and Facebook use it. With Continuous Scrolling, new data is automatically retrieved as the user has scrolled to the bottom of the page.

I recently discovered that this is already a (not (more...)

Oracle GoldenGate Sequence Replication

When using Oracle GoldenGate sequence replication there is a number of issues you need to be aware of especially if you replicate quite a lot of busy sequences.

The first issue is that GoldenGate sequence replication does not use bind variables. Let's execute the following statements on the source system:
SQL> create sequence rep1.s1 nocache;
Sequence created
SQL> select rep1.s1.nextval from dual;
SQL> select rep1.s1.nextval from dual;
GoldenGate uses PL/SQL procedure called replicateSequence each time it needs to sync sequence values. The following calls will be made on the (more...)

Dark Reading – Database Security

I was interviewed for a nice article about database security on Dark Reading. The interesting question, I think, is not wether to invest in DB security. To me, it’s a given that you have to do it (even though some customers still don’t agree). The question is – how will the threat landscape change if [...]

DJ Patil at LeWeb, December 2012

Reblogged from What's The Big Data?: Summary of the presentation by Ben Rooney here Update: Ben Rooney interviews DJ Patil Read more… 6 more words, 1 more video Once again DJ Patil nailed it.

APEX: Running multiple version on single Weblogic Server

Sometimes you would like to have multiple versions of APEX running on one Weblogic Server, or Weblogic Cluster. For example, you would like to run APEX version 4.0 and version 4.2 along each other.

To configure this is rather simple and straight forward. The trick is to use (more...)

Learn from the smaller one’s : Native support for ENUM Types

Gerhard a colleague is dealing with postgres databases and was very suprised how many features are very oracle like. For example the same concept of Sequences as in Oracle. But then he detected the postgres enum native type support in postgres and asked me if the same feature would exist in Oracle.

Winners of the Competition! Win A free copy of the ‘Oracle ADF Real World Developer’s Guide’. Here are the winners

Hello all

The competition is over!

You can find the description of the competition here:

I would like to thank you all for your excellent and inspiring comments!

As you know, only two winners will be able to get a free copy of the book.


Remember to check the obvious.

Its easy to forget to check the obvious sometimes, a user complains that performance of a RAC cluster is appalling, a quick dive into OEm shows everything is spending forever in cluster waits, its easy to dive into sql performance tuning mode. Alternatively you can start looking for hot blocks or small tables being pinged back and forth across the interconnect. Luckily I noticed something odd in SAR first, my interconnect only transferring 1.2mb/s but everything still hung up on cluster waits a quick check of the network card:-

racnode1:~ # ethtool eth4
Settings for eth4:
        Supported ports: [ TP ]
        Supported link modes:   10baseT/Half 10baseT/Full

APEX 4.2.1 Patch Set Released

Today we released APEX 4.2.1 on the APEX OTN Download page.
This  is a cumulative patch set for APEX 4.2.0.
If you already have APEX 4.2.0 installed then you will need to download the patch from My Oracle Support , Patch # 14732511 {Filename (more...)