Blog Aggregator - Amardeep Sidhu

The function SQLERRM can be used to return an Oracle error message in PL/SQL to the calling environment.
In Oracle 10g the value which the function SQLERRM can return is something like 512,
prior to 10g it was 255.
 
Therefore Oracle recommends not to use this function but rather use
DBMS_UTILITY.FORMAT_ERROR_STACK instead of the SQLERRM function!!
This in fact […]

Yesterday we had a fun evening with Steven Feuerstein at the Spielhaus in Zurich a nice Billard saloon in Zurich where you can get a good dinner as well.
Steven is really good at billiard , I did not have a chance against him.

Laurent Schneider was around also

and we had lots of fun after a good […]

Yesterday Steven Feuerstein arrived at Zurich airport where I picked him up.
He will deliver a two day seminar for Oracle University about
best practices for PL/SQL programming.
The event takes place at the Sonnenberg convention center in Zurich,
where the Head Quarters of the World Soccer Association FIFA is located.
The below picture show Steven with the FIFA Cup […]

What happened to Kathy is just plain unacceptable.

I’ve been very vocal for many years now on the subject of anonymous posting. To me, anyone using anonimity in the name of “freedom of speech” is just trying to fool themselves.

Democratic freedoms come with responsibilities. One’s right to voice an opinion should not EVER preempt one’s responsibility to the rest of the social structure

Been testing the grid control in EM.
Part of our current monitoring tool eval.

Hmmm, call me a ludite: but I prefer the Spotlight GUI look to the drab old web-based UI of grid control.

By a country mile!

If there is one thing that all this web-mania of the last 5 years has done is create some very boring, incredibly convoluted and hard to navigate user interfaces!

Sorry folks: GC is so

Today I could I could hand over the IPOD to one of my students
because he had booked two Oracle courses
between December 2006 and February 2007.

The foto shows me and Fred Goeres with his brand new 4GB IPOD.
Have fun with it Fred!
=;-)

We combine all of the knowledge we learned in previous blogs of this series to begin our scientific analysis on Oracle optimization. We’ll review some of tools we can use to display access path information and look at some graphical displays that will assist us during the analysis process. I’ll also provide you with some examples to jump-start your testing.

This weekend the new SAN hardware was installed.

Apart from a minor hickup in communications - someone assumed changing disk storage infra-structure didn’t imply downtime of databases… - the whole exercise was almost easy. It did help the folks who did the installation knew what they were doing. I worked for this company for a few years. They have some very competent people there, when it

Today I have received a copy of the DOAG news 1/2007
from the German Oracle User Group
with my Tom Kyte Interview in German 
.  Thanks to DOAG for sending it to me in Switzerland!
=;-)

We continue our series on Oracle access path scientific analysis. In this latest installment, we’ll do a quick review of some of the blogs that led us to this point. We’ll also learn how to select a set of SQL statements that we will use in our test cases.