Oracle12c配置Statspack

Oracle12c配置Statspack

• 创建perfstat 空间

  SQL> conn sys/oracle as sysdba
  Connected.
  SQL> create tablespace perfstat
  2  datafile 'u01/app/oracle/oradata/xe/perfstat.dbf' size 500m;
  Tablespace created

• 运行脚本

  root@7485d22f2fd5:~# cd $ORACLE_HOME/rdbms/admin
  root@7485d22f2fd5:/u01/app/oracle/product/12.1.0/xe/rdbms/admin# sqlplus /nolog--突然无法直接以 as sysdab登录
  SQL*Plus: Release 12.1.0.2.0 Production on Wed Dec 20 11:10:40 2017
  
  Copyright (c) 1982, 2014, Oracle.  All rights reserved.
  
  SQL> conn sys/oracle as sysdba
  Connected.
  --运行脚本
  SQL> @spdrop 
  --出现下面语句，则成功
  SQL> set echo off;
  Creating Package STATSPACK...
  Package created.
  
  No errors.
  Creating Package Body STATSPACK...
  
  Package body created.
  
  No errors.
  
  NOTE:
  SPCPKG complete. Please check spcpkg.lis for any errors.
  --如果中间出现问题，应执行spdrop.sql 删除后重新创建

• 可以从这个文件中找出StatsPack的说明$ORACLE_HOME/rdbms/admin/spdoc.