Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Apr 23, 2004

Exploring the Oracle Database 10g Wait Interface

By DatabaseJournal.com Staff

[From Oracle Technology Network]

With the new and enhanced wait interfaces built into the Oracle kernel, DBAs who choose to explore beyond 10g's performance-tuning recommendations should be able to more quickly get to the bottom of performance issues

In the pursuit of optimal database performance, Oracle professionals have been slowly migrating away from performance analysis techniques that focused on blanket system ratios to a methodology that instead zeros in on where a system, application, or session is spending its time. Referred to as wait-based analysis or bottleneck analysis, its goal is to uncover the true nature of performance degradation by determining the exact causes of throughput hindrances.

The wait interface of Oracle was introduced many versions ago, and with each new release, Oracle has added enhancements to the wait interface that helps DBAs better understand where database bottlenecks are occurring. Oracle Database 10g is no exception, and in fact, it offers perhaps the most impressive set of new additions to the wait interface ever. 10g also provides a new built-in diagnostic monitor (ADDM) and other tools that survey, among other things, how wait events affect SQL performance and more.

The article continues at http://otn.oracle.com/pub/articles/schumacher_10gwait.html

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM