user process view

[Sophia Choi]

Can I view the active job process in oracle?
e.g if I run serveral PL/SQL in the background, can I know the percentage of completeness so that I can know how much usage of the program in Oracle ?

[Mark Spritzler]

In Oracle's Enterprise Manager you can see what each session is doing and a percentage and estimated time till completion. These estimates are a little, well off. They aren't exact, but sort of close enough to get a general idea.
When you go into OEM, you go to the sessions screen, and you can double click on any one of them to bring up a screen that has three tabs. I believe the second tab gives yuo the query and estimates.
I am sure these are all gathered from v$/dba views, but not sure which one will give you all that information, if you don't have access to OEM.
Good Luck
Mark