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
page revision: 3, last edited: 30 Apr 2009 05:02