Wednesday, 14 August 2013

Fix-ORA-01432: public synonym to be dropped does not exist.


First drop the existing Perfstat user before running the spcreate again.

There should be a script called spdrop.sql which would do this for you.


Then run spcreate to create the statspack environment.


once created login to perfstat and run the execute statspack.snap at different intervals and run spreport to see the statspack report.

No comments:

Post a Comment