Slow performance while searching con$

Hi People,
Getting very slow performance during inserts and drop tables (even empty, truncated and recreated ones!).
Drop tables usually take 5 - 10 seconds. The server is a quad processor, w2k with heaps of ram and running on local disks.

Oracle 8.1.7.x usually hangs on a select from con$ and cdef$...

eg. Insert hangs on this

SELECT c.NAME, u.NAME
  FROM con$ c, cdef$ cd, user$ u
 WHERE c.con# = cd.con# AND cd.enabled = :1 AND c.owner# = u.user#

Has anyone seen this before ?

Please be kind =o)

Thanks Received on Tue Feb 24 2004 - 04:17:19 CST