• Increase font size
  • Default font size
  • Decrease font size

progress monitor PL/SQL Developer

How to monitor progress of DML operations? Here is the solution.

To monitor DML operation one have to create new session query. Follow this steps:

  1. Open "Tolls -> Sessions"
  2. Click small button called "Define Session Queries"
  3. Choose tab "Details"
  4. Create new detail (by clicking upper right button) and in "Definition" region fill "Caption" e.g. Status and "Query":

 

 
SELECT 
 S.TYPE "Type",
 S.USERNAME "DB User",
 S.SERVER "Server",
 S.CLIENT_INFO "Client Info",
 S.TERMINAL "Terminal",
 s.logon_time "Connect Time",
 s.sid, 
 Decode(vp.totalwork, 0, 0, round(100 * vp.sofar/vp.totalwork, 2)) "Percent", 
 vp.message "Message" 
FROM 
 V$SESSION S,
 v$Session_longops vp
WHERE 
 S.sid = vp.sid
 and s.sid=:sid

Now you can monitor DML operation's progress. But only those which run by FULL SCAN.

 

 

Comments  

 
0 #89 Marlys 2020-01-14 06:35
I am really enjoying the theme/design of your site. Do you ever run into any web browser
compatibility problems? A number of my blog audience have complained about my blog
not working correctly in Explorer but looks great in Chrome.

Do you have any suggestions to help fix this issue?

Feel free to surf to my web site; Marlys: http://engulapelsin.blogspot.com/2015/10/rostfiske-krusiduller-och-lyckliga-slut.html
Quote
 
 
0 #88 Phillis 2020-01-14 01:25
We are a group of volunteers and opening a new scheme in our community.

Your website offered us with useful info to work on. You've
performed a formidable activity and our entire group will be thankful to you.



Look at my homepage ... Phillis: http://prinsessavanessa.blogspot.com/2016/11/shopping-for-christmaslights.html
Quote
 
 
0 #87 dmaclub.com 2020-01-10 06:13
Very quickly this web page will be famous among all blog people, due to it's fastidious articles or reviews

Here is my page: dmaclub.com: https://dmaclub.com/2009/02/01/28-sunday-shoutin-w-louie-vega-david-morales-tony-humphries-nyc/
Quote
 
 
0 #86 Richie 2019-12-30 20:11
Wow! At last I got a web site from where I be able to really
obtain valuable facts concerning my study and knowledge.



Feel free to surf to my blog ... Richie: https://3bestnow.com/5-best-aluminum-tin-foil/
Quote
 
 
0 #85 Buck 2019-12-25 10:19
You actually make it seem so easy with your presentation but
I find this matter to be actually something that I think I
would never understand. It seems too complicated and extremely
broad for me. I am looking forward for your next post, I'll try
to get the hang of it!

my web site - Buck: http://www.heavymusic.ru/news/4690/
Quote
 
 
0 #84 Emanuel 2019-11-26 22:18
Hi there Dear, are you really visiting this site regularly, if so after that you
will absolutely get fastidious experience.

Feel free to visit my site Emanuel: https://keytipeda.it.gg/
Quote
 
 
0 #83 espn.com/activate 2019-11-25 10:54
My partner and I stumbled over here by a different page and thought I should check things out. I like what I see so now i’m following you. Look forward to finding out about your web page yet again.|
Quote
 
 
0 #82 Elias 2019-11-07 08:33
For the reason that the admin of this site is working, no uncertainty very rapidly it will be well-known, due to its feature contents.



Feel free to visit my website Elias: https://bestphotoguides.com/category/tips/
Quote
 
 
0 #81 Valerie 2019-11-06 18:28
Great post. I was checking constantly this blog and I'm inspired!
Extremely helpful info specially the final section :)
I deal with such information a lot. I used to be seeking
this particular info for a very lengthy time. Thanks
and good luck.

Feel free to visit my page ... Valerie: https://carcarexp.com/10w30-vs-10w40-differences-in-engine-oil-viscosity/
Quote
 
 
0 #80 Jaxon 2019-09-23 07:34
I am no longer positive where you're getting your info, but great
topic. I must spend some time finding out much more or understanding
more. Thanks for excellent information I used to be looking for this information for my mission.

My blog ... Jaxon: https://dentalshome.com/immediate-tooth-pain-relief-for-emergency-dental/
Quote
 

Add comment

No bad words.


Security code
Refresh


New articles

Differential Equations - Simple spring model Machine Learning and Robotics
Read More 4838 Hits
Kalman Filter implementation Machine Learning and Robotics
Read More 3644 Hits
Inverse kinematics Machine Learning and Robotics
Read More 6014 Hits
gpsim tutorial Machine Learning and Robotics
Read More 55836 Hits

Most read content

gpsim tutorial Machine Learning and Robotics
Read More 55836 Hits
PID regulator Machine Learning and Robotics
Read More 45532 Hits

New articles

Differential Equations - Simple spring model Machine Learning and Robotics
Read More 4838 Hits
Kalman Filter implementation Machine Learning and Robotics
Read More 3644 Hits
Inverse kinematics Machine Learning and Robotics
Read More 6014 Hits
gpsim tutorial Machine Learning and Robotics
Read More 55836 Hits
Design by i-cons.ch / etosha-namibia.ch