Re: 10g: How to inspect active sessions, transaction, locks, etc.

sqlplus and custom script will always to the trick

On Fri, 11 Jun 2004 11:41:07 +0200, Oliver Zeigermann <oliver_at_zeigermann.de> 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?
>c) Should I install 9i again and try to non web EM?
>
>Cheers and thanks in advance,
>
>Oliver

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Fri Jun 11 2004 - 13:42:46 CDT