• 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 #79 download 2019-06-28 16:26
Its like you read my mind! You appear to know
so much about this, like you wrote the book in it or something.
I think that you can do with a few pics to drive the message
home a bit, but instead of that, this is magnificent blog.
An excellent read. I will definitely be back.



my webpage; download: http://archive.is/M65b4
Quote
 
 
0 #78 download 2019-06-23 00:34
Good way of explaining, and good post to obtain data regarding my presentation topic, which i am going to convey in school.



my weblog: download: https://www.f6s.com/girlsgenerationtorrent
Quote
 
 
0 #77 download 2019-06-23 00:33
Good way of explaining, and good post to obtain data regarding my presentation topic, which i am going to convey in school.



my weblog: download: https://www.f6s.com/girlsgenerationtorrent
Quote
 
 
0 #76 download 2019-06-23 00:33
Good way of explaining, and good post to obtain data regarding my presentation topic, which i am going to convey in school.



my weblog: download: https://www.f6s.com/girlsgenerationtorrent
Quote
 
 
0 #75 download 2019-06-16 09:16
What's up everybody, here every person is sharing these experience, therefore it's pleasant to read this webpage, and I
used to pay a visit this weblog all the time.

Also visit my web blog ... download: https://install-iso-game-on-lin-iyt.peatix.com/
Quote
 
 
0 #74 Morgan 2019-06-15 18:33
I used to be suggested this web site via my cousin. I am not
certain whether this submit is written by way of him as
no one else realize such particular about my problem. You are amazing!

Thanks!
Quote
 
 
0 #73 download 2019-06-10 20:00
you are in reality a good webmaster. The web site loading speed is amazing.
It sort of feels that you're doing any distinctive trick.
Moreover, The contents are masterwork. you've done a great process in this topic!


Here is my homepage - download: https://www.iflychina.net/forum/topic/849704
Quote
 
 
0 #72 Download site 2019-06-09 23:51
I am regular reader, how are you everybody? This post posted at this web Download site: http://machinebarn.com/user/profile/153748
is in fact fastidious.
Quote
 
 
0 #71 download 2019-05-28 19:36
Wonderful blog! I found it while surfing around on Yahoo News.
Do you have any suggestions on how to get listed in Yahoo
News? I've been trying for a while but I never seem to get there!
Many thanks

Feel free to surf to my site :: download: https://resterplati.site123.me/blog/key-business-development-activities
Quote
 
 
0 #70 download 2019-05-28 19:36
Wonderful blog! I found it while surfing around on Yahoo News.
Do you have any suggestions on how to get listed in Yahoo
News? I've been trying for a while but I never seem to get there!
Many thanks

Feel free to surf to my site :: download: https://resterplati.site123.me/blog/key-business-development-activities
Quote
 

Add comment

No bad words.


Security code
Refresh


New articles

Differential Equations - Simple spring model Machine Learning and Robotics
Read More 4644 Hits
Kalman Filter implementation Machine Learning and Robotics
Read More 3394 Hits
Inverse kinematics Machine Learning and Robotics
Read More 4979 Hits
gpsim tutorial Machine Learning and Robotics
Read More 48021 Hits

Most read content

gpsim tutorial Machine Learning and Robotics
Read More 48021 Hits
PID regulator Machine Learning and Robotics
Read More 40484 Hits

New articles

Differential Equations - Simple spring model Machine Learning and Robotics
Read More 4644 Hits
Kalman Filter implementation Machine Learning and Robotics
Read More 3394 Hits
Inverse kinematics Machine Learning and Robotics
Read More 4979 Hits
gpsim tutorial Machine Learning and Robotics
Read More 48021 Hits
Design by i-cons.ch / etosha-namibia.ch