RE: Determine process of index build - HOW

[George Leonard (ZA)]

Title: RE: Determine process of index build - HOW

This is a query I build to see this, midnight Saturday   Comment welcome   column "% Done" format 999.99 column opname format a15 column sql_text format a70 column "T Left" format 99999 select             a.sid,             (a.sofar/a.totalwork)*100 "% Done",             to_char(a.last_update_time, 'HH24:MI:SS'),             a.username,             a.time_remaining "T Left",             a.opname ,             s.sql_text from v$session_longops a, v$session b, v$sqltext s where a.sid =b.sid and b.sql_address = s.address and a.sofar <> a.totalwork order by b.sid, last_update_time /   George ________________________________________________ George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web:   http://www.didata.co.za   You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -----Original Message----- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 14:38 PM To: Multiple recipients of list ORACLE-L Subject: RE: Determine process of index build - HOW   v$session_longops .... select with last_update_time desc and use the sid ... it is pretty cool .. it will also tell you for "current operation" how many seconds are remaining. Raj ______________________________________________________ Rajendra Jamadagni              MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *************************************************************************************** This message contains information intended solely for the addressee, which is confidential or private in nature and subject to legal privilege. If you are not the intended recipient, you may not peruse, use, disseminate, distribute or copy this message or any file attached to this message. Any such unauthorised use is prohibited and may be unlawful. If you have received this message in error, please notify the sender immediately by e-mail, facsimile or telephone and thereafter delete the original message from your machine. Furthermore, the information contained in this message, and any attachments thereto, is for information purposes only and may contain the personal views and opinions of the author, which are not necessarily the views and opinions of Dimension Data (South Africa) (Proprietary) Limited or its subsidiaries and associated companies ("Dimension Data"). Dimension Data therefore does not accept liability for any claims, loss or damages of whatsoever nature, arising as a result of the reliance on such information by anyone. Whilst all reasonable steps are taken to ensure the accuracy and integrity of information transmitted electronically and to preserve the confidentiality thereof, Dimension Data accepts no liability or responsibility whatsoever if information or data is, for whatsoever reason, incorrect, corrupted or does not reach its intended destination. *************************************************************************************