STATSPARK工具练习(上)

 

可以参考（Statspack-v3.0.pdf）

 

-------------------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~------------