Re: stop chugging hard drive

"Jack" <test_at_test.com> wrote in message news:VNednTDxatc8qaDZRVnyrQ_at_pipex.net...
>
> "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.

Maybe not archiving but to to with restoring..... Received on Wed Apr 12 2006 - 12:11:56 CDT