• 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 #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
 
 
0 #53 Ashly 2019-02-03 23:43
Its like you read my mind! You seem to know a lot 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 little bit,
but instead of that, this is fantastic blog.
An excellent read. I'll certainly be back.
Quote
 
 
0 #52 grammarly free trial 2019-01-29 23:26
That is a very good tip especially to those fresh to the blogosphere.
Brief but very accurate info… Many thanks for
sharing this one. A must read post!
Quote
 
 
0 #51 Kristi 2019-01-29 01:30
of course like your website but you have to test the spelling on several of your posts.

Many of them are rife with spelling issues and I in finding it
very troublesome to tell the truth nevertheless I'll certainly come back
again.

my web page: Kristi: http://getpocket.com
Quote
 
 
0 #50 http://plesk.com 2019-01-23 17:58
Hi there, I enjoy reading all of your post. I wanted to write
a little comment to support you.

Visit my website ... http://plesk.com: http://plesk.com
Quote
 
 
0 #49 blog 2019-01-21 06:09
I have been browsing on-line greater than 3 hours
these days, but I by no means found any interesting article like
yours. It's lovely worth sufficient for me. In my view, if all web owners and bloggers
made excellent content material as you probably did, the web shall be a lot more useful than ever before.


Feel free to visit my weblog - blog: http://issuu.com
Quote
 

Add comment

No bad words.


Security code
Refresh


New articles

Differential Equations - Simple spring model Machine Learning and Robotics
Read More 2067 Hits
Kalman Filter implementation Machine Learning and Robotics
Read More 2933 Hits
Inverse kinematics Machine Learning and Robotics
Read More 4151 Hits
gpsim tutorial Machine Learning and Robotics
Read More 10474 Hits

Most read content

A* search algorithm Machine Learning and Robotics
Read More 18560 Hits
PID regulator Machine Learning and Robotics
Read More 10658 Hits
gpsim tutorial Machine Learning and Robotics
Read More 10474 Hits

New articles

Differential Equations - Simple spring model Machine Learning and Robotics
Read More 2067 Hits
Kalman Filter implementation Machine Learning and Robotics
Read More 2933 Hits
Inverse kinematics Machine Learning and Robotics
Read More 4151 Hits
gpsim tutorial Machine Learning and Robotics
Read More 10474 Hits
Design by i-cons.ch / etosha-namibia.ch