Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: disk activity when no users/transactions

Re: disk activity when no users/transactions

From: Cosmin Ioan <cosmin_ioan_at_my-deja.com>
Date: Tue, 22 Aug 2000 16:04:55 GMT
Message-ID: <8nu8am$n6j$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US