Re: Locally Managed vs Dictionary managed tablespaces

From: Howard J. Rogers <howardjr_at_www.com>
Date: Fri, 2 Nov 2001 21:41:58 +1100
Message-ID: <3be27853$0$1779$afc38c87@news.optusnet.com.au>

No, PCT_FULL is the fullness percentage of the data file as it is currently sized. PCT_UTIL is the percentage full of what the file could possibly grow to be -it takes account of autoextend and any possible maxssize clause.

I can only show you the following screen dump to assure you that the columns are not the same at all:

TABLESPACE_NAME                   MB_USED    MB_SIZE   PCT_FULL    MB_FREE

MB_MAXSIZE PCT_UTIL

------------------------------ ---------- ---------- ---------- ---------- -
--------- ----------
INDX                                    0         10          1      16384
16384          0
SYSTEM                                 87        110         79      16297
16384          1
TOOLS                                   0         10          1      16384
16384          0
UNDOTBS                                 1         80          2      16383
16384          0
USERS                                   1         15          5      16388
16389          0

(Sorry for the spacing etc).

But you'll notice SYSTEM is 79% full, based on the fact that the file is 110Mb big, and 87Mb of it have been used. But PCT_UTIL is only 1% -because the file is autoextensible without limit (I gues 16Gb is NT's version of "unlimited"), and 87Mb/16Gb is trivial.

Regards
HJR

--

Oracle Resources : http://www.geocities.com/howardjr2000
========================================


"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
news:E2F6A70FE45242488C865C3BC1245DA72D5362_at_lnewton.leeds.lfs.co.uk...


> Howard,

>

> call me an idiot if you like - everybody else does, but don't you have

> two columns the same in that query ?

> PCT_FULL and PCT_UTIL are the same. Of course, I am probably missing

> something glaringly obvious .....

>

> ROUND((SUM(TOTAL_MB)-SUM(FREE_MB))/SUM(TOTAL_MB)*100) PCT_FULL,

> ROUND((SUM(TOTAL_MB)-SUM(FREE_MB))/SUM(MAX_MB)*100) PCT_UTIL

>

> I use the same query - since I stole it from your web site - but without

> the PCT_UTIL column on the end.

>

>

> Regards,

> Norman.

>

> ------------------------------------------------------------------------

> -----

> Norman Dunbar EMail: Norman.Dunbar_at_LFS.co.uk

> Database/Unix administrator Phone: 0113 289 6265

> Fax: 0113 289 3146

> Lynx Financial Systems Ltd. URL: http://www.Lynx-FS.com

> ------------------------------------------------------------------------

> -----

>

>

Received on Fri Nov 02 2001 - 04:41:58 CST