Home » RDBMS Server » Performance Tuning » Show remain cpu time to end Query in OEM
icon8.gif  Show remain cpu time to end Query in OEM [message #153140] Thu, 29 December 2005 07:39 Go to next message
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
Re: Show remain cpu time to end Query in OEM [message #153164 is a reply to message #153140] Thu, 29 December 2005 11:30 Go to previous messageGo to next message
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
Re: Show remain cpu time to end Query in OEM [message #153235 is a reply to message #153140] Fri, 30 December 2005 04:06 Go to previous message
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
Previous Topic: ORA-12015: cannot create a fast refresh snapshot from a complex query
Next Topic: help calculating freelist groups
Goto Forum:
  


Current Time: Mon Nov 28 05:20:11 CST 2022