Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: disk activity when no users/transactions
thanks for all great responsens everbody.... I guess, now I have a bit of testing/checking to do .... :-) again, thanks
PS. I have 8.1.6 on NT 4.0 SP6. w/ 512 Mb Ram, PIII 500, and plenty 'available' RAM, although yes, the whole database (and Ora files) are on a single SCSI disk which I will change in the near future. I am aware of the spread of different tablespaces on multiple disks and 'am working on it' however this is just a test machine that I'm using at home and as such, had not allocated the proper hardware. Oracle runs pretty fast, although the Java management tools are awfully slow on my machine. I probably need to get a 1 Ghz machine :-) <g>
In article <8nsq04$2re$1_at_nnrp1.deja.com>,
cosmin_ioan_at_my-deja.com wrote:
> hello all,
>
> I'm trying to troubleshoot and eliminate or at least, increase the
> interval at which the harddrive is accessed when absolutely no users
or
> transactions are running on the server. Basically, the drive is
> accessed about every 3 seconds (or so) and I believe it has to do with
> the checkpoint process or some other oracle process. Could anybody
> shed some light on how I can reduce/eliminate disk access when the
> database is in no use (other than shutting down the instance, which
> yes, eliminates all further disk accesses)
>
> thanks much,
>
> Cosmin
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Aug 22 2000 - 11:04:55 CDT