OTN Discussion Forums : V_$SESSION

Reply to this Thread

Search Forum

Back to Thread List

Replies: 5 - Pages: 1 - Last Post: May 30, 2008 5:05 AM Last Post By: bazzza

Romain VILCOQ

Posts: 190
Registered: 05/24/00

V_$SESSION_LONGOPS
Posted: Oct 13, 2006 12:41 AM

Hi, I can't find informations about long running transaction in Grid Control 10.2.
I can find some informations in Top Session, but nothing that display the content of V_$SESSION_LONGOPS.

Thanks for help.
Regards

DBMS Direct

Posts: 4,641
Registered: 10/07/99

Re: V_$SESSION_LONGOPS
Posted: Oct 26, 2006 7:57 AM

in response to: Romain VILCOQ

From Database > Performance > Top SQL, you can sort by Elapsed Time

or

From Database > Performance > Top Sessions, you can customize to get what you want

Romain VILCOQ

Posts: 190
Registered: 05/24/00

Re: V_$SESSION_LONGOPS
Posted: Oct 27, 2006 1:28 AM

in response to: DBMS Direct

Hi, thanks for reply.
I don't have an Elpased Time column on this screen (Database > Performance > Top SQL)
I am interrested in long ops remaning time estimation.
Ok for Custo of top session, but I can't find information extracted from V$SESSION_LONGOPS, I can live without it, no problem, using sqlplus.
Just to say that it was usefull in the 9.2 EM release and not implemented in 10.2

Bye

gintsp

Posts: 1,847
Registered: 09/30/99

Re: V_$SESSION_LONGOPS
Posted: Jan 19, 2007 2:38 AM

in response to: Romain VILCOQ

Yeahh I was also interested in this info in the new super duper enterprise manager

Especially because old Java EM seems sometimes working rather shaky with 10g databases (OK I can understand that new version of DB and old version of the tool - quite normal) and long operations I cannot see at all for 10g databases.

The visual info about long operations for example is in XE and was in old java EM (screenshots can bee seen here http://www.gplivna.eu/papers/v$session_longops.htm ) and I'm really badly surprised not to be able to find them in new EM :O

Gints Plivna
http://www.gplivna.eu

Milto1

Posts: 2
Registered: 11/19/06

Re: V_$SESSION_LONGOPS
Posted: May 28, 2008 7:23 PM

in response to: Romain VILCOQ

I know it's yet another backward step from Oracle. I also miss the locks option from the old 9i EM, and being able to access all my DBs from one screen.
Progress? No.

bazzza

Posts: 1,148
Registered: 05/08/01

Re: V_$SESSION_LONGOPS
Posted: May 30, 2008 5:05 AM

in response to: Milto1

There's a locks link under performance tab for each database in grid control?

Pages: 1

Back to Thread List

Legend
	Guru : 2500 - 1000000 pts
	Expert : 1000 - 2499 pts
	Pro : 500 - 999 pts
	Journeyman : 200 - 499 pts
	Newbie : 0 - 199 pts
	Oracle ACE Director
	Oracle ACE Member
	Oracle Employee ACE
	Helpful Answer (5 pts)
	Correct Answer (10 pts)