安装 statspack
SQL> create tablespace test_pace datafile '/ora10/base/oradata/tid002/test_pace01.dbf' size 250m extent management local autoallocate;
SQL> create tablespace test_pace datafile '/ora10/base/oradata/tid002/test_pace01.dbf' size 250m extent management local autoallocate;
Tablespace created.
SQL> @spcreate.sql
创建快照
SQL> EXECUTE STATSPACK.SNAP;
SQL> EXECUTE STATSPACK.SNAP;
PL/SQL procedure successfully completed.
查看快照
SQL> select SNAP_ID, SNAP_TIME from STATS$SNAPSHOT;
SQL> select SNAP_ID, SNAP_TIME from STATS$SNAPSHOT;
SNAP_ID SNAP_TIM
---------- --------
1 12-08-29
2 12-08-29
---------- --------
1 12-08-29
2 12-08-29
2 rows selected.
生成statspack 报告
SQL> @spreport.sql
End of Report ( statsport01.lst )
v$ORACLE_HOME/rdbms/admin/ statsport01.lst
SQL> @spreport.sql
End of Report ( statsport01.lst )
v$ORACLE_HOME/rdbms/admin/ statsport01.lst
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24756186/viewspace-742652/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24756186/viewspace-742652/