Fred Stojentin wrote:
>
> On Wed, 12 Jan 2000 14:59:22 -0500, "CGS" <tcgs_at_hotmail.com> wrote:
> >Do Analyze (tables and indexes) and Coalesce (tablespace) lock the
> >tables or prevent the users from accessing the tables?
> >
> "analyze table ${TAB} ...", "alter index ${IND} ... rebuild ..." and
> such tasks should be done at night. They lock the index(es) while
> analyzing/rebuilding, which can take a long time on big tables/indexes
> (1/2 hour for a 2 GB sized Index).
The only analyze command that locks the table is "analyze table validate
structure;" The normal analyze commands do not block other users. In 8i,
index rebuilds can also be performed without blocking other sessions.
--
Jeremiah
Received on Thu Jan 13 2000 - 11:30:25 CST
