Quote Originally Posted by davey23uk
if its stats, you can save off your current stats, generate new ones and see where things go

if it makes thing worse you can always revert to the old ones
Yeah that won't be a problem if we can identify it, next issue:

Connected to:
Oracle8i Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production

SQL> @?/rdbms/admin/spcreate
... Installing Required Packages

Package created.


Grant succeeded.

from dba_object_size
*
ERROR at line 4:
ORA-00942: table or view does not exist


Disconnected from Oracle8i Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production
What the hell? :(

I'm logged in as system, should i be in as anything else?