Blog Aggregator - Amardeep Sidhu

We are breaking in to our regularly scheduled blog with the following emergency message: “Are you ready for the impact that the 2007 Daylight Saving Time Changes will have on your Oracle Ecosystems?” I think that after reading this blog, you’ll agree that much work needs to be done to ensure that our systems are able to handle the new Daylight Saving Time dates for 2007.

Here is another advanced concept that will come in useful when solving Oracle problems.

Imagine you’re trying to create a result set where the rows need to be columns, or vice versa. In essence, you need to “pivot” rows into columns, or vice versa. That is a very common requirement, and this is where you need to look at a pivot (or crosstab) query to get the job done.

As always, when you

A few recommendations from your friendly ex-Oracle instructor on resources that will help you learn more about Oracle access paths. These resources will benefit beginners and tuning gurus alike.

We continue our discussion on Oracle access path identification. This blog takes an in-depth look at 10G Grid Control’s SQL Details Panels.

We have a situation where we need to rationalise the range of installed Oracle clients (i.e. the bit that sits between the app and the network stack) we have installed. We currently have versions from 7.x through to 10.2 installed accross approximately 12,000 desktops (accross various locations in an area of around 26 square miles) running various apps on Windows versions from NT4 to XP (mostly

The series on access path identification continues. We’ll review a couple of 9I Oracle Enterprise Manager tools that we can use to identify Oracle access paths. I’ll also show you a couple of beneficial utilities that will help you better understand access paths, monitor database performance and tune statements running in an Oracle 9I database environment.