• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

user process view

 
Ranch Hand
Posts: 106
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 ?
 
ranger
Posts: 17346
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
reply
    Bookmark Topic Watch Topic
  • New Topic