在sqlplus客户端中执行语句“sqlplus perfstat/perfstat @%binPath%/setSnap.txt”
而setSnap.txt里面的内容为
EXECUTE statspack.snap;
select snap_id from stats$snapshot;
quit
可是没有创建statspack,当执行这条语句时,抛出以下异常:
BEGIN statspack.snap; END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'STATSPACK.SNAP' must be declared