Executing The Procedure in the database

[gokul]

Hi all,

I have created a Procedure in the qa environment, and the procedure is not allocated or scheduled for otm jobs,.

but i want to see the procedures last executed date and time in the database, can u folks help me on this

[chrisplough]

Re: Executing The Procedure in the database

Gokul,

I may be wrong, but I'm not aware of anywhere within the Oracle database this is listed, unless the procedure is scheduled via the Oracle Job Queue Facility -- in which case it tracks the running (and past runs) of that particular procedure.


--Chris

[cheekythought]

Re: Executing The Procedure in the database

In addition to what Chris has specified -

1) You can put a insert_date column for the data inserts/updates/refresh that is being attempted through the procedure.That can tell you for sure when the procedure completed. If it is a data refresh, then it will tell you the start and end dates.

2) Alternatively, if procedure is triggered through the agent, you can check the logs to know the timings

or

3) give notify message centres before and after the procedure run to check the start and end timings in the message centre

Any more?