<body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener("load", function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <iframe src="http://www.blogger.com/navbar.g?targetBlogID=31231294&amp;blogName=indra+punya+blog&amp;publishMode=PUBLISH_MODE_BLOGSPOT&amp;navbarType=BLUE&amp;layoutType=CLASSIC&amp;searchRoot=http://indrajati.blogspot.com/search&amp;blogLocale=en_US&amp;homepageUrl=http://indrajati.blogspot.com/&amp;vt=-2054372107529621458" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" height="30px" width="100%" id="navbar-iframe" allowtransparency="true" title="Blogger Navigation and Search"></iframe> <div></div>

 

longops .... longops ....

select sid,
serial#,
username,
sofar/totalwork*100 pct_done,
TIME_REMAINING/60 as REMAINING_MIn ,
ELAPSED_SECONDs/60 as ELAPSED_MIN,
message from v$session_longops where totalwork > sofar;

Labels:

By Indrajati Chairuddin
On Wednesday, September 14, 2011
At 1:11 AM
Comments :
 

for this post

Leave a Reply