And if
you have OEM/DBA Studio, you can watch the progress graphically.. :)
-
Kirti
-----Original Message-----
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 7:38 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Determine process of index build - HOW
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 7:38 AM
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!
