Interested to Buy Any Domain ? << Click Here >> for more details...
What is the role of PCTFREE parameter is Storage clause ?
- 2 Answers
- 6027 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 maximum size of a oracle9i database?
What is the significance of having storage clause ?
What is Shared SQL Area?
How to define Data Block size in Oracle?
What is an Oracle Data Block?
How many Dispatcher Processes are created?
What is the functionality of SYSTEM table space ?
What do Redo Log Buffers contain?
What is a Multi-threaded Server Configuration?
What is meant by recursive hints ?
How the log writer writes the data into database
What is an Integrity Constrains in Oracle?
Oracle General 
