Re: Tuning Question

From: lfree <windows-free_at_163.com:s/windows/linux/>
Date: Fri, 6 Feb 2004 08:42:45 +0800
Message-ID: <bvunub$5lk$1@news.yaako.com>

> We run Oracle 8.1.7.4 on Solaris 8. The main table contains approx
> 6 million rows and is approx 2.2gb in size . The CBO is set to
> first_rows
>
> Most of the queries generated seem to use index range scan and table
> access by rowid. I am lead to believe that this can be quite
> inefficient for large tables such as ours! (I am no oracle expert)
> I am also seeing large disk I/O with wait time of around 70%

if your phy disk read is 20%-30%, use index is better.

I think your system exist bad SQL £¬you make sure large disk I/O associate the table ,I suggest you use `TOAD` to check SQL AREA.

other your using index is reasonable? Received on Thu Feb 05 2004 - 18:42:45 CST