George,
I'm not going to answer your question (since it already has been), but
here are some ways to speed up the index builds:
1. ALTER SESSION SET SORT_AREA_SIZE=1;
As long as you have 100 MB of free physical memory on the machine,
doing this before the index build will speed up the
Title: RE: Determine process of index build - HOW
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 AMTo: Multiple recipients of list
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 9
selec
Title: 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 remai
Title: RE: Determine process of index build - HOW
George,
Doing some big index rebuilding myself on this fine weekend. If you know about how big the index will be and the tablespace, you can see how large the temporary segment is at the moment. That can give you a rough idea of how far
Hi there
How can I see how far my index build has is.
I got a table with 43 mil records. It is taking forever as expected but
would like to see how far it is,
Any idea.
Oracle 8.1.6.3 (32Bit) on Solaris 2.6 on Sun E10K
George
George Leonard
Ora