Re: 10g Enterprise Manager
From: anacedent <anacedent_at_hotmail.com>
Date: Fri, 11 Jun 2004 18:26:35 -0700
Message-ID: <gZsyc.56872$tI2.44912_at_fed1read07>
>> 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.
>>
Time to RTFM
Date: Fri, 11 Jun 2004 18:26:35 -0700
Message-ID: <gZsyc.56872$tI2.44912_at_fed1read07>
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 Received on Sat Jun 12 2004 - 03:26:35 CEST