Re: Why would installing Oracle 10g decrease overall disk performance?

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 25 Aug 2005 17:55:07 -0700
Message-ID: <1125017707.850612.299530@g49g2000cwa.googlegroups.com>

Wes Harrison wrote:
> SiSoft SANDRA Pro to do a File System Benchmark before and after the
> installation. Before, the drive index is about 80MB/S but this decreases by
> half after Oracle is installed. If I uninstall Oracle, the drive index
> returns to about 80. Reinstall Oracle and it goes back down to about 40.

Have you tried with Oracle installed but shutdown? If it is started up, Oracle peeks at the redo log and control files every coupla seconds. It's enough to throw disk benchmark programs out the window: they assume nothing else is running.

> Does it have
> something to do with some of the Oracle processes interfering with SANDRA
> Pro?

My guess: yes. Anything doing IO while SANDRA is running will affect the results. Received on Thu Aug 25 2005 - 19:55:07 CDT