Database Administration

GeekInterview.com > Interview Questions > Oracle > Database Administration

Go To First | Previous Question | Next Question

Database Administration | Question 230 of 231

PCT Free

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

Total Answers and Comments: 3

Last Update: August 13, 2009 Asked by: gyanudba

Sponsored Links

Best Rated Answer

—

Submitted by: harimanavalan

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.

Above answer was rated as good by the following members:
m4k4v3l1, aravindhreturns

February 25, 2009 11:24:43

harimanavalan

Member Since: February 2009 Contribution: 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.

Is this answer useful? Yes | No

2 0

Overall Rating: +2

July 01, 2009 06:08:04

m4k4v3l1

Member Since: July 2009 Contribution: 3

RE: PCT Free

PCT Used :
Equals 100 - PCT Free Also It states the used space in the data file by records

If PCT used was set to 60 this means
If the data inside the block is 60 it
is FULL
If data inside the block is 59 it is Empty

Is this answer useful? Yes | No

0 1

Overall Rating: -1

August 12, 2009 18:55:59

refakat

Member Since: August 2009 Contribution: 1

RE: PCTUSED

This is the parameter which specify in percent that a block can only used for insert or come in the freelist(list of blocks in segment ready for insert operation) when used space in a block is less than PCTUSED.
Suppose value of pctused is 40 and pctfree is 20 then data can be inserted till 80 of the block directly. And suppose the used space is 60 and some one has perform a delete operation in a row in the same block which brings the used space to 50 .Now one cannot insert any record in the same block unless the used space comes down below 40 i.e. pctused.

Is this answer useful? Yes | No

0 1

Overall Rating: -1

Go To Top

User Name		Remember Me?
Password

Question Bank