Solved

High Data Block wait time

Posted on 2006-06-21
6
834 Views
Last Modified: 2008-02-01
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
Comment
Question by:mjimison1956
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 3

Expert Comment

by:Titan522
ID: 16952027
What version are you running?
0
 

Author Comment

by:mjimison1956
ID: 16953036
version is Oracle 9.2.0.7
0
 
LVL 3

Accepted Solution

by:
Titan522 earned 250 total points
ID: 16954690
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
Webinar: Choosing a MySQL HA Solution

Join Percona’s Principal Technical Services Engineer, Marcos Albe as he presents Choosing a MySQL High Availability Solution on Thursday, June 29, 2017 at 10:00 am PDT / 2:00 pm EDT (UTC-7).

 

Author Comment

by:mjimison1956
ID: 16955167
Have been around, new to the db....  performance has been getting worse and worse.  
0
 
LVL 3

Expert Comment

by:Titan522
ID: 16955187
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
 
LVL 3

Expert Comment

by:cdemir
ID: 16962919
how about initORA?
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question