Interested to Buy Any Domain ? << Click Here >> for more details...
What is the role of PCTFREE parameter is Storage clause ?
- 2 Answers
- 6106 Views
- I also Faced
- E-Mail Answers
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 the role of archiever
• What is oracle Architecture?
What is the function of ARCH?
What is advantage of having disk shadowing/ Mirroring ?
What are the two types of Server Configurations?
What is SGA?
What is an Oracle SYSTEM tablespace and when is it Created?
What is function of RECO?
What is an Oracle Rollback Segment?
How can you find the size of a database?
What is an Oracle Data Segment?
What is Dedicated Server Configuration?
Oracle General 
