• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 853
  • Last Modified:

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
0
mjimison1956
Asked:
mjimison1956
  • 3
  • 2
1 Solution
 
Titan522Commented:
What version are you running?
0
 
mjimison1956Author Commented:
version is Oracle 9.2.0.7
0
 
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now