10g Enterprise Manager

[Oliver Zeigermann]

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

[Daniel Morgan]

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@x.washington.edu
(replace 'x' with a 'u' to reply)

[Oliver Zeigermann]

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

[Ana C. Dent]

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

[Oliver Zeigermann]

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