Re: How long should statspack.snap take to run?

You can try to gather statistics on SYS schema exec DBMS_STATS.GATHER_SCHEMA_STATS('SYS');

If that doesn't help try to delete statistics on that schema: exec DBMS_STATS.DELETE_SCHEMA_STATS('SYS');

Since you are using 9i there shouldn't be any serious problems unless applications itself rely on dictionary views or sys tables.

You might notice some performance changes with tools used to monitor database (TOAD etc.) or utilities (exp for example) after changes mentioned above. Received on Sat Jul 15 2006 - 09:34:56 CDT