Re: PCTUSED Value

From: Ilia Bashtanov <iliab_at_mmc.ru>
Date: 1997/04/14
Message-ID: <01bc489a$415a1f40$25d9bec2_at_ib>#1/1


select pct_used
from all_tables
where owner = 'TABLE_OWNER'
  and table_name = 'TABLE_NAME'
;

-- 

~~~~~~~~~~~~~~~~~~~~~~~~~~~
Ilia Bashtanov
iliab_at_mmc.ru
phone +7 (095) 974 30 30
fax   +7 (095) 974 30 20
~~~~~~~~~~~~~~~~~~~~~~~~~~~

Thomas Kremer <Thomas.Kremer_at_orechem.NOSPAM.com> wrote in article
<334e7a93.10558081_at_news.superlink.net>...

> Hi,
>
> how can I display the value of PCTUSED of a table in oracle. I know
> how to set it, but I would like to know how to see the actual value?
>
> Thanks a lot
>
Received on Mon Apr 14 1997 - 00:00:00 CEST

Original text of this message