Page 1 of 1

Quenstion PCTFREE while creating tablespace

PostPosted: Thu Jan 24, 2013 9:54 am
by fornanthakumar
Hi,

Good Day.

Could you anyone assist me on the below question ?

While creating TABLESPACE we are using PCTFREE where howmuch percentage should leave in a page which helps for future insertions.

Incase if i mention PCTFREE 100 then what wil happen ? Please advise.

Re: Quenstion PCTFREE while creating tablespace

PostPosted: Thu Jan 24, 2013 1:53 pm
by enrico-sorichetti
While creating TABLESPACE we are using PCTFREE where howmuch percentage should leave in a page which helps for future insertions.


only the people who designed the application can tell ...
they know the insertion pattern and rate values
WE DO NOT