Interested to Buy Any Domain ? << Click Here >> for more details...
What is the role of PCTFREE parameter is Storage clause ?
- 2 Answers
- 5877 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 User Process?
How to implement the multiple control files for an existing database ?
What do Redo Log Buffers contain?
What are the consideration at tehe migration of Oracle 9i to 10G.
What is an Oracle Data Dictionary?
What constitute an ORACLE Instance?
When does LGWR write to the database?
What is hit ratio ?
What is an Oracle Data Segment?
What are the uses of Oracle Rollback Segment?
What are the functions of SMON?
Name the ORACLE Background Process?
Oracle General 
