RE: PCTUSED, PCTFREE... help, help

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 11 Nov 2008 11:54:24 -0500
Message-ID: <D1DC33E67722D54A93F05F702C99E2A9031CA087@usahm208.amer.corp.eds.com>

If the table is assigned to a tablespace that was created using ASSM then Oracle managed the pct_used and it is null when selected from dba_tables.  

Is the assigned tablespace using ASSM?  

• Mark D Powell -- Phone (313) 592-5148

  ---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kline.Michael

	Sent: Tuesday, November 11, 2008 11:48 AM
	To: Oracle-L
	Cc: mckenzie.john
	Subject: PCTUSED, PCTFREE... help, help
	
	
	
	
	
	
	
	Having a hard time finding out just where these things seemed to

have all but disappeared.         

        Listing tables in one of my tablespaces I have the combinations of:

	Pct_Free      Pct_Used
	Null           null
	10            null
	10            40
	
	It seems I can SET pct_free, but while it tells me it will set

pct_used, the select always comes up null.         

        Now I assume that this has to do with auto management, but where are the rules and if for some reason we needed to tweak them, how would we go about doing that.         

        We converted databases and used import/export to move them to a new box. On the old box it was mostly 10/40, but on the new box we are finding 10/null. The user is claiming that it is much slower all because we don't have the 40 in pct_used. I bet it's been 8 years since I played with the setting and found the "opportunity" listed above. I would think the auto management would take care of this for us.         

        Is there a good write up on it some place? Haven't found much other than "how to set" and that doesn't seem to be working. Database is 10.2.0.3 on HP/UX.         

	Michael Kline
	Database Administration
	Richmond, Va.  23227
	BlackBerry: 804.517.7443 
	
	 
	 
	LEGAL DISCLAIMER
	The information transmitted is intended solely for the

individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.          

        SunTrust and Seeing beyond money are federally registered service marks of SunTrust Banks, Inc.

        [ST:XCL]

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 11 2008 - 10:54:24 CST