請教！

swz_19981018

statspack是什么東東？如何作個statspack？

gototop

oracle提供的性能診斷工具，書店有一本專門的書賣。

yikaikai

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

swz_19981018

swz_19981018

我怎么能得到這本書或者得到這個軟件，謝謝！