Re: Accessing table list in GUI envorinment suddenly slow

I'm relatively new to Oracle. Can you give me some pointers on how to trace the session?

"Dave" <x_at_x.com> wrote:

>
>"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 - 11:32:11 CST