Re: Weird i/o problem with laptop and 7.3.4.5

Of course you have only one single disk on that system, and your redologs are hitting that disk very hard and you are still suprised it is slow? Check the frequency of your log switches in v$loghist and the total size of redolog by means of v$log, and you will know the answer. Probably you have 200k online redologs, as this is the default. Increase them to at least 5M, and have 4 redolog groups minimum.

Regards,

Sybrand Bakker, Oracle DBA

"Mark Glass" <mkg_at_fastpagefx.com> wrote in message news:%iSA5.18630$PW4.6177528_at_typhoon.southeast.rr.com...
> Does anyone have any ideas about this one?
>
> I created a large empty database on a laptop with no problem. Next, I
 began
> to import a database from a development box, by usernames. I got
 suspicious
> of the import after checking the disk i/o and the progress of the import.
> Basically, it was importing like a dog, with the disk i/o running at about
> 95% plus. When I broke the import the i/o stayed at 95% ish, with no
 other
> task running.
>
> There is nothing running in DBA_JOBS. Nobody is connected to the machine.
> When I shutdown the instance i/o drops down to virtually zero. The moment
 I
> start the instance back up, it returns to nigh on 100% disk utlization. I
> have an SGA of about 70MB and about 40 MB available physical memory left
 on
> the machine, so it does not appear to be a memory problem. Because this
> happened earlier in the week too, I rebuilt the instance from scratch,
 using
> a slightly hybridised init.ora file, just to ensure I have no unwanted
> parameters sneaking in.
>
> I'm really at a loss on this one. I've never experienced anything like
 this
> in a great many laptop installations. It must be something that the
 import
> is bringing in, but the source database is not suffering with it, and if I
> clear out all but SYS/SYSTEM and DBSNMP, it STILL persists!
>
> If anyone has any suggestions, I'll be very grateful.
>
>
>
> Mark
>
>
Received on Fri Sep 29 2000 - 00:55:24 CDT