Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Determine number of blocks above HWM and below HWM
Analyze the table, then look at blocks and empty_blocks in dba_tables. Or
use dbms_space. Only way to reset is to truncate the table.
"Akin S. Walter-Johnson III" <asjohns_at_uchicago.edu> wrote in message
news:eIR2a.60$K4.25165_at_news.uchicago.edu...
> Anyone knows how to determine number of blocks above and below the High
> water mark, and if so
> how can I reset the HWM.
>
>
Received on Thu Feb 13 2003 - 14:30:16 CST