Re: stop chugging hard drive

"Brian Peasland" <oracle_dba_at_nospam.peasland.net> wrote in message news:IxM92L.C6G_at_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.
>

No it isn't anything like that.

It's an option I chose when installing the database. Something straightforward, like to do with archiving.....but I just can't remember.

One alternative causes the "chugging" the other doesn't.

I installed on two v. similar machines with the different results. The old machine, which doesn't chug, is kaput at the moment so I can't check out the difference.

I thought someone would just say "turn archiving off with XYZ" or similar. As I said, when I have a bit of time I'll sort it out as no one can provide a straightforward
solution.

Cheers. Received on Wed Apr 12 2006 - 12:10:53 CDT