Re: PctUsed and PctFree when using LMT and 9.2.0.4 on Aix

  • From: "Tanel Poder" <tanel.poder.003@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 5 Feb 2004 21:01:52 +0200

> I just found something in the 9i documentation that indicates that Pctused
> is only valid for "Manually Managed Tablespaces".  I guess that means that
> it is not used for Locally Managed Tablespaces.

Manually managed tablespaces are tablespaces which segments use freelists
for keeping track of insertable blocks.
Automatic segment space tablespaces are LMT tablespaces which use bitmaps
for same purpose. Unlike ASSM tablespaces, "manually managed" tablespaces
can be either LMTs or DMTs.

Tanel.


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: