In article <6pjpm5$qi3$1_at_nnrp1.dejanews.com>,
gplagge_at_hotmail.com wrote:
> Hi, we are running Oracle 8.0.4 in an NT 4.0 environment.
>
> I am attempting to create an index (concatenated
> on 2 columns) on a table with 16 million rows. So
> far, it has been running for over 24 hours, and I
> have 4 more to build! I am using the norecover and
> parallel options
>
> The system is very quiet other than the one create
> index command, and one select statement.
> Thanks for any help.
If your system is *completely* quiet, check out
v$rollstat if there is still write activity on
the rollback segments.
Also, check your ALERT.LOG for messages like
'could not acquire new log, archival required'.
Maybe you are running in ARCHIVELOG mode with
automatic archival *not* enabled.
(Check out the command
archive log list).
--
Robert Graf-Waczenski e-mail: rtgraf_at_sintec.de
Visit our web site! http://www.sintec.de
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Jul 28 1998 - 09:04:56 CDT
