We can then use this information for performance analysis, and maybe even implement dashboard capabilities with graphics using rrdtools. How to set up statspack on oracle 9i, 10g or even 11g. Download oracle statspack report analyzer for free. Both awr and ash require an oracle diagnostics pack license which is limited to the enterprise edition of the database. We will use an actual statspack report from our own oracle 10g system. Installing and configuring statspack aerostitch tips. Hi, is there a way to install statspack in oracle 10g xe and monitor a remote database 10g enterprise edition. Yes, even if a lot of people forget it, the oracle diagnostics pack license is necessary to use the awr and ash tools. During installation, you are prompted for the perfstat users password, default tablespace, and temporary. Oracle 10g free download from softvela, having many updates through which you can make simple to advance and secure databases. Although awr and addm introduced in oracle 10g provide better. The first step in the installation is the creation of the perfstat user, which owns all plsql code and database objects created, including the statspack tables, constraints, and the statspack package.
Statspack stores the performance statistics permanently in oracle tables, which can later be used for reporting and analysis. Because of the version differences, we will break this section into one for pre8. This software is one of the oldest and more trusted for advance and complex databases. Hence, be sure you run it from sqlplus and do not try to run it in svrmgrl or sqlworksheet. This tool can parse the oracle statspack flat file report, create tables with sp content in html format. Oracle statspack installation steps burleson consulting. When we run the statspack installation script, the perfstat user is. Level 10, this level includes capturing child latch statistics, along with. Download orace 10g iso for free which is completely compitbale with 32 bit as well 64 bit operating system. Ill discuss in another article how to clean up a messy statspack. Also, note that the statspack install script contains sqlplus commands.