-------------------setup Statspack-----------------------
select instance_name,host_name,version,startup_time from v$instance;
select file_name from dba_data_files;
---------create table-----------
create tablespace perfstat datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\IMDB\PERFSTAT.DBF' size 500M
extent management local;
---------temp tablespace--------
@spcreate;
---------Password:zxcvbnm----------
---------default tablespace:prefstat---------------
---------temp tablespace: temp ------------
---------execute statspack(at in a timestamp.)--------
execute statspack.snap
---------view the report------------------
@spreport
id from and to:
file name:
---------set auto run scripts(create job)----------------
---------pass~------------