Re: Slow performance while searching con$

From: Stephan Bressler <sbresslerx_no_spam_at_arcor.de>
Date: Tue, 24 Feb 2004 11:22:50 +0100
Message-ID: <c1f8kv$mhu$1@news.mch.sbs.de>

Nexio wrote:

> 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#
Hi,
what do you mean by "hang"? Is the session still doing logical reads? I assume so.
Did you analyze the sys schema?
If not, check the v$session_wait view for this session.

Regards
Stephan Received on Tue Feb 24 2004 - 04:22:50 CST