dbms messaging in a package


I wanted to capture the time start , time end and time elapsed in a oracle package and sometimes even on what stage the program is running and how long (estimated) it would take to complete - so that it is user friendly when someone invokes the package and waits until it is done - is there any standards on this and anyone developed any template that can used quickly in a short turnaround for coding and testing? If yes can you guys share?
Who is Participating?
sdstuberConnect With a Mentor Commented:

does exactly that
slightwv (䄆 Netminder) Commented:
I don't know of anything you can buy to do this.

Typically I just create my own 'timing' table.  Then I can add any rows at any stage I want.  Then report on it however I choose.
slightwv (䄆 Netminder) Commented:
>>does exactly that

I stand corrected.
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

set_session_longops fills in the data

you query status and time remaining from v$session_longops
mahjagAuthor Commented:
can application developer have access to v$session?
yes, and also to v$session_longops.

you'll have to ask your dba to grant you access though
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.