SEO

#1 (**permalink**) 02-25-2008, 01:51 PM

I'm trying to modify pctused on a table, the alter table command does
not return an error, but the pctused value does not get changed. I've
tried to alter the table through GUI and with an alter command, but the
value does not get set.

I ran a SELECT * FROM USER_TABLES and it appears the pct_used value
for all tables in the scheme are not set (null). I was under the
impression the default for pctused was 40.

Why do they all appear as null and why can I not set them?

We're running Oracle9i, standard edition with locally managed
tablespaces(does this have something to do with it?)

Thx in advance

#2 (**permalink**) 02-25-2008, 01:51 PM

aprins...@sagetelecom.net wrote:
> I'm trying to modify pctused on a table, the alter table command does
> not return an error, but the pctused value does not get changed. I've
> tried to alter the table through GUI and with an alter command, but the
> value does not get set.
>
> I ran a SELECT * FROM USER_TABLES and it appears the pct_used value
> for all tables in the scheme are not set (null). I was under the
> impression the default for pctused was 40.
>
> Why do they all appear as null and why can I not set them?
>
> We're running Oracle9i, standard edition with locally managed
> tablespaces(does this have something to do with it?)
>
> Thx in advance

Are you using ASSM?

http://download-east.oracle.com/docs...tance_tune.htm
"Automatic segment-space management in locally managed tablespaces
eliminates the need to specify the PCTUSED, FREELISTS, and FREELIST
GROUPS parameters. If possible, switch from manual space management to
automatic segment-space management (ASSM)."

http://download-east.oracle.com/docs...ments_3001.htm
"For segments with automatic segment-space management, the database
ignores attempts to change the PCTUSED setting. If you alter the
PCTFREE setting, then you must subsequently run the
DBMS_REPAIR.SEGMENT_FIX_STATUS procedure to implement the new setting
on blocks already allocated to the segment."

Also, same document above:
"You cannot specify the PCTUSED parameter in segment_attributes for the
index segment of an index-organized table."

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Cannot change pctused