 |
|
|
v$bh buffer contents As we have noted in Chapter 14, Oracle Insrance Tuning, the v$bh view is very useful for examining the contents of your buffers. Please make sure to see our scripts for displaying the data buffer contents with this powerful v$ view.
Conclusion The v$ dynamic views play a significant role in database monitoring and tuning processes. They serve as sources for real time estimation of current database workload and health. The Oracle10g database introduced many great improvements to data dictionary dynamic performance views.
In this chapter, information was presented that will allow the DBA to make use of such new capabilities as the wait event interface v$ views. Details were included on the active session history view called v$active_session_history as well as the valuable performance reports can run against it. The new Oracle time model approach and corresponding v$ views yield information about where the database spends its processing time. Also, database metrics were introduced as a new database statistic type.
The V$ dynamic views play significant role in database monitoring and tuning processes. They serve as sources for real time estimation of current database workload and health. Oracle10g database introduced a lot of great improvements and changes to data dictionary dynamic performance views.
The next chapter will explore the new Oracle10g metrics and how they can help in the tuning of an Oracle database.
|
|
|
