生成SP报告
创建statspack存储数据的表空间
SQL> create tablespace sp datafile '/u01/oradata/test1/sp01.dbf' size 200m;
SQL> select file_name from dba_data_files;
FILE_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/oradata/test1/test1.dbf
/u01/oradata/test1/system01.dbf
/u01/oradata/test1/smrtbs.dbf
/u01/oradata/test1/tbs1.dbf
/u01/oradata/test1/users01.dbf
/u01/oradata/test1/sysaux01.dbf
/u01/oradata/test1/rtbs01.dbf
/u01/oradata/test1/index01.dbf
/u01/oradata/test1/test2.dbf
/u01/oradata/test1/sp01.dbf
10 rows selected.
运行statspack安装脚本。默认位置在$oracle_home\rdbms\admin\spcreate.sql
SQL> @?/rdbms/admin/spcreate.sql
输入 perfstat_password 的值: perfstat
..........
输入 default_tablespace 的值: sp
..........
输入 temporary_tablespace 的值: temp
安装完之后 会自动切换用户到perfstat下：
SQL> show user
USER is "PERFSTAT"
产生快照，默认5级
SQL> exec statspack.snap
PL/SQL procedure successfully completed.
SQL> desc statspack
FUNCTION CLEAR_BASELINE RETURNS NUMBER(38)
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_BEGIN_SNAP NUMBER IN
I_END_SNAP NUMBER IN
I_SNAP_RANGE BOOLEAN IN DEFAULT
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
PROCEDURE CLEAR_BASELINE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_BEGIN_SNAP NUMBER IN
I_END_SNAP NUMBER IN
I_SNAP_RANGE BOOLEAN IN DEFAULT
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
FUNCTION CLEAR_BASELINE RETURNS NUMBER(38)
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_BEGIN_DATE DATE IN
I_END_DATE DATE IN
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
PROCEDURE CLEAR_BASELINE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_BEGIN_DATE DATE IN
I_END_DATE DATE IN
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
FUNCTION GET_SNAP_ID RETURNS NUMBER(38)
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_SNAP_TIME DATE IN
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
FUNCTION MAKE_BASELINE RETURNS NUMBER(38)
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_BEGIN_SNAP NUMBER IN
I_END_SNAP NUMBER IN
I_SNAP_RANGE BOOLEAN IN DEFAULT
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
PROCEDURE MAKE_BASELINE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_BEGIN_SNAP NUMBER IN
I_END_SNAP NUMBER IN
I_SNAP_RANGE BOOLEAN IN DEFAULT
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
FUNCTION MAKE_BASELINE RETURNS NUMBER(38)
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_BEGIN_DATE DATE IN
I_END_DATE DATE IN
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
PROCEDURE MAKE_BASELINE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_BEGIN_DATE DATE IN
I_END_DATE DATE IN
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
PROCEDURE MODIFY_STATSPACK_PARAMETER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
I_SNAP_LEVEL NUMBER IN DEFAULT
I_SESSION_ID NUMBER IN DEFAULT
I_UCOMMENT VARCHAR2 IN DEFAULT
I_NUM_SQL NUMBER IN DEFAULT
I_EXECUTIONS_TH NUMBER IN DEFAULT
I_PARSE_CALLS_TH NUMBER IN DEFAULT
I_DISK_READS_TH NUMBER IN DEFAULT
I_BUFFER_GETS_TH NUMBER IN DEFAULT
I_SHARABLE_MEM_TH NUMBER IN DEFAULT
I_VERSION_COUNT_TH NUMBER IN DEFAULT
I_SEG_PHY_READS_TH NUMBER IN DEFAULT
I_SEG_LOG_READS_TH NUMBER IN DEFAULT
I_SEG_BUFF_BUSY_TH NUMBER IN DEFAULT
I_SEG_ROWLOCK_W_TH NUMBER IN DEFAULT
I_SEG_ITL_WAITS_TH NUMBER IN DEFAULT
I_SEG_CR_BKS_RC_TH NUMBER IN DEFAULT
I_SEG_CU_BKS_RC_TH NUMBER IN DEFAULT
I_ALL_INIT VARCHAR2 IN DEFAULT
I_OLD_SQL_CAPTURE_MTH VARCHAR2 IN DEFAULT
I_PIN_STATSPACK VARCHAR2 IN DEFAULT
I_MODIFY_PARAMETER VARCHAR2 IN DEFAULT
FUNCTION PURGE RETURNS NUMBER(38)
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_BEGIN_SNAP NUMBER IN
I_END_SNAP NUMBER IN
I_SNAP_RANGE BOOLEAN IN DEFAULT
I_EXTENDED_PURGE BOOLEAN IN DEFAULT
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
PROCEDURE PURGE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_BEGIN_SNAP NUMBER IN
I_END_SNAP NUMBER IN
I_SNAP_RANGE BOOLEAN IN DEFAULT
I_EXTENDED_PURGE BOOLEAN IN DEFAULT
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
FUNCTION PURGE RETURNS NUMBER(38)
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_BEGIN_DATE DATE IN
I_END_DATE DATE IN
I_EXTENDED_PURGE BOOLEAN IN DEFAULT
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
PROCEDURE PURGE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_BEGIN_DATE DATE IN
I_END_DATE DATE IN
I_EXTENDED_PURGE BOOLEAN IN DEFAULT
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
FUNCTION PURGE RETURNS NUMBER(38)
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_PURGE_BEFORE_DATE DATE IN
I_EXTENDED_PURGE BOOLEAN IN DEFAULT
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
PROCEDURE PURGE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_PURGE_BEFORE_DATE DATE IN
I_EXTENDED_PURGE BOOLEAN IN DEFAULT
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
FUNCTION PURGE RETURNS NUMBER(38)
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_NUM_DAYS NUMBER IN
I_EXTENDED_PURGE BOOLEAN IN DEFAULT
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
PROCEDURE PURGE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_NUM_DAYS NUMBER IN
I_EXTENDED_PURGE BOOLEAN IN DEFAULT
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
PROCEDURE QAM_STATSPACK_PARAMETER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
I_SNAP_LEVEL NUMBER IN DEFAULT
I_SESSION_ID NUMBER IN DEFAULT
I_UCOMMENT VARCHAR2 IN DEFAULT
I_NUM_SQL NUMBER IN DEFAULT
I_EXECUTIONS_TH NUMBER IN DEFAULT
I_PARSE_CALLS_TH NUMBER IN DEFAULT
I_DISK_READS_TH NUMBER IN DEFAULT
I_BUFFER_GETS_TH NUMBER IN DEFAULT
I_SHARABLE_MEM_TH NUMBER IN DEFAULT
I_VERSION_COUNT_TH NUMBER IN DEFAULT
I_SEG_PHY_READS_TH NUMBER IN DEFAULT
I_SEG_LOG_READS_TH NUMBER IN DEFAULT
I_SEG_BUFF_BUSY_TH NUMBER IN DEFAULT
I_SEG_ROWLOCK_W_TH NUMBER IN DEFAULT
I_SEG_ITL_WAITS_TH NUMBER IN DEFAULT
I_SEG_CR_BKS_RC_TH NUMBER IN DEFAULT
I_SEG_CU_BKS_RC_TH NUMBER IN DEFAULT
I_ALL_INIT VARCHAR2 IN DEFAULT
I_OLD_SQL_CAPTURE_MTH VARCHAR2 IN DEFAULT
I_PIN_STATSPACK VARCHAR2 IN DEFAULT
I_MODIFY_PARAMETER VARCHAR2 IN DEFAULT
O_SNAP_LEVEL NUMBER OUT
O_SESSION_ID NUMBER OUT
O_UCOMMENT VARCHAR2 OUT
O_NUM_SQL NUMBER OUT
O_EXECUTIONS_TH NUMBER OUT
O_PARSE_CALLS_TH NUMBER OUT
O_DISK_READS_TH NUMBER OUT
O_BUFFER_GETS_TH NUMBER OUT
O_SHARABLE_MEM_TH NUMBER OUT
O_VERSION_COUNT_TH NUMBER OUT
O_SEG_PHY_READS_TH NUMBER OUT
O_SEG_LOG_READS_TH NUMBER OUT
O_SEG_BUFF_BUSY_TH NUMBER OUT
O_SEG_ROWLOCK_W_TH NUMBER OUT
O_SEG_ITL_WAITS_TH NUMBER OUT
O_SEG_CR_BKS_RC_TH NUMBER OUT
O_SEG_CU_BKS_RC_TH NUMBER OUT
O_ALL_INIT VARCHAR2 OUT
O_OLD_SQL_CAPTURE_MTH VARCHAR2 OUT
O_PIN_STATSPACK VARCHAR2 OUT
PROCEDURE SNAP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_SNAP_LEVEL NUMBER IN DEFAULT
I_SESSION_ID NUMBER IN DEFAULT
I_UCOMMENT VARCHAR2 IN DEFAULT
I_NUM_SQL NUMBER IN DEFAULT
I_EXECUTIONS_TH NUMBER IN DEFAULT
I_PARSE_CALLS_TH NUMBER IN DEFAULT
I_DISK_READS_TH NUMBER IN DEFAULT
I_BUFFER_GETS_TH NUMBER IN DEFAULT
I_SHARABLE_MEM_TH NUMBER IN DEFAULT
I_VERSION_COUNT_TH NUMBER IN DEFAULT
I_SEG_PHY_READS_TH NUMBER IN DEFAULT
I_SEG_LOG_READS_TH NUMBER IN DEFAULT
I_SEG_BUFF_BUSY_TH NUMBER IN DEFAULT
I_SEG_ROWLOCK_W_TH NUMBER IN DEFAULT
I_SEG_ITL_WAITS_TH NUMBER IN DEFAULT
I_SEG_CR_BKS_RC_TH NUMBER IN DEFAULT
I_SEG_CU_BKS_RC_TH NUMBER IN DEFAULT
I_ALL_INIT VARCHAR2 IN DEFAULT
I_OLD_SQL_CAPTURE_MTH VARCHAR2 IN DEFAULT
I_PIN_STATSPACK VARCHAR2 IN DEFAULT
I_MODIFY_PARAMETER VARCHAR2 IN DEFAULT
FUNCTION SNAP RETURNS NUMBER(38)
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_SNAP_LEVEL NUMBER IN DEFAULT
I_SESSION_ID NUMBER IN DEFAULT
I_UCOMMENT VARCHAR2 IN DEFAULT
I_NUM_SQL NUMBER IN DEFAULT
I_EXECUTIONS_TH NUMBER IN DEFAULT
I_PARSE_CALLS_TH NUMBER IN DEFAULT
I_DISK_READS_TH NUMBER IN DEFAULT
I_BUFFER_GETS_TH NUMBER IN DEFAULT
I_SHARABLE_MEM_TH NUMBER IN DEFAULT
I_VERSION_COUNT_TH NUMBER IN DEFAULT
I_SEG_PHY_READS_TH NUMBER IN DEFAULT
I_SEG_LOG_READS_TH NUMBER IN DEFAULT
I_SEG_BUFF_BUSY_TH NUMBER IN DEFAULT
I_SEG_ROWLOCK_W_TH NUMBER IN DEFAULT
I_SEG_ITL_WAITS_TH NUMBER IN DEFAULT
I_SEG_CR_BKS_RC_TH NUMBER IN DEFAULT
I_SEG_CU_BKS_RC_TH NUMBER IN DEFAULT
I_ALL_INIT VARCHAR2 IN DEFAULT
I_OLD_SQL_CAPTURE_MTH VARCHAR2 IN DEFAULT
I_PIN_STATSPACK VARCHAR2 IN DEFAULT
I_MODIFY_PARAMETER VARCHAR2 IN DEFAULT
PROCEDURE STAT_CHANGES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
BID NUMBER IN
EID NUMBER IN
DB_IDENT NUMBER IN
INST_NUM NUMBER IN
PARALLEL VARCHAR2 IN
LHTR NUMBER OUT
BFWT NUMBER OUT
TRAN NUMBER OUT
CHNG NUMBER OUT
UCAL NUMBER OUT
UROL NUMBER OUT
RSIZ NUMBER OUT
PHYR NUMBER OUT
PHYRD NUMBER OUT
PHYRDL NUMBER OUT
PHYRC NUMBER OUT
PHYW NUMBER OUT
UCOM NUMBER OUT
PRSE NUMBER OUT
HPRSE NUMBER OUT
RECR NUMBER OUT
GETS NUMBER OUT
SLR NUMBER OUT
RLSR NUMBER OUT
RENT NUMBER OUT
SRTM NUMBER OUT
SRTD NUMBER OUT
SRTR NUMBER OUT
STRN NUMBER OUT
LHR NUMBER OUT
BBC VARCHAR2 OUT
EBC VARCHAR2 OUT
BSP VARCHAR2 OUT
ESP VARCHAR2 OUT
BLB VARCHAR2 OUT
BS VARCHAR2 OUT
TWT NUMBER OUT
LOGC NUMBER OUT
PRSCPU NUMBER OUT
TCPU NUMBER OUT
EXE NUMBER OUT
PRSELA NUMBER OUT
BSPM NUMBER OUT
ESPM NUMBER OUT
BFRM NUMBER OUT
EFRM NUMBER OUT
BLOG NUMBER OUT
ELOG NUMBER OUT
BOCUR NUMBER OUT
EOCUR NUMBER OUT
BPGAALLOC NUMBER OUT
EPGAALLOC NUMBER OUT
BSGAALLOC NUMBER OUT
ESGAALLOC NUMBER OUT
BNPROCS NUMBER OUT
ENPROCS NUMBER OUT
TIMSTAT VARCHAR2 OUT
STATLVL VARCHAR2 OUT
BNCPU NUMBER OUT
ENCPU NUMBER OUT
BPMEM NUMBER OUT
EPMEM NUMBER OUT
BLOD NUMBER OUT
ELOD NUMBER OUT
ITIC NUMBER OUT
BTIC NUMBER OUT
IOTIC NUMBER OUT
RWTIC NUMBER OUT
UTIC NUMBER OUT
STIC NUMBER OUT
VMIB NUMBER OUT
VMOB NUMBER OUT
OSCPUW NUMBER OUT
DBTIM NUMBER OUT
DBCPU NUMBER OUT
BGELA NUMBER OUT
BGCPU NUMBER OUT
PRSTELA NUMBER OUT
SQLEELA NUMBER OUT
CONMELA NUMBER OUT
DMSD NUMBER OUT
DMFC NUMBER OUT
DMSI NUMBER OUT
PMRV NUMBER OUT
PMPT NUMBER OUT
NPMRV NUMBER OUT
NPMPT NUMBER OUT
DBFR NUMBER OUT
DPMS NUMBER OUT
DNPMS NUMBER OUT
GLSG NUMBER OUT
GLAG NUMBER OUT
GLGT NUMBER OUT
GCCRRV NUMBER OUT
GCCRRT NUMBER OUT
GCCRFL NUMBER OUT
GCCURV NUMBER OUT
GCCURT NUMBER OUT
GCCUFL NUMBER OUT
GCCRSV NUMBER OUT
GCCRBT NUMBER OUT
GCCRFT NUMBER OUT
GCCRST NUMBER OUT
GCCUSV NUMBER OUT
GCCUPT NUMBER OUT
GCCUFT NUMBER OUT
GCCUST NUMBER OUT
MSGSQ NUMBER OUT
MSGSQT NUMBER OUT
MSGSQK NUMBER OUT
MSGSQTK NUMBER OUT
MSGRQ NUMBER OUT
MSGRQT NUMBER OUT
PROCEDURE VERIFY_DBID_INSTANCE_NUMBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
PROCEDURE VERIFY_SNAP_ID
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
I_SNAP_ID NUMBER IN
I_DBID NUMBER IN DEFAULT
I_INSTANCE_NUMBER NUMBER IN DEFAULT
修改以后产生的快照默认级别为7级
SQL> exec statspack.MODIFY_STATSPACK_PARAMETER(I_SNAP_LEVEL=>7);
PL/SQL procedure successfully completed.
执行每小时定时任务快照脚本
SQL> @?/rdbms/admin/spauto.sql
SQL> Rem
SQL> Rem $Header: spauto.sql 16-feb-00.16:49:37 cdialeri Exp $
SQL> Rem
SQL> Rem spauto.sql
SQL> Rem
SQL> Rem Copyright (c) Oracle Corporation 1999, 2000. All Rights Reserved.
SQL> Rem
SQL> Rem NAME
SQL> Rem spauto.sql
SQL> Rem
SQL> Rem DESCRIPTION
SQL> Rem SQL*PLUS command file to automate the collection of STATPACK
SQL> Rem statistics.
SQL> Rem
SQL> Rem NOTES
SQL> Rem Should be run as the STATSPACK owner, PERFSTAT.
SQL> Rem Requires job_queue_processes init.ora parameter to be
SQL> Rem set to a number >0 before automatic statistics gathering
SQL> Rem will run.
SQL> Rem
SQL> Rem MODIFIED (MM/DD/YY)
SQL> Rem cdialeri 02/16/00 - 1191805
SQL> Rem cdialeri 12/06/99 - 1059172, 1103031
SQL> Rem cdialeri 08/13/99 - Created
SQL> Rem
SQL>
SQL>
SQL> spool spauto.lis
SQL>
SQL> --
SQL> -- Schedule a snapshot to be run on this instance every hour, on the hour
SQL>
SQL> variable jobno number;
SQL> variable instno number;
SQL> begin
2 select instance_number into :instno from v$instance;
3 dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno);
4 commit;
5 end;
6 /
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL> prompt
SQL> prompt Job number for automated statistics collection for this instance
Job number for automated statistics collection for this instance
SQL> prompt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SQL> prompt Note that this job number is needed when modifying or removing
Note that this job number is needed when modifying or removing
SQL> prompt the job:
the job:
SQL> print jobno
JOBNO
----------
1
SQL>
SQL> prompt
SQL> prompt Job queue process
Job queue process
SQL> prompt ~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~
SQL> prompt Below is the current setting of the job_queue_processes init.ora
Below is the current setting of the job_queue_processes init.ora
SQL> prompt parameter - the value for this parameter must be greater
parameter - the value for this parameter must be greater
SQL> prompt than 0 to use automatic statistics gathering:
than 0 to use automatic statistics gathering:
SQL> show parameter job_queue_processes
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 0
SQL> prompt
SQL>
SQL> prompt
SQL> prompt Next scheduled run
Next scheduled run
SQL> prompt ~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~
SQL> prompt The next scheduled run for this job is:
The next scheduled run for this job is:
SQL> select job, next_date, next_sec
2 from user_jobs
3 where job = :jobno;
JOB NEXT_DATE NEXT_SEC
---------- ------------------- ----------------
1 2012-06-22 05:00:00 05:00:00
1 row selected.
SQL> spool off;
SQL> exec statspack.snap
PL/SQL procedure successfully completed.
设定任意两个快照，产生这段时间内的性能分析报告
SQL> @?/rdbms/admin/spreport.sql
表示当前有行迁移发生
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
table fetch continued row 47 0.0 15.7
Instance Activity Stats for DB
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
table fetch continued row 109,919 30.6 16.7 回滚段统计
Tablespace IO Stats for DB
File IO Stats for DB
检查IO分布是否在同一块盘上，如果不是，就需要做条带。如果是需检查磁盘阵列。
Buffer Pool Statistics for DB
Buffer Pool Advisory for DB
Rollback Segment Stats for DB
Latch Activity for DB 栓（内存锁）活动情况
Latch Sleep breakdown for DB 访问内存发生等待
Latch Miss Sources for DB 请求一次请求不到数据
下面的数据很多都与内存缓冲区相关
Latch Name Where Misses Sleeps Sleeps
------------------------ -------------------------- ------- ---------- --------
cache buffers chains kcbgtcr: kslbegin excl 0 13 15
cache buffers chains kcbrls: kslbegin 0 6 0
cache buffers chains kcbzib: multi-block read: 0 3 0
cache buffers chains kcbgtcr: fast path 0 1 4
cache buffers chains kcbzib: finish free bufs 0 1 3
cache buffers lru chain kcbzgb: wait 0 156 89
cache buffers lru chain kcbzar: KSLNBEGIN 0 39 144
cache buffers lru chain kcbbiop: lru scan 0 28 0
cache buffers lru chain kcbbxsv: move to being wri 0 10 0
cache buffers lru chain kcbzgm 0 3 1
SQL> @?/rdbms/admin/spdrop.sql
......
NOTE:
SPDTAB complete. Please check spdtab.lis for any errors.
SQL>
SQL>
SQL> --
SQL> -- Drop PERFSTAT user
SQL>
SQL> @@spdusr
SQL> Rem
SQL> Rem $Header: spdusr.sql 27-may-2005.11:05:21 cdgreen Exp $
SQL> Rem
SQL> Rem spdusr.sql
SQL> Rem
SQL> Rem Copyright (c) 1999, 2005, Oracle. All rights reserved.
SQL> Rem
SQL> Rem NAME
SQL> Rem spdusr.sql
SQL> Rem
SQL> Rem DESCRIPTION
SQL> Rem SQL*Plus command file to DROP user which contains the
SQL> Rem STATSPACK database objects.
SQL> Rem
SQL> Rem NOTES
SQL> Rem Must be run when connected to SYS (or internal)
SQL> Rem
SQL> Rem MODIFIED (MM/DD/YY)
SQL> Rem cdgreen 05/24/05 - 4246955
SQL> Rem cdialeri 11/07/03 - 10g - streams - rventkate
SQL> Rem cdialeri 04/23/01 - 9.0
SQL> Rem cdialeri 09/12/00 - sp_1404195
SQL> Rem cdialeri 04/07/00 - 1261813
SQL> Rem cdialeri 02/16/00 - 1191805
SQL> Rem cdialeri 11/04/99 - 1059172
SQL> Rem cdialeri 08/13/99 - Created
SQL> Rem
SQL>
SQL> set echo off;
......
NOTE:
SPDUSR complete. Please check spdusr.lis for any errors.