Sam,

sorry , I kept bugging you on this since this is my first time.

here is the error message

SQL> execute statspack.snap
BEGIN statspack.snap; END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'STATSPACK.SNAP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

What I don't understand is STATSPACK.SNAP is not existed in
%ORACLE_HOME%\rdbms\admin\

so where is this procedures located ???