• 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 #18 RCA Sparepart Motor 2015-10-11 13:42
Attractive section of content. I simply stumbled upon your blog and in accession capital to say that I get actually loved account your blog
posts. Any way I will be subscribing for your augment and even I achievement you get
admission to consistently rapidly.
http://pilihbaik.blogspot.co.id
Quote
 
 
0 #17 Lillaotto. 2015-09-22 20:29
Among the types of road accidents, truck mishaps can cause thee most fatal injuries
to a victim. Thus, if you are a victim oof a motorcycle accident, then you should hire a St.

I guess we don't pull our owwn teeth these days,
so it stands to reason tgat we wouldn't prepare our own legal documents and try to present
a case on our own.

Feel free to surf to my blog Lillaotto.Bloggplatsen.se: http://Lillaotto.Bloggplatsen.se/gilla/?url=http://bortac.com/tag/18-wheeler-attorney/
Quote
 
 
0 #16 online intimate 2015-09-06 10:45
Howdy! Would you mind if I share your blog with my facebook group?
There's a lot of folks that I think would really enjoy your content.

Please let me know. Cheers

Here is my page; online intimate gadgets: http://gadgetsjr.com/intimate-apparel
Quote
 
 
0 #15 prix medicament 2015-08-29 23:08
This is very fascinating, You are an excessively professional blogger.
I've joined your rss feed and stay up for in quest of extra of your magnificent
post. Also, I've shared your site in my social networks
Quote
 
 
0 #14 http://www.health4u. 2015-07-18 20:20
Pekne napísané...ťažko nesúhlasiť.
Quote
 
 
0 #13 http://healthraport. 2015-07-17 03:34
Príspevok je naozaj skvelý, gratulujem!
Quote
 
 
0 #12 http://www. 2015-07-16 16:29
Lepšie by som to nenapísal. Vynikajúci príspevok!
Quote
 
 
0 #11 restaurants near me 2015-06-27 15:25
Thank you for any other informative web site. The place
else could I get that kind of information written in such a perfect
manner? I have a venture that I'm simply now running on, and I've been at the glance out for such information.

restaurants near me wings restaurants near
me north andover ma: http://restaurantsnearme.space
Quote
 
 
0 #10 wall Mounted 2015-06-23 10:26
Those years of suburban English classes have paid off!
I like reading your little blog, I chuckle a lot, in a good way.
Thanks on your marvelous posting! I quite enjoyed reading it, you could be a great author.I
will be sure to bookmark your blog and will eventually come back later on.
I want to encourage you to continue your great
writing, have a nice morning!
Quote
 
 
0 #9 shop car gadgets 2015-06-05 01:10
Have you ever thought about adding a little bit more than just your
articles? I mean, what you say is important and everything.

Nevertheless think about if you added some great visuals or
video clips to give your posts more, "pop"!
Your content is excellent but with images and
clips, this blog could certainly be one of the very best
in its field. Fantastic blog!

my blog post ... shop car gadgets: https://www.youtube.com/watch?v=vdTeJIJz73s
Quote
 

Add comment

No bad words.


Security code
Refresh


New articles

Differential Equations - Simple spring model Machine Learning and Robotics
Read More 1327 Hits
Kalman Filter implementation Machine Learning and Robotics
Read More 2042 Hits
Inverse kinematics Machine Learning and Robotics
Read More 2487 Hits
gpsim tutorial Machine Learning and Robotics
Read More 590 Hits

New articles

Differential Equations - Simple spring model Machine Learning and Robotics
Read More 1327 Hits
Kalman Filter implementation Machine Learning and Robotics
Read More 2042 Hits
Inverse kinematics Machine Learning and Robotics
Read More 2487 Hits
gpsim tutorial Machine Learning and Robotics
Read More 590 Hits
Design by i-cons.ch / etosha-namibia.ch