You are currently browsing the tag archive for the ‘statspack’ tag.

This article is about Oracle Statspack. We are going to learn How We can Install and what is Oracle Statspack?

Statspack is a performance tuning tool provided by Oracle with the Oracle9i database distribution. With minimal effort, it can be installed on any Oracle9i database to rapidly gather detailed analysis of the performance of that database instance.

So What is Oracle Statspack?

The 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 perennially 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.

Read the rest of this entry »

If you want to use some different reports such as AWR; ASH etc. you may prefer to use the statspack report in Oracle Database.

STATSPACK is a performance diagnosis tool, available since Oracle8i. STATSPACK can be considered BSTAT/ESTAT’s successor, incorporating many new features. STATSPACK is a diagnosis tool for instance-wide performance problems; it also supports application tuning activities by providing data which identifies high-load SQL statements. STATSPACK can be used both proactively to monitor the changing load on a system, and also reactively to investigate a performance problem.

Here are some notes which you can get details about the Statspack report.

How to Identify Resource Intensive SQL for Tuning  Doc ID:232443.1
FAQ- Statspack Complete Reference  Doc ID:94224.1
TROUBLESHOOTING: Possible Causes of Poor SQL Performance    Doc ID:    33089.1

Installing and Configuring StatsPack Package [ID 149113.1]
FAQ- Statspack Complete Reference [ID 94224.1]
Creating a StatsPack performance report [ID 149124.1]
How To Understand AWR Report / Statspack Report [ID 842884.1]
What is StatsPack and where are the READMEs? [ID 149115.1]
Systemwide Tuning using STATSPACK Reports [ID 228913.1]
Oracle Applications and StatsPack [ID 153507.1]
Oracle9i Database Performance Tuning Guide and Reference-Using statspack
http://www.oracle-base.com/articles/8i/Statspack8i.php
How to Identify Resource Intensive SQL for Tuning  Doc ID:232443.1
TROUBLESHOOTING: Possible Causes of Poor SQL Performance Doc ID:33089.1

 

As you know We already on 18c version, but I still see some questions which are related performance issues and how We can use Statpack reports.

Its available since  Oracle 8i, I want to share some Metalink documents which covers what is Statspack report, How We can install&run and read it, Purpose of usage Statspack reports

Read the rest of this entry »