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,pctfree,pctused.
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 is an oracle database schema?
1.Explain the three levels with the help og a diagram.
Can a Tablespace hold objects from different Schemes in Oracle?
How to define Data Block size in Oracle?
What Does DBWR do?
List the factors that can affect the accuracy of the estimations ?
How to find the current session sid
What is the function of ARCH?
How will you monitor rollback segment status ?
How to find the SGA Size
How the log writer writes the data into database
What is an Oracle Data Block?