What is the role of PCTFREE parameter is Storage clause ?
Answers were Sorted based on User's Feedback
Answer / vivek
pctfree is only used for future updation, not for inserts.
|Is This Answer Correct ?||3 Yes||0 No|
Answer / ankur aggarwal
A oracle block divided into three parts.
block header :its contain the information datafiles.
pctfree: its a free space in a datablock for updation and
insertion of a row.default is 10% of a block size.one more
thing it's default value is depand of OS also.
pctused : its a space where data are store in a block.its
default value is 40% of a block size.
|Is This Answer Correct ?||6 Yes||4 No|
What Does DBWR do?
What are the functions of SMON?
How the space utilisation takes place within rollback segments?
What does LGWR do?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
Which parameter in Storage clause will reduce no. of rows per block?
How will you monitor the space allocation ?
What is the function of checkpoint(CKPT)?
What is an Oracle SYSTEM tablespace and when is it Created?
What is an Integrity Constrains in Oracle?
How many Dispatcher Processes are created?
What is hit ratio ?