9ir2 OEM Doubts

[JChiappa]

I evaluated 9ir2 OEM some months ago , but I do not use it. Due to third-part requirements, I will need to do, and have 2 doubts regarding it :

1) I remember that OEM (maybe with one of the add-on Packs) have/has a screen showing the time remaining for SQL execution, anyone knows exactly what/where ?

2) I read sometime ago parts of a paper (in Oracle technet or Oracle World docs) called "A day in the Life of DBA" - or something very aliked to it -, and the paper was a (more or less) real relate of someone using OEM new featues. Anyone knows the paper correct name, and where find it ?

Regards,

Chiappa

[jovery]

I think the time remaining screen you are looking for is under the Instance/Sessions pick a session then select the "Long Operations" tab

You can also get the same information from the v$session_longops view.

Regards