Improvements to the Wait Interface

 

Page 40

Oracle Database 10g comes with a number of new features that are designed to provide enhanced performance of the Oracle RDBMS. In this chapter we will cover these features, which include

image Improvements to the wait interface

image The Database Common Management Infrastructure

image The SQL Access Advisor

image SQL Query tuning enhancements

image Automated SGA tuning

image Object growth trending

image Self-tuning checkpointing

image Sorted hash clusters

Improvements to the Wait Interface

Oracle 10g offers a number of new and improved database views to assist you in your performance-tuning efforts. The performance-related database views that have been improved through changes include the following:

image V$EVENT_NAME

image V$SESSION

image V$SESSION_WAIT

New views include

image V$SESSION_WAIT_HISTORY

image V$SESSION_WAIT_CLASS

image V$SYSTEM_WAIT_CLASS

Also new in Oracle Database 10g are the histogram views V$EVENT_HISTOGRAM, V$TEMP_HISTOGRAM, and V$FILE_HISTOGRAM. Let's look at each of these in more detail next.

Changes to the V$EVENT_NAME View

The V$EVENT_NAME view has had two new columns added to it that allow you to aggregate wait events based on the type of wait being experienced. The WAIT_CLASS column provides a generalized class type for each event. The WAIT_CLASS# column

 


Oracle Database 10g New Features
Oracle Database 10g New Features (Osborne ORACLE Press Series)
ISBN: 0072229470
EAN: 2147483647
Year: 2006
Pages: 80

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net