Home » SQL & PL/SQL » SQL & PL/SQL » How to know the information about packages that are getting executed in the database
How to know the information about packages that are getting executed in the database [message #274987] Thu, 18 October 2007 00:58 Go to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
I am using 10g release 2 database

I want to know the information regarding the packages that are being executed by diiferent users .
Information regarding name of package , time at which it started and ended etc

Is there any v$ views which provides this information?
Re: How to know the information about packages that are getting executed in the database [message #274988 is a reply to message #274987] Thu, 18 October 2007 01:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
v$access

Regadrs
Michel
Re: How to know the information about packages that are getting executed in the database [message #275148 is a reply to message #274987] Thu, 18 October 2007 09:09 Go to previous messageGo to next message
ora110
Messages: 42
Registered: September 2007
Location: China
Member

v$access
Re: How to know the information about packages that are getting executed in the database [message #275150 is a reply to message #275148] Thu, 18 October 2007 09:13 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Well, that post added a lot to the total information available in the thread.
Previous Topic: mutating problem
Next Topic: pl/sql cursors
Goto Forum:
  


Current Time: Fri Dec 02 16:38:20 CST 2016

Total time taken to generate the page: 0.26166 seconds