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.