statspack性能调优

1) D:/>cd oracle/ora81/rdbms/admin
D:/oracle/ora81/RDBMS/ADMIN>sqlplus internal请输入口令:
2) alter system set timed_statistics = true;
3) select * from v$parameter  where name like 'job_queue_processes'
4) SQL> select instance_name,host_name,version,startup_time from v$instance;
5) SQL> select file_name from dba_data_files;
6) SQL> create tablespace perfstat
2 datafile 'd:/oracle/oradata/eygle/perfstat.dbf'
3 size 500M;
7) SQL> host dir stat*
8) @statscre
9) Specify PERFSTAT user's default tablespace
输入 default_tablespace 的值: perfstat
10) Specify PERFSTAT user's temporary tablespace
输入 temporary_tablespace 的值: temp
11) Enter tablespace where STATSPACKobjects whillbe created:perfstat12) @statauto 13) execute statspack.snap(i_snap_level=>10 ,i_modify_parameter=>’true’); execute statspack.snap(i_snap_level=>10 ,i_modify_parameter=>’true’); 14) @statsrep 15) Enter beginning Snap ID:
Enter ending Snap ID: Enter name of output file [st_1_2]:  16) SQL> select max(snap_id) from stats$snapshot;
SQL> delete from stats$snapshot where snap_id < = 166;
原文：http://www.itpub.net/117182.html