oracle statspack学习（一）(七)
nable statistics.
. . exporting table STATS$SQL_STATISTICS 1 rows exported
. . exporting table STATS$SQL_SUMMARY 71 rows exported
. . exporting table STATS$SQL_WORKAREA_HISTOGRAM 8 rows exported
. . exporting table STATS$STATSPACK_PARAMETER 1 rows exported
. . exporting table STATS$STREAMS_APPLY_SUM 0 rows exported
. . exporting table STATS$STREAMS_CAPTURE 0 rows exported
. . exporting table STATS$STREAMS_POOL_ADVICE 0 rows exported
. . exporting table STATS$SYSSTAT 679 rows exported
. . exporting table STATS$SYSTEM_EVENT 71 rows exported
. . exporting table STATS$SYS_TIME_MODEL 19 rows exported
. . exporting table STATS$TEMPSTATXS 1 rows exported
. . exporting table STATS$TEMP_SQLSTATS
. . exporting table STATS$THREAD 1 rows exported
. . exporting table STATS$TIME_MODEL_STATNAME 19 rows exported
. . exporting table STATS$UNDOSTAT 14 rows exported
. . exporting table STATS$WAITSTAT 18 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings.
[oracle@oracle-one admin]$
从这里，可以看到了很多关于report的表
9）对单独sql hast值进行生成sql报告
statspack提供了sprepsql.sql脚本
10）删除statspack
提供了一个删除脚本为：
SQL> @ /rdbms/admin/spdrop.sql
Synonym dropped.
Sequence dropped.
Synonym dropped.
Table dropped.
Synonym dropped.
Table dropped.
Synonym dropped.
。。。。。。。。。。。。。。。