• 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 #63 example.com 2019-05-08 18:25
Greetings! Very helpful advice within this post! It is the little changes which will make the most significant changes.
Many thanks for sharing!

My homepage: example.com: http://example.com
Quote
 
 
0 #62 8 2019-04-26 04:06
I think the admin of this web site is really working hard in support of his
web site, as here every material is quality based information.

my website; 8: http://www.ytvusa.com/board_KVJC89/450505
Quote
 
 
0 #61 farmaciFrisp 2019-04-21 12:48
Comprare cialis levitra viagra farmacia online italiana sicura rimedi farmaci disfunzione erettile https://unique-work.jimdofree.com/2019/04/04/qualities-of-an-excellent-online-pharmacy/
comprare fildena
comprare levitra
comprare cialis
comprare vidalista
Quote
 
 
0 #60 4 2019-04-16 22:23
Good day! I know this is kinda off topic but I was wondering if you knew where
I could locate a captcha plugin for my comment form? I'm using the same blog
platform as yours and I'm having difficulty finding one?
Thanks a lot!

Also visit my web-site 4: https://www.lily-roze.fr/index.php/journal/6225/key-registrasi-idm-serial-number-key-idm-6/
Quote
 
 
0 #59 5 2019-04-08 18:11
This website was... how do you say it? Relevant!!
Finally I have found something which helped me. Thank you!


Here is my homepage :: 5: http://socialnetworks.buy-social-website-traffic.com/blogs/viewstory/148104
Quote
 
 
0 #58 4 2019-03-14 23:51
Hey there, You have done a great job. I will definitely digg it and personally suggest to my
friends. I am sure they will be benefited from this site.



my web page :: 4: https://sushilbarali.com.np/QNA/index.php?qa=72864&qa_1=naruto-season-1-torrent-english-dubbed-naruto-season-1
Quote
 
 
0 #57 download 2019-03-14 00:10
Admiring the dedication you put into your blog and detailed information you
present. It's good to come across a blog every
once in a while that isn't the same old rehashed information.
Great read! I've bookmarked your site and I'm including
your RSS feeds to my Google account.

My web page ... download: http://www.demark.io/and-dating/18-and-16-year-old-dating-florida.html
Quote
 
 
0 #56 5 2019-02-25 01:09
I think this is among the most important information for me.
And i am glad reading your article. But want to remark
on some general things, The web site style is great,
the articles is really nice : D. Good job, cheers

Visit my blog ... 5: http://nweng.co.kr/question/350378
Quote
 
 
0 #55 download 2019-02-11 00:33
Hi there it's me, I am also visiting this website on a regular basis, this site is in fact
good and the viewers are really sharing nice thoughts.


My blog post: download: http://quisyjourta.bloggerspoint.dk/2019/02/white-girls-like-mexicans-10-reasons-why-you-should-date-a-mexican-man/
Quote
 
 
0 #54 download 2019-02-09 07:34
Hello there I am so glad I found your website, I really found you
by mistake, while I was browsing on Google for something else, Regardless I am here
now and would just like to say thank you for a marvelous post and
a all round entertaining blog (I also love the theme/design), I don't
have time to go through it all at the minute but I have book-marked it and also added in your RSS feeds, so when I
have time I will be back to read a great deal more, Please do keep up the superb job.


My blog ... download: http://raaredarlo.reblog.hu/partnersuche-rostock
Quote
 

Add comment

No bad words.


Security code
Refresh


New articles

Differential Equations - Simple spring model Machine Learning and Robotics
Read More 2090 Hits
Kalman Filter implementation Machine Learning and Robotics
Read More 2967 Hits
Inverse kinematics Machine Learning and Robotics
Read More 4381 Hits
gpsim tutorial Machine Learning and Robotics
Read More 11512 Hits

Most read content

A* search algorithm Machine Learning and Robotics
Read More 23150 Hits
PID regulator Machine Learning and Robotics
Read More 12633 Hits
gpsim tutorial Machine Learning and Robotics
Read More 11512 Hits

New articles

Differential Equations - Simple spring model Machine Learning and Robotics
Read More 2090 Hits
Kalman Filter implementation Machine Learning and Robotics
Read More 2967 Hits
Inverse kinematics Machine Learning and Robotics
Read More 4381 Hits
gpsim tutorial Machine Learning and Robotics
Read More 11512 Hits
Design by i-cons.ch / etosha-namibia.ch