Home » RDBMS Server » Server Administration » Time remaining to complete table statistics (Oracle 10.2.0.4.0,SunOS)
Time remaining to complete table statistics [message #539475] Mon, 16 January 2012 04:42 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

I use the following query to find out the remaining time to complete the table statistics
which is running currently.

SELECT SID, SERIAL#, opname, SOFAR, TOTALWORK,username,context,
ROUND(SOFAR/TOTALWORK*100,2) COMPLETE
FROM   V$SESSION_LONGOPS
WHERE
TOTALWORK != 0
AND    SOFAR != TOTALWORK
order by 1;


I have a question in the query output.

SOFAR column shows 9325 and totalwork column shows 12287.How to calculate the columns in terms of hours and minutes ?

And also sometime the query never shows the output of the query for the current running query.

Is there a another way to find out for the similar task ?

Thank you

[Updated on: Mon, 16 January 2012 04:52]

Report message to a moderator

Re: Time remaining to complete table statistics [message #539478 is a reply to message #539475] Mon, 16 January 2012 04:52 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Recording its task in this "view" is a willing stuff.
That is only some parts of Oracle code do it and only when some conditions are met like the code must last long enough.

Regards
Michel

[Updated on: Mon, 16 January 2012 04:52]

Report message to a moderator

Previous Topic: How to set ORAENV in linux
Next Topic: connect to newly created database
Goto Forum:
  


Current Time: Fri Mar 29 06:54:35 CDT 2024