GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  Database Administration

 Print  |  
Question:  PCT Free

Answer: What is PCT Free and PCT Used?
What is PCT increase parameter in segment?
What is growth factor?


February 02, 2009 11:24:43 #1
 harimanavalan   Member Since: February 2009    Total Comments: 1 

RE: PCT Free
 
PCTFREE is a block storage it use to mention how much space should be left in database block for future updates (updating the records eg. previously name kalyan after that we will update the name as kalyan kumar). If mention PCTFREE as 10, oracle will adding the new rows to block upto 90% Its allows 10% for future updates.
     

 

Back To Question