Blog Aggregator - Amardeep Sidhu

We have a NetApp FAS filer attached via Gigabit Ethernet to a Sun V440 running Oracle databases the files for which are stored on the filer The NetApp volume is mounted under NFS version 3 at $ORACLE_BASE/oradata. Under that directory are 7 directories .snapshot, dctm, dchr, dctm_backup, dchr_backup, dctm_nobackup, dchr_nobackup.

.snapshot is where the NetApp filer stores snapshots of the

I was just looking at my stat counter analysis for this blog, it’s usually a good way to find out if anyone has linked to me. From the results it looks like the vast majority of people (around 97%) find this blog through a search engine, virtually all (over 99%) through Google. Most common search strings are or include “ORA-07445″, “opmnctl failed to start process” and “ORA-01031″.

During his presentation on “Inside RAC” Julian Dyke appeared to suffer laptop difficulties so asked for 4 volunteers to assist in a demonstration. Being the helpful soul (i.e. idiot) that I am, I volunteered. Mr Dyke did seem remarkably wellprepared in terms of props, almost as if he had been expecting his laptop to have problems :-)!

Photographic evidence (courtesy of Connor McDonald) can be

Now that we have used 10G DBConsole’s toolsets to identify the top resource consumers, our next step is to determine the access paths our poorly performing queries are taking. This series of blogs begins with a high-level overview of Oracle query optimization. We’ll also learn the difference between estimated and runtime access paths. Subsequent blogs will provide details on the various tools we can use to retrieve access path information.

A question just appeared on the Oracle-L mailing list about whether there are any issues with using histograms. I’ve seen a number of presentations over the last couple of years that have warned about issues where you have histograms on highly skewed data and use bind variable (or have cursor_sharing=force, which synthesises bind variable from literals in queries), so I responded:On 19/11/06, A

Today was the first day of the United Kingdom Oracle User Group 2006 conference.

The day itself was pretty good, lots of good talks (more on that later), but I ran into a couple of issues in the evening. The first issue was when I went into the Handmake Hamburger just accross the canal from the ICC, I was alone and the waitress/Maitre d’ said they didn’t have any free tables suitable for one

18 months.
107 posts.
110,000 reads.

Not too long ago I reacted with humble incredulity that 10,000 people had read what I had to say about Oracle.

Here I am, exactly one year later, and there have been 100,000 more visits. I’m almost afraid to continue, will I be talking about 1,000,000 in November 2007?

I wonder why people are reading my blog because, despite how numerous we are, it seems

In part three of this series, we’ll use 10G Grid Standalone to identify the top resource consumers for a given instance. We’ll learn that 10G’s DBConsole is able to provide us with all of the information we need to identify the top resource consumers, what resources they are consuming and the SQL they are executing.

You have a table with all your company’s financial transactions. There is another table which references a subset of these financial transactions (ie. transactions with certain properties).

Your current solution to maintain the integrity is to set up a foreign key, referencing the transactions table, and then write a trigger to make sure that any records reference only transactions that have

In my previous blog, we discussed the investigative process used to determine exactly what application component is causing the performance problem. This blog will cover the various Grid Control and Host Monitoring Tools we can use to further drill down into the database ecosystem (database, O/S, hardware server) to provide us with additional diagnostic information. In future blogs, we’ll continue our investigation using Grid Control’s database performance monitoring and analysis tools.