- 论坛徽章:
- 0
|
请教！
|
What is StatsPack and how does STATSPACK work? --------------------------------------------- Statspack is a set of SQL, PL/SQL and SQL*Plus scripts which allow the collection, automation, storage and viewing of performance data. A user is automatically created by the installation script - this user, PERFSTAT, owns all objects needed by this package. This user is granted limited query-only privileges on the V$views required for performance tuning. Statspack fundamentally differs from the well known UTLBSTAT/UTLESTAT tuning scripts by collecting more information, and also by storing the performance statistics data permanently in Oracle tables, which can later be used for reporting and analysis. The data collected can be analyzed using the report provided, which includes an "instance health and load" summary page, high resource SQL statements, as well as the traditional wait events and initialization parameters. Where are StatsPack README files? --------------------------------- StatsPack README files include more specific and up to date information and history about this tool as well as platform and release specific information that help on installing and using the product. These files are located at: UNIX: Oracle8i 8.1.6 $ORACLE_HOME/rdbms/admin/statspack.doc Oracle8i 8.1.7 and Oracle9i 9.x $ORACLE_HOME/rdbms/admin/spdoc.txt NT: Oracle8i 8.1.6 %ORACLE_HOME%\rdbms\admin\statspack.doc Oracle8i 8.1.7 and Oracle9i 9.x %ORACLE_HOME%\rdbms\admin\spdoc.txt VMS: Oracle8i 8.1.7 For Oracle8i 8.1.7.0.0, to get the README file, please contact Oracle Support Services, and request patch for bug: [BUG] - MISSING STATSPACK FILES FOR ALPHA OPENVMS 8.1.7.0.0 Oracle9i 9.x ORA_ROOT:[RDBMS.ADMIN]SPDOC.TXT OS/390: Oracle8i 8.1.7 For Oracle8i 8.1.7.0.0 the SPDOC.TXT file is missing. This was resolved in the 8.1.7.1 patchset. [BUG] - STATSPACK DOCUMENTATION NOT SHIPPED ON OS/390 |
|
免费注册
发表于 2003-01-28 11:39
