OraFAQ Forum: Server Administration » V$session

Home » RDBMS Server » Server Administration » V$session_Longops issue (11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

V$session_Longops issue [message #520711]

Wed, 24 August 2011 03:40

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
Just a sid with 1691,why there are appear two rows,one finish 63% and another finished 100% ?

Select round(sofar*100/totalwork,2)"finished(%)",
       Sid,
       Serial#,
       Opname,
       Target,
       Sofar,
       Totalwork,
       Units,
       Time_Remaining,
       Elapsed_Seconds
  From V$session_Longops@Oss139.Localdomain a
 Where Sid In (1691);

finished(%)	SID	   OPNAME	      TARGET	                          SOFAR	  TOTALWORK	UNITS	  TIME_REMAINING	ELAPSED_SECONDS
63.67	      1691	 Table Scan	  OSS03.OSS_PRODUCT_MID_DAY_201108	741260	1164144	  Blocks	1255	          2200
100	        1691	 Table Scan	  OSS03.OSS_PRODUCT_MID_DAY_201108	1164144	1164144	  Blocks	0	              2408

Report message to a moderator

Re: V$session_Longops issue [message #520715 is a reply to message #520711]

Wed, 24 August 2011 04:01

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

Because that view doesn't immediately remove records for work that's completed.
If you want to see what's currently happening use this in the where cluase:

AND time_remaining > 0

Report message to a moderator

Previous Topic:	Flashback Data Archive - Problem
Next Topic:	Not able to kill the session

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 02:41:47 CST 2025