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

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Thu, 5 Feb 2004 21:01:52 +0200
Message-ID: <20a101c3ec1a$84447690$eafb23d5@porgand>

> 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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Feb 05 2004 - 13:01:52 CST