On Aug 17, 5:49 pm, Otto Carl Marte <Otto.Ma...@gmail.comwrote:
On Aug 17, 4:26 am, <nint...@126.comwrote:
Hi:
how to reduce the tablespace's High water mark?
ths!
The high water mark indicates how "full" the tablespace was. I.e The
maximum number of pages that were used. The only way to reduce it
would be to remove data from your database, which you probably don't
want to do.
Correction, removing data won't decrease the high-water mark, it will
just give you more free pages. Why do you want to reduce the
tablespaces high-water mark?