RE: PCTUSED, PCTFREE... help, help
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 11 Nov 2008 11:54:24 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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]
Other related posts:
