Oracle Statspack package – is a set of performance monitoring and reporting utilities

Oracle_logoThe Oracle Statspack package is a set of SQL, PL/SQL, and SQL*Plus scripts that allow the collection, automation, storage, and viewing of performance data. Statspack stores the performance statistics permanently in Oracle tables, which can later be used for reporting and analysis. The data collected can be analyzed using Statspack reports, which includes an instance health and load summary page, high resource SQL statements, and the traditional wait events and initialization Parameters

Oracle_Statspack_01

Leave a Reply

You must be logged in to post a comment.