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?
>
"alter tablespace ${TS} coalesce" can be done always without impact on
running sessions (under normal circumstances) and it is done very fast
(some seconds).
"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).
Fred Stojentin
Received on Thu Jan 13 2000 - 04:27:31 CST
