mahjag
asked on
dbms messaging in a package
Hi
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>does exactly that
I stand corrected.
I stand corrected.
set_session_longops fills in the data
you query status and time remaining from v$session_longops
you query status and time remaining from v$session_longops
ASKER
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
you'll have to ask your dba to grant you access though
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.