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

"Robert Klemme" <bob.news_at_gmx.net> wrote in message news:3n5vn1F164rU1_at_individual.net...
> Wes Harrison wrote:
> > I am installing Oracle 10g 10.2.01 on Windows Server 2003 SP1 32-bit
> > edition but for some strange reason the overall performance of the
> > disks on the server decreases after it is installed. I know this
> > because I am using 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.
> >
> > No other package that I have installed on this server has had this
> > effect. So I figured it must have something to do with fragmentation
> > but the results are unchanged after a full defrag.
> >
> > What could be causing this? Is it an error in the benchmark? Does
> > it have something to do with some of the Oracle processes interfering
> > with SANDRA Pro? It can't be just coincidence as I have repeated the
> > test several times.
>
> Maybe this: more main mem eaten up by Oracle so the OS assigns less to
> disk buffers. What happens if you install Oracle but do not start it?
>
> robert
>

Please post complete configuration:
Memory/Processor
# of disks
RAID, JBOD, interface(s) (SCSI, IDE, SATA)

Could you be swapping while Oracle is running?

How is your RDBMS configured?

Etc...

-- 

Andreas Sheriff
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer
----
"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding, if you don't eat your meat?"

DO NOT REPLY TO THIS EMAIL
Reply only to the group.