What is pct free/pct used/pct increase parameter in segment?
- 1 Answers
- 649 Views
- I also Faced
- E-Mail Answers
Answer / Parmanand Kumar
PCTFREE, PCTUSED, and PCTINCREASE are parameters that control the management of extents in an Oracle segment. PCTFREE specifies the percentage of free space left in each block when a new row is inserted. PCTUSED specifies the minimum percentage of used space in a block before it can be considered for reuse. PCTINCREASE determines the incremental allocation for extents.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the different responsibilities of a dba?
How can you determine if an oracle instance is up from the operating system level?
What are the beneficial tools for administering the database?
How long does it take to learn database administration?
What is the difference between internal & external schema?
What are the possible ways to gain information regarding the control file?
How do I become a data manager?
How do you set up your tablespace on installation level: low?
When configuring sqlnet on the server what files must be set up?
What is the purpose of the grep command?
What are the different types of backup available in the oracle?
What is the difference between truncate and delete? How would a full table scan behave after?
Oracle General 
