Re: oracle is causing high WIO
- From: Jared Still <jkstill@xxxxxxxxx>
- To: raja4list@xxxxxxxxx
- Date: Mon, 24 Oct 2005 11:45:53 -0700
Are you running statspack on this db?
(level 5 is assumed for top SQL report)
If so, you can run a report and get an idea of which SQL is
causing massive IO. You can also see which datafiles are
involved in the IO.
If you have monitoring enabled at the table and/or index level,
you can also check dba_tab_modifications for IO.
This assumes at least version 9.2 of Oracle.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
On 10/24/05, raja rao <raja4list@xxxxxxxxx> wrote:
>
> It seems the problem is with oracle.
> Now when I shutdown the WIO is 0% AND when i start oracle, it is showing
> WIO as 80-90%
> $ sar -u 2 4
> SunOS oracle 5.9 Generic_117171-02 sun4u 10/24/2005
> 11:54:39 %usr %sys %wio %idle
> 11:54:41 4 4 85 6
> 11:54:43 1 2 83 14
> 11:54:45 1 2 81 16
> 11:54:47 2 2 82 13
> $
> how to find out why oracle is causing this high WIO ?
> can someone help me
>
Other related posts:
