Creating PLAN table in Oracle (9i)

If you need to set AUTOTRACE feature ON, you need PLAN tables created for sure. So, how do you create plan tables.

Which script ?
The script for creating Plan table is in $ORACLE_HOME\rdbms\admin\utlxplan.sql.

Where to create ?
Create the PLAN_TABLE by using utlxplan.sql in the schema where you need to enable trace and run the query.

What else is required ?
Also, create the ROLE named PLUSTRACE using a script in sqlplus\admin directory.

Grant this role to the user for whom you have created PLAN_TABLE.

Thats it ! login, run
SQL> set autotrace trace
You should be seeing the query plans.

Evolutionary Database Design - Pramod Sadalage's presentation during Q-Con

http://www.infoq.com/presentations/refactoring-databases

Splendid coverage of Evolutionary Database design with demonstration by Pramod Sadalage, the Agile DB practices guru.

Oracle: Interesting study about count(*) function in Oracle DB

What is the fastest way to count records in a table ?

Or how fast can you find if a table is empty or not ?

I came across this in Tom Kyte's blog.
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1156159920245

Happy reading :-)

Blog Name Change

I decided to diversify my experience across Databases like MySql, SQL Server in the market.
Henceforth, I will share any thing that was a challenge in my day-to-day work and how we as a team, solved those issues. I'll also publish solution for the challenges we saw.

Why I suffix tiger always in my blog name ? Simple reason.. It is my national animal and signifies Valour and Pride ... here it signifies magnificient wealth of information.

Troubleshooting vncserver start issues

My purpose was to install Oracle DB server on a Linux server, for which I required to start a VNC session.

I ended up facing the following errors...

error opening security policy file /usr/X11R6/lib/X11/xserver/SecurityPolicy
Could not init font path element /usr/X11R6/lib/X11/fonts/CID/, removing from list!
X connection to :2.0 broken (explicit kill or server shutdown).
xterm: fatal IO error 32 (Broken pipe) or KillClient on X server ":2.0"

So, began to troubleshoot and fix errors one by one...

How to fix them ?

First, let us fix "error opening security policy file /usr/X11R6/lib/X11/xserver/SecurityPolicy".

In my machine, the actual SecurityPolicy file was available in /etc/X11/xserver/SecurityPolicy.
So, created a symbolic link at /usr/X11R6/lib/X11/xserver/ for SecurityPolicy file.

Will post again on how to fix the next issue.

Continuation...
Could not init font path element /usr/X11R6/lib/X11/fonts/CID/, removing from list!

How did I get rid of this error ?
A colleague of mine disabled the firewall on the Linux box I was using. Voila, VNC works !