• 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 #46 BestChana 2018-11-19 03:06
I have noticed you don't monetize your page, don't waste your traffic, you can earn additional bucks every month.
You can use the best adsense alternative for any type of website (they approve all websites),
for more info simply search in gooogle: boorfe's tips
monetize your website
Quote
 
 
0 #45 profile6001 2018-10-28 10:27
Need cheap hosting? Try webhosting1st, just $10 for an year.

http://hugh-dancy.net/photos/albums/userpics/11079/cheap-websites-hosting-51411.jpg
Quote
 
 
0 #44 Kathryn 2018-10-21 10:25
And what much better location to set that than in Miami?

Here is my website Kathryn: http://www.joyrus.com/home/link.php?url=http://cli.re/gY5yYg
Quote
 
 
0 #43 xnxxporn.pw 2018-07-17 16:08
Hurrah! After all I got a weblog from where I be capable of really take useful
information regarding my study and knowledge.
Quote
 
 
0 #42 Nuvega Lash Reviews 2018-06-23 11:40
I conceive you have noted some very interesting
points, regards for the post.
Quote
 
 
0 #41 Eyelashes 2018-05-21 08:27
Havinng read this I thought it was extremely informative.

I appreciate you spending some time and effort
to put this article together. I once again find myself spending
way too much time both reading and commenting. But sso what, it
was still worth it!

Also vidit my web blog: Eyelashes: https://bit.ly/2Is2FRs
Quote
 
 
0 #40 long Eyelashes 2018-05-20 09:54
Tremendous thihgs here. I am very glad tto look yoour article.
Thank yoou a lot and I am taking a look ahead to contact you.
Will you please drop me a mail?

My web-site - long Eyelashes: https://bit.ly/2Is2FRs
Quote
 
 
0 #39 Grow Faster 2018-05-19 13:28
It's wonderful that you are getting ideas from this
piece of writing as well as from our discussion made at this time.


my blog post ... Grow Faster: https://bit.ly/2Is2FRs
Quote
 
 
0 #38 Eyelashes Growth 2018-05-18 20:22
Thanks , I have recently been searching for inhformation approximaterly this subject for a while and yours iss the best I
have discovered till now. However, what concerning the bottom line?
Are you positive about the source?

Also visit my blog post; Eyelashes Growth: https://bit.ly/2Is2FRs
Quote
 
 
0 #37 Grow faster 2018-05-18 01:05
I likoe the helpful info yyou supply in ypur articles.
I will bookmark your blog and test again right here
regularly. I am slightly certain I'll be told many new styff right right here!
Good luck for the following!

Feel frde to suef to my website - Grow faster: https://bit.ly/2Is2FRs
Quote
 

Add comment

No bad words.


Security code
Refresh


New articles

Differential Equations - Simple spring model Machine Learning and Robotics
Read More 2024 Hits
Kalman Filter implementation Machine Learning and Robotics
Read More 2868 Hits
Inverse kinematics Machine Learning and Robotics
Read More 3881 Hits
gpsim tutorial Machine Learning and Robotics
Read More 9387 Hits

Most read content

A* search algorithm Machine Learning and Robotics
Read More 13945 Hits
gpsim tutorial Machine Learning and Robotics
Read More 9387 Hits
PID regulator Machine Learning and Robotics
Read More 8482 Hits

New articles

Differential Equations - Simple spring model Machine Learning and Robotics
Read More 2024 Hits
Kalman Filter implementation Machine Learning and Robotics
Read More 2868 Hits
Inverse kinematics Machine Learning and Robotics
Read More 3881 Hits
gpsim tutorial Machine Learning and Robotics
Read More 9387 Hits
Design by i-cons.ch / etosha-namibia.ch