Re: 10g Enterprise Manager
From: Oliver Zeigermann <oliver_at_zeigermann.de>
Date: Mon, 14 Jun 2004 11:00:58 +0200
Message-ID: <2j57s1Fsvl1lU1_at_uni-berlin.de>
>> 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
Date: Mon, 14 Jun 2004 11:00:58 +0200
Message-ID: <2j57s1Fsvl1lU1_at_uni-berlin.de>
anacedent wrote:
> Oliver Zeigermann wrote: >
>> 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
> > Time to RTFM > > http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch3.htm#1109131 >
Thanks a lot for thhe pointer :)
Oliver Received on Mon Jun 14 2004 - 11:00:58 CEST