Blog Aggregator - Amardeep Sidhu

This series covers a few of the features that you may often overlook when using 10G. There are so many features in each new release of Oracle’s flagship database that the challenge is to leverage as many features as possible to make your day-to-day life easier.

Steven Feuerstein is coming back to Switzerland and Germany in May and
will deliver free Best Practice PL/SQL Development seminars
for Quest Software .

Here are the dates and contents:

May 22nd. 2007 in Zurich
May 21st. 2007 in Frankfurt
May 23rd. in MunichContents of the seminar:
Best Practices for PL/SQL Development
We all want to “do the right thing” when it comes […]

It’s funny how every year the issue of training and knowledge transfer seems to crop up around this time. Must be something in the change of weather?
Anyways, over the last few weeks a lot of folks have commented on the need to re-examine the training of new DBAs and more in general, the issue of training people for future IT positions.

Because there is a very definite fall in enrollment

This week I will deliver a course for DBAs in Tallinn thecapital of Estonia.
I have arrived toiday in the early afternoon and had a first walk around in town.
Tallinn is a city with a very moving history:
Since 1918 when the Independence Manifesto was proclaimed in Tallinn it has been occupied multiple times by the Germans as […]

Before I had left for Belgium last week I had a nice visitor:
Michael Cebulla had dropped in and we met in Zurich for dinner.
He had deliverd a course in south of Germany and was so nice to visit me for one night at my home in Fislisbach. The next day he drovfe back to Germany […]

Last week I delivered a DBA training @ the Brussels Airport Business Center.
It was a fun week with 15 DBAs from all over Belgium.

In Brussels I had a walk around the old city one evening after classes… …and even managed to find Manneken Piss.
 

I was trying to decrease the number of parses for a 9.2.0.7 production database when I realized that the top parsing sql was coming from another database through a database link. This sql has a parse/execute ratio of 1 meaning it is parsed every time it is called. I have searched the bug database and found that there is a bug about parsing when you are joining a local table with a remote table,

I thought I would combine two different topics of conversation. We’ll review of some of the 10G features that we take for granted or are easily overlooked. The discussion also continues its lighthearted review of day-to-day DBA life and provides a few helpful hints and tips to make that life easier. Weird combination but it may make for an interesting and informative read.

There are some important things to consider when interpreting sql trace files. One of the most important ones is the read consistency trap as it is called in the documentation.

If you see different number of block reads with the same data at different times when you trace a sql statement, this can be one reason. A test case showing what this means follows:

SQL> create table t as select * from

I review some of the 10G features that we take for granted or often overlook. The discussion, although somewhat whimsical at times, does provide some very useful information.