Oracle v$ view that dynamically has the names of procedures

5 pts.
Tags:
Oracle administration
Oracle v$ Views
Oracle Views
Is there a v$ view where I may find just the names of all the procedures that are currently running in an Oracle database?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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’).

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    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.
    69,175 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following