• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

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?
0
mahjag
Asked:
mahjag
  • 3
  • 2
1 Solution
 
sdstuberCommented:
dbms_application_info.set_session_longops

does exactly that
0
 
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.
0
 
slightwv (䄆 Netminder) Commented:
>>does exactly that

I stand corrected.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
sdstuberCommented:
set_session_longops fills in the data

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

you'll have to ask your dba to grant you access though
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now