• 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 #25 Ahmed Hassan 2018-04-07 01:27
Hey! I'm at work surfing around your blog from my new apple iphone!
Just wanted to say I love reading your blog and look forward to all your posts!
Keep up the outstanding work!

Here is my page ... Ahmed Hassan: https://venorex.wordpress.com/
Quote
 
 
0 #24 Hussin Ahmed 2018-04-06 09:45
Wonderful blog you have here but I was curious about if you
knew of any community forums that cover the same topics discussed in this
article? I'd really lovve to be a part of group where I can get feed-back from other experienced individuals that share the same interest.
If you have any recommendations , please
let me know. Thanks!

my blog :: Hussin Ahmed: https://swrbook.blogspot.com/
Quote
 
 
0 #23 buy lumigan drops 2018-03-31 17:42
Very nice article, totally what I wanted to find.

Feel free to visit my web page ... buy lumigan drops: https://sites.google.com/site/buylumiganonlineoverthecounter/
Quote
 
 
0 #22 ChristopherChief 2018-03-27 12:09
I have checked your site and i have found some duplicate content, that's why you don't rank high in google, but there is a tool that can help you to create 100%
unique content, search for: boorfe's tips unlimited content
Quote
 
 
0 #21 mezo 2018-03-27 09:41
I know this if offf topic ƅut I'm looking into starting
mʏ own weblog and was wondering ԝhɑt all is needеd tο get set uр?

I'm assuming hаving a blog ⅼike youгѕ ᴡould cost a pretty penny?
Ӏ'm not ᴠery web smart ѕo I'm not 100% sure. Αny tips оr advice would be greayly appreciated.
Kudos

Ηere iss my web blog; mezo: http://mezocoupons.blogspot.com/
Quote
 
 
0 #20 Hà An 2017-10-11 10:41
I read this paragraph completely regarding
the difference of latest and preceding technologies, it's amazing
article.
Quote
 
 
0 #19 Imogen 2017-06-20 22:16
Id ought to check with you here. Which isht something I do!
I like reading a post which will get people to feel. Also,
thanks for permitting mee tto comment!
Quote
 
 
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
 

Add comment

No bad words.


Security code
Refresh


New articles

Differential Equations - Simple spring model Machine Learning and Robotics
Read More 1855 Hits
Kalman Filter implementation Machine Learning and Robotics
Read More 2652 Hits
Inverse kinematics Machine Learning and Robotics
Read More 3307 Hits
gpsim tutorial Machine Learning and Robotics
Read More 8043 Hits

Most read content

New articles

Differential Equations - Simple spring model Machine Learning and Robotics
Read More 1855 Hits
Kalman Filter implementation Machine Learning and Robotics
Read More 2652 Hits
Inverse kinematics Machine Learning and Robotics
Read More 3307 Hits
gpsim tutorial Machine Learning and Robotics
Read More 8043 Hits
Design by i-cons.ch / etosha-namibia.ch