Re: selecting the HWM of a table

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Wed, 14 Feb 2001 00:22:42 GMT
Message-ID: <3a89cfb1.246934553@nsw.nnrp.telstra.net>

Hi Herman,

Have a look at DBMS_SPACE.UNUSED_SPACE.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

-----Original Message-----
From: Harmonie Euterpe <Euterpe-Emmen_at_hetnet.nl>

Dear guru's,

is there a way to directly select the current high water mark of a (normal) table from the data dictionary or the shared pool?

I don't want to (1) analyze the table and (2) lookup the blocks column in dba_tables. I don't want to make a blockdump from the table's segment header as well.

Just a plain select must do!
Any (plsql) tricks are allowed.

Kind Regards,

Herman de Boer. Received on Tue Feb 13 2001 - 18:22:42 CST