< Day Day Up > 


The UTLBSTAT/UTLESTAT scripts are designed to provide a summary of Oracle activity over a reasonable period of time (>10 minutes). UTLBSTAT creates a snapshot of some of the internal Oracle dynamic performance views (V$ views). UTLESTAT creates a second snapshot of these views and reports on the differences between the two snapshots to a file called report.txt.

The UTLBSTAT/UTLESTAT scripts are shipped as standard with all Oracle releases. In Version 8.1.6 there is a new tool called STATSPACK which has improved functionality over what UTLBSTAT/UTLESTAT offer. Using STATSPACK you can collect more statistical information and store the performance statistics data permanently in Oracle tables enabling snapshot reporting.

 < Day Day Up > 

Oracle Real Application Clusters
Oracle Real Application Clusters
ISBN: 1555582885
EAN: 2147483647
Year: 2004
Pages: 174

Similar book on Amazon

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