Using Statspack

link
http://download.oracle.com/docs/cd/B10501_01/server.920/a96533/statspac.htm#34837

create tablespace perfstat
datafile '/u02/oradata/PROD/perfstat.dbf' size 100m autoextend on maxsize 300m
extent management local uniform size 1m
segment space management auto

@?/rdbms/admin/spcreate.sql

execute statspack.snap

@?/rdbms/admin/spreport.sql

@?/rdbms/admin/spdrop.sql

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License