Now our database have 20GB data and the performance is extremely slow
So i would like to is the io of disk storage slow or there is bottleneck on oracle

the disk storage used NAS with Oracle 9i on IBM AIX dual CPU 2GB ram

Hi,

Go for oracle statspack. It give good picture about oracle performance.

Thanks,

but how can i refer to this .. And which part should i study

install the statspack package

SQL> @ORACLE_HOME/rdbms/admin/spcreate

if you run into problems simply run spdrop.sql as peruser

then set timed_statistics = true
collect snapshots at the highest level which is 10

analyze the wait events esp. for I/Os

for me I once figured out that even in a SAN/NAS Storage spindles count

You can use the OEM Tuning Pack -> Expert. All you have to do is to install the agent on your db server and collect some statistics. The Expert will give you a tuning recommendations.

The more precise way is to use STASTPACK as suggested.


HTH,

clio_usa - OCP 8/8i/9i DBA