Oracle v$ view that dynamically has the names of procedures
Home > IT Answers > Oracle > Oracle v$ view that dynamically has the names...
Skabanga
5 pts.
0
Q:
Oracle v$ view that dynamically has the names of procedures
Oracle v$ Views, Oracle Views, Oracle administration
Is there a v$ view where I may find just the names of all the procedures that are currently running in an Oracle database?
ASKED: Feb 25 2009  7:41 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Kccrosser
1850 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
You may need to clarify your question. I am unaware of any view or other mechanism to "sample" in real time which individual procedures are running. You can look at running "jobs" by querying the dba_jobs_running view and joining it to the dba_jobs view on the job column.

Note - you may need to join on the dba_scheduler_jobs view instead of dba_jobs. That is the newer, preferred method of scheduling and executing jobs.

You can see all the compiled procedures in the system in the dba_objects view. Just filter on object_type in ('PROCEDURE','PACKAGE','FUNCTION').
Last Answered: Feb 25 2009  5:44 PM GMT by Kccrosser   1850 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Carlosdl   29830 pts.  |   Feb 25 2009  10:58PM GMT

I’m not aware of such view either. However, if that’s important for you, I think you could modify your procedures/functions to register using the DBMS_APPLICATION_INFO package so you can then look for them in V$SESSION or V$SQLAREA.

Have a look at this article.

 
0