Re: 10g Enterprise Manager
From: Oliver Zeigermann <oliver_at_zeigermann.de>
Date: Fri, 11 Jun 2004 20:32:26 +0200
Message-ID: <cactre$qil$03$1_at_news.t-online.com>
>> I have a problem that requires me to inspect all active sessions,
>> transactions and locks. However, with the web bases 10g enterprise
>> mananger I do not seem to get the right information together. The only
>> thing I have found are information about most active statements.
>>
>> What I would like to know is:
>> a) Is there a way to get what I want with the 10g EM?
>> b) Is there another (free) tool that allows me to get the wanted
>> information?
>>
>> Cheers and thanks in advance,
>>
>> Oliver
Date: Fri, 11 Jun 2004 20:32:26 +0200
Message-ID: <cactre$qil$03$1_at_news.t-online.com>
[Quoted] Daniel Morgan wrote:
> Oliver Zeigermann wrote: >
>> I have a problem that requires me to inspect all active sessions,
>> transactions and locks. However, with the web bases 10g enterprise
>> mananger I do not seem to get the right information together. The only
>> thing I have found are information about most active statements.
>>
>> What I would like to know is:
>> a) Is there a way to get what I want with the 10g EM?
>> b) Is there another (free) tool that allows me to get the wanted
>> information?
>>
>> Cheers and thanks in advance,
>>
>> Oliver
> > > SQL*Plus and get it from the v$ views. >
I am no Oracle expert, I guess these are some sort of system views displaying internal information, right? I will check this out!
Thanks a lot :)
Oliver Received on Fri Jun 11 2004 - 20:32:26 CEST