Oracle articles

Seems like Tuesday might be the day of the post.
I promised a database article and here it is.

I was hunting for something else the other day and came across the website for the Rocky Mountain Oracle Users group. The training day material is awesome.
I suggest you delve into the many presentations which are available. It will make you understand Oracle heaps better. I thoroughly recommend the articles by Tim Gorman. The one about using statspack with the lag function as a performance stat. datawarehouse is very good.

I have finally had the chance to play with Oracle 10G in a work development environment, supporting a couple of projects which are going into production. The wheels unfortunately turn very slowly. So 12 months after the new release we are finally getting CIO or equivalent willing to use Oracle 10G in a production environment. Risk aversion city!
The change in the amount of information available at the DBAs fingertips is refreshing. The added bonus is the amount of extra history tables which allow you to check what was happening in the past.
Whilst you can be as proactive as possible, sometimes problems still occur. The ability to see what the database was doing previously makes reconstructing what was happening at the time very easy.

It is refreshing to have this wealth of information because I have been supporting mainly SQLserver for the last 18 months. The lack of a historical table such as v$sqlarea (which stores executed SQL) means that this type of detective work is not possible when you are trying to solve a performance problem after the fact.
I think I am close to developing a solution but the amount of work to gather historical SQL info is a real pain.
Hopefully I will time to make this completely stored procedure based. It looks possible.

Have Fun