OraFAQ Forum: Performance Tuning » Show remain cpu time to end Query in OEM

Home » RDBMS Server » Performance Tuning » Show remain cpu time to end Query in OEM

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Show remain cpu time to end Query in OEM [message #153140]

Thu, 29 December 2005 07:39

luchino75
Messages: 3
Registered: December 2005
Location: Milano

Junior Member

hello

what is the metod to show the remaing time to end a query active in the database ORACLE by the Oracle enterprise manager?

thank you

Luchino75

Report message to a moderator

Re: Show remain cpu time to end Query in OEM [message #153164 is a reply to message #153140]

Thu, 29 December 2005 11:30

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

As long its a long operation you can check the v$session_longops .. I think time_remaining column should be able to get you information ..

best way is to trace this using OEM ..

-Sai Jeedigunta

Report message to a moderator

Re: Show remain cpu time to end Query in OEM [message #153235 is a reply to message #153140]

Fri, 30 December 2005 04:06

luchino75
Messages: 3
Registered: December 2005
Location: Milano

Junior Member

where i see the time_remaing in the OEM?
What is the metod to view this parameter in th OEM?

Thank a lot

Luca

Report message to a moderator

Previous Topic:	ORA-12015: cannot create a fast refresh snapshot from a complex query
Next Topic:	help calculating freelist groups

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 07:45:13 CST 2024