Re: 10g Enterprise Manager

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.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)