|
-
EDIT: Ignore what I said before, wasn't running as sys.
I've installed statspack but got an error part way through the install and had to manually install parts 2 and 3, now I get this at the end of a statspack run:
SQL> exec statspack.snap;
BEGIN statspack.snap; END;
*
ERROR at line 1:
ORA-06564: object PERFSTAT.STATSPACK does not exist
ORA-06512: at "SYS.DBMS_UTILITY", line 68
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 45
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53
ORA-06512: at "SYS.STATSPACK", line 1764
ORA-06512: at line 1
Double edit I have reinstalled statspack and it now seems to be snapping, but it's taking forever and slowing my database the hell down :(
Hopefully i won't have to run this every 10 minutes. Lets see if it completes + dumps data.
Last edited by Winkie; 12-14-2006 at 11:07 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|