Re: stop chugging hard drive

From: Brian Peasland <oracle_dba_at_nospam.peasland.net>
Date: Wed, 12 Apr 2006 15:44:43 GMT
Message-ID: <IxM92L.C6G@igsrsparc2.er.usgs.gov>

>> Which version and edition of 10g?
>> On what hardware
>> With what operating system
>> With what size swap file
>> And how much RAM?

>
> I dont think any of those facts are relevant.
> Re software options I said I set up with default options.
> If you can tell me any differences between the 10g versions regarding my
> issue I will personally give you a tufty badge.

Actually, they can be relevant. For instance, if you only have 512MB of RAM, then running 10g on the Windows box can lead to excessive swapping because you do not have enough physical memory. Swapping means harddrive activity.

Other things that could be going on (and this is only a guess because I have no facts to go on) could be that 10g, with AWR, is writing more information to the SYSAUX tablespace on a regular basis, thus creating more redo than you saw in pre-10g versions. More disk activity...

IDE disks are slower than SCSI or SATA disk units. Slower disks means it takes longer to read/write which leads to more time the disks are active. So the disk hardware can make a difference.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Wed Apr 12 2006 - 10:44:43 CDT