0

Hi I am new to Oracle 12c, though I was working on SQL Server for a long time.

Is there a way to get a list of stored procedures with their execution count in oracle 12c.

We can get it using DMV in SQL Server (various versions). But I am looking for it in Oracle 12c.

0

You can list them with this query (similar to sys.procedures):

SELECT * FROM USER_PROCEDURES 

For execution count, I think you will have to use Audit functionnalities.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.