Blog Aggregator - Amardeep Sidhu

The comment thread on my blog entry about the simplicity of NAS for Oracle got me thinking. I can’t count how many times I’ve seen people ask the following question:
Is N MB/s good throughput for Oracle over NFS?
Feel free to plug in any value you’d like for N. I’ve seen people ask if 40MB/s […]

This week I have delivered my first
11g New Features Overview Seminar
for Oracle University in Switzerland. 
Here is my 11g teaching schedule so far:
- September 07th. Zurich (Overview)
- September 12th. in Prague (Overview)
- October 15th. Brussels ? (5 days hands on)
- October 22nd. Istanbul (5 days hands on)
For questions about these and other events
and bookings
please send me an […]

Now don’t get me wrong. What I’m blogging about is not really an Oracle Database 10g Real Application Clusters (RAC) problem. All of the problems I will mention in this entry were clearly related to a botched configuration at the OS level. Since Oracle10g will be around for a long time, I suspect that some […]

One of the uses of materialized views is replication. Mviews can be used to replicate a table to another database to prevent users from accessing several databases through database links. This can improve the performance of queries which frequently access that table by removing the latency of the database link.

Today the refresh job of one of the mviews we use for this purpose started getting “

yeah, I should have done this a long time ago.

Unfortunately, been busy as heck with a Peoplesoft upgrade that somehow degenerated into installing and setting up two additional servers and a load balancer with the usual plethora of problems, compatibility glitches, version clashes, appserver performance issues, etcetc…

Had to put my foot down and explain very clearly that my field is

Howard Rogers has a series of blog entries about Oracle11g initialization parameters. I recommend it. Here is a link:
New and obsolete Oracle11g initialization parameters.

After talking about theSQL Analyzer (Sql Replay) in part I of this series andDatabase Replay in part II I will introduce you this time to some 11g New Features for the query optimizer.
1. As of Oracle 10g the server collects optimizer statistics on all objects which do not have any object statistics in the […]

Now I’m glad I did that series about Oracle on Linux, The NUMA Angle. In my post about the the difference between NUMA and SUMA and “Cyclops”, I shared a lot of information about the dynamics of Oracle running with all the SGA allocated from one memory bank on a NUMA system. Déjà vu.
Well, […]

In a recent post on the oracle-l list, a participant asked:
Hi, has anyone used 10.2 Clusterware with OCFS2 on RHEL5 to get single instance failover from one host to another?
My buddy Matt Zito (we’ve had beers before so we’re buddies) of GridApp followed up with:
I have a customer that does that - it apparently works […]

Oracle Database 10g Automatic Memory Management (AMM) might have been this smart, but I don’t know. I’m playing a bit with Oracle Database 11g AMM and find that so far it is a pretty smart cookie-at least in the sense I’m blogging about in this entry.
Automatic So Long As You Do Everything Correctly 
One […]