Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: aix, oracle 7.3.4 and high waitstate
Hi Steve.
I'm not sure i understand those 50%+ wait times ?
Have you monitored for waits on rollback, redo-log etc ?
Best regards
Jan
Steve Perry wrote in message <36539965.953035E_at_sprynet.com>...
>We upgraded our server from 4 cpus and 1 gig of ram to 8 cpus and 4 gig
>of ram. The cpus are twice as fast and are 64-bit. We used the same
>number of mount points, but changed the blocksize from 4k to 8k. The new
>system seems to perform ok, but I see 50%+ wait times when I run
>monitor. I looked for hot files, busy buffers and heavy sql, but don't
>see anything. I also ran iostat. Is there anything else I can do to see
>what the wait is from? Our sa said the machine is so much faster, that
>the disks are causing the high waits. There has to be a way to see what
>it is waiting on or where the wait is at.
>
>Thanks,
>Steve
>
Received on Sat Nov 21 1998 - 05:36:15 CST