Statspack 삭제

스냅샷 목록 확인

select snap_id, snap_time from stats$snapshot;

 

PERFSTAT 계정 확인

Select * from dba_users where username='PERFSTAT';

 

job 확인

Select * from dba_jobs;

 

오라클 홈이 없으면 path에 등록이 되어있으므로 확인

Windows : path/rdbms/admin

Linux : $ORACLE_HOME/rdbms/admin

 

- spcreate.sql : statspack 설치

- spauto.sql : 스케쥴링 (job 등록)

- spdrop.sql : statspack 삭제

---

statspack 삭제

cd $ORACLE_HOME/rdbms/admin 접속

sqlplus / as sysdba 접속

 

linesize, pagesize 설정

SQL> set linesize 300
SQL> set pagesize 300

 

SID 에 맞게 잘 접속됐는지 확인

SQL> select instance_name from v$instance;

 

job 삭제 후 statspack 삭제

job 삭제 (perfstat 계정으로 접속) 

SQL> conn perfstat/perfstat

 

EXEC DBMS_JOB.REMOVE(job number);

SQL> EXEC DBMS_JOB.REMOVE(21);
SQL> EXEC DBMS_JOB.REMOVE(41);
SQL> commit;

SQL> alter user perfstat account unlock;

User altered.

SQL> conn perfstat/Rlaehdus1_
Connected.
SQL> EXEC DBMS_JOB.REMOVE(21);

PL/SQL procedure successfully completed.

SQL> EXEC DBMS_JOB.REMOVE(41);

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

 

job 확인

Select * from dba_jobs;

아무것도 없으면 삭제 완료

 

statspack 삭제 (sys로 접속)

spdrop.sql 로 삭제

SQL> @spdrop.sql

 

계정 삭제 확인

Select * from dba_users where username='PERFSTAT';

perfstat 계정이 없으면 삭제 완료