Determining the PCTFREE

There's a nice post on "How to determine the PCTFREE" over OTN by Anurag Tibrewal.Its worth reading. http://forums.oracle.com/forums/message.jspa?messageID=4062829#4062829 I would be using below way to determine my pctfree based on average row length. Lets take an example. I have a table employee. It has five column - First_Name varchar2(40) - Last_name varchar2(40) - Middle_name varhcar2(30) …

Advertisement