Blog Aggregator - Amardeep Sidhu

As devoted readers may have noticed, my new job doesn’t involve nearly as much work with Oracle. I stay sharp by reading Ask Tom, the very site that has provided me with 90% of the answers that I can’t find in Oracle documentation or figure out on my own.

Those of you who may find it nerdly to spend lunch hours reading Oracle Q&A are actually really missing out. It’s far more entertaining than

Now that we have an understanding of how we can influence access paths using hints and session parameter changes, let’s continue our discussion by reviewing the various types of indexes as well as indexing strategies that affect Oracle access path selection. We’ll complete this series next week when we use all of the information we have learned to perform our own scientific analysis on Oracle optimization.

This week I have delivered my INSIDE ORACLE special seminar for the first time.
The seminar is a two day event which deals with Oracle 10g key features and upgrade issues.
I had 18 delegates with different backgrounds who were highly interested in memory management, new performance tuning techniques and backup strategies.
In between the paticipants had the […]

I just found my blog translated into another language:http://translate.google.com/translate?hl=ja&sl=en&u=http://luhartma.blogspot.com/2006/09/statisticslevel-in-oracle-10gr2.html&sa=X&oi=translate&resnum
Can anybody tell me which language this is?
connect lutz hartmann as sysdba

Today I received a comment on my post about licensing of the Enterprise Manager packages.
Edgar pointed out a petition which has already been signed by 140 people.
This petition requests that Oracle Corporation should make all of its Enterprise Manager management packs available to all of its customers at the same price, regardless of the edition […]

We continue to analyze the affects that initialization parameters, statistics and hints have on SQL statement access paths. In this blog, we’ll take a look at the hints we will be using to influence the optimizer to select an access path that is different from the one it would normally choose. We’ll also review a few of the tools that we will be using to monitor and compare SQL statement access paths and performance for our upcoming tests.

because for the last 5 years, Oracle has heard from many users that the way they get updated is broken and needs recoding.

And they have done preciously nothing about it.
In 8i, 9i and 10g.

Heck, they don’t even use them in their dictionary itself!

Have a look at just one of many problems - for more, go to Metaclick and search on LOB in the bug database.

It starts off mild and sedate:

This just came up on the mailing list for my local Linux Users Group following last night’s meeting (which I didn’t attend), the original mail and my response is below:

> In the pub, there was an interesting conversation going on regarding
> validation of data in databases.
>
> Excuse the omissions, as I said, it was overheard
>
> Someone brought up the point that in databaseX If say, you have a

If you want to become an access path guru, you’ll need to spend some time learning how optimization parameters, statistics and hints affect SQL access paths and statement performance. This blog will provide you with a few hints and tips to help you begin your scientific analysis of the Oracle optimization process. In upcoming blogs, I’ll provide you with some sample test cases.

This entry is partly an aide memoire for me, partly to try to get something that has been keeping me awake for the past hour or so out of my brain so I can sleep and partly in the hope that someone can suggest a way forward.

A quick bit of background. Until April 06 most of our major systems were looked after by an external Faccilities Management company. In April 06 IT was kind of outsourced