High Data Block wait time

I have extremely high data block wait time....

block   73821695
wait      4835256

The script I ran for this is:

select   CLASS,
         COUNT,
         TIME
from     sys.v_$waitstat
order by CLASS;

We are experiencing very bad performance.

Help?

Mike
mjimison1956Asked:
Who is Participating?
 
Titan522Commented:
Are these problems new or been around for a long time? Any increase in users or large amount of data being added or removed?
0
 
Titan522Commented:
What version are you running?
0
 
mjimison1956Author Commented:
version is Oracle 9.2.0.7
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
mjimison1956Author Commented:
Have been around, new to the db....  performance has been getting worse and worse.  
0
 
Titan522Commented:
Sounds like you have out of date stats or are doing a large number of full table scans. Would get some commonly run queries and see what the explain plan is.
0
 
cdemirCommented:
how about initORA?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.