?
Solved

High Data Block wait time

Posted on 2006-06-21
6
Medium Priority
?
842 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 750 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
Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

 

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

752 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