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 |
Can a Tablespace hold objects from different Schemes in Oracle?
what is the role of archiever
How does Space allocation table place within a block ?
What is meant by recursive hints ?
What is PGA?
How many Dispatcher Processes are created?
What are functions of PMON?
What is Dedicated Server Configuration?
What are the consideration at tehe migration of Oracle 9i to 10G.
What is a Control file ?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
How will you monitor the space allocation ?