RE: Determine process of index build

From: George Leonard (ZA) <George.Leonard_at_za.didata.com>
Date: Mon, 30 Sep 2002 05:38:23 -0800
Message-ID: <F001.004DC480.20020930053823@fatcity.com>

Content-Type: text/plain

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:george.leonard_at_za.didata.com
Web: http://www.didata.co.za <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-----
Sent: 30 September 2002 14:38 PM
To: Multiple recipients of list ORACLE-L

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.

------_=_NextPart_001_01C2687E.3798BD40
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=3D"urn:sc= hemas-microsoft-com:office:word" xmlns:st1=3D"urn:schemas-microsoft-com:off= ice:smarttags" xmlns=3D"http://www.w3.org/TR/REC-html40">

<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 10">
<meta name=3DOriginator content=3D"Microsoft Word 10">
<link rel=3DFile-List href=3D"cid:filelist.xml_at_01C2688F.2FFCBDA0">
<title>RE: Determine process of index build - HOW</title>
<o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"

name=3D"time"/>
<o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"PersonName"/>
<!--[if gte mso 9]><xml> <w:WordDocument>

  <w:SpellingState>Clean</w:SpellingState>
  <w:GrammarState>Clean</w:GrammarState>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>

</w:WordDocument>
</xml><![endif]--><!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }

</style>
<![endif]-->
<style>
<!--

/* Font Definitions */
@font-face

	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;
	mso-font-charset:0;
	mso-generic-font-family:swiss;
	mso-font-pitch:variable;
	mso-font-signature:1627421319 -2147483648 8 0 66047 0;}

/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal

	{mso-style-parent:"";
	margin:0cm;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;
	text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;
	text-underline:single;}
p
	{mso-margin-top-alt:auto;
	margin-right:0cm;
	mso-margin-bottom-alt:auto;
	margin-left:0cm;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
span.EmailStyle18
	{mso-style-type:personal-reply;
	mso-style-noshow:yes;
	mso-ansi-font-size:10.0pt;
	mso-bidi-font-size:10.0pt;
	font-family:Arial;
	mso-ascii-font-family:Arial;
	mso-hansi-font-family:Arial;
	mso-bidi-font-family:Arial;
	color:navy;}
span.SpellE
	{mso-style-name:"";
	mso-spl-e:yes;}
span.GramE
	{mso-style-name:"";
	mso-gram-e:yes;}
@page Section1
	{size:612.0pt 792.0pt;
	margin:72.0pt 90.0pt 72.0pt 90.0pt;
	mso-header-margin:35.4pt;
	mso-footer-margin:35.4pt;
	mso-paper-source:0;}
div.Section1
	{page:Section1;}

-->

</style>
<!--[if gte mso 10]>
<style>

/* Style Definitions */=20
table.MsoNormalTable

	{mso-style-name:"Table Normal";
	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	mso-style-noshow:yes;
	mso-style-parent:"";
	mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
	mso-para-margin:0cm;
	mso-para-margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.0pt;
	font-family:"Times New Roman";}
</style>

<![endif]-->
</head>

This is a query I build to see this, <=
/span><st1:time

Hour=3D"0" Minute=3D"0">midnight</st1:time> Saturday<o:p></o:p>

<o:p> </o:p>

Comment welcome<o:p></o:p></fon= t>

<o:p> </o:p>

column</font= > "% Done" format 999.99<o:p></o:p>

column</font= > opname format a15<o:p></o:p></span= >

column</font= > sql_text format a70<o:p></o:p></sp= an>

select</font= ><o:p></o:p>

=            (a.sofar/a.totalwork)*100 "% Done",<o:p></o:= p>

=            to_char(a.last_update_time, 'HH24:MI:SS'),<o:p></o:p><=
/font>

=            a.time_remaining "T Left",<o:p></o:p></span= >

=            a.opname ,<o:p></o:p>

from<=
/span><font

size=3D2 color=3Dnavy face=3DArial> v$session_longops a, v$session
b, v$sqltext s<o:p></o:p>

where= a.sid =3Db.si= d<o:p></o:p>

and</= span> b.sql_address =3D s.address<o:p></o:p>

and</= span> a.sofar <> a.totalwork<o:p></o:p>

order= by b.sid, las= t_update_time<o:p></o:p>

/<o:p></o:p>

<o:p> </o:p>

<div>

George<= font
color=3Dnavy><o:p></o:p>=

<span style= =3D'font-size:

10.0pt;font-family:Arial;color:navy;mso-no-proof:yes'>_____________________=
___________________________</span></font><font

color=3Dnavy><o:p></o:p>=

<st1:PersonName>G= eorge
Leonard</st1:PersonName><o:p></o:p>

Oracle Database Administrator<o:p></o:p>

Dimension Data (Pty) = Ltd<o:p></o:p>=

(Reg. No. 1987/006597=
/07)<font

color=3Dnavy><o:p></o:p>=

Tel: (+27 11) 575 0573<o:p></o:p>

Fax: (+27 11) 576 0573<o:p></o:p>

E-mail:george.leonard= @za.didata.com<o:p></o:p>=

Web:   <a href=3D"http://www.didata.co.za">http://www.didata.co.za</a><= font
color=3Dnavy><o:p></o:p>=

<= span
style=3D'font-size:12.0pt;color:navy;mso-no-proof:yes'> <o:p></o:p></s= pan>

You Have The Obligati= on
to Inform One Honestly of the risk, And As a Person<o:p></o:p>=

You Are Committed to Educate Yourself to the Total Risk In Any Activity!<o:p></o:p>=

Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit!<o:p></o:p>

</div>

-----Original Message----- From: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni_at_espn.com] Sent: 30 September 2002 14:38 PM To: Multiple recipients of l= ist
ORACLE-L 
Subject: RE: Determine proce= ss of
index build - HOW

<o:p> </o:p>=

<sp= an
style=3D'font-size:10.0pt'>v$session_longops .... select with last_update_t= ime
desc and use the sid ... it is pretty cool .. it will also tell you for "current operation" how many seconds are remaining.= <o:p></o:p>

<sp= an
style=3D'font-size:10.0pt'>Raj

<font size=3D2><span style=3D'font-size:10.0pt'>___________________________=
___________________________</span></font>

Rajendra Jamadagni &nb= sp;            MIS, ESPN Inc. 
Rajendra dot Jamadagni at E= SPN dot
com 
Any opinion expressed here = is
personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have fac= ts, but
having an opinion is an art! <o:p></o:p>

</div>

<CODE>

***************************************************************************=

************ 
 
This message contains information intended solely for the addressee, which is confidential or private in nature and subject to legal privilege.<= BR>
If you are not the intended recipient, you may not peruse, use, disseminate, distribute or copy this message or any file attached to this<B= R>
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<B= R>
personal views and opinions of the author, which are not necessarily the views and opinions of Dimension Data (South Africa) (Proprietary) Limited<B= R>
or its subsidiaries and associated companies ("Dimension Data"). Dimension<= BR>
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. <B= R>

***************************************************************************=
**********<BR>
 	<BR>

</CODE>
</body>

</html>

------_=_NextPart_001_01C2687E.3798BD40--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: George Leonard (ZA)
  INET: George.Leonard_at_za.didata.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Sep 30 2002 - 08:38:23 CDT