Re: Accessing table list in GUI envorinment suddenly slow

From: Dave <x_at_x.com>
Date: Sat, 05 Feb 2005 11:50:02 GMT
Message-ID: <Kp2Nd.7925$8B3.7678@text.news.blueyonder.co.uk>

"Don" <don_leeNO_aa_SPAM_at_telus.net> wrote in message news:8gu8015f8bq7rm1qlk0mv7felkol7fqpdn_at_4ax.com...
> Hi,
>
> We are running 9iR2 and starting yesterday, when we use Toad or other
> graphical tools ( like DBArtistan ) and click on the table list or
> procedure list ( or function list, for that matter ), it takes up to
> 10 seconds to return. Before today it used to return almost right
> away. If I run stored procs or sql statements, the system seems to be
> at its normal speed. Anyone have seen this before ?
>
> Thanks

trace the session, see what it is waiting on Received on Sat Feb 05 2005 - 05:50:02 CST