Data Warehousing Community Forum
February 08, 2012, 11:24:31 pm

Pages: [1]   Go Down
  Print  
Author Topic: PCTFREE and PCTUSED parameters ?  (Read 823 times)
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« on: June 25, 2007, 12:19:21 pm »

Hi,

Can anyone please tell me about PCTFREE and PCTUSED parameters?
Where they can be used?

I guess these parameters relates to data blocks.

Please share your thoughts....

Thanks in advance
Logged

Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« Reply #1 on: June 28, 2007, 10:49:51 am »

I am mentioning the definitions of both PCTFREE and PCTUSED parameters

A PCTFREE is a partition of the data bolck that is not filled by rows as tehy are inserted into a table, but is reserved for later updates made to the rows in that block.

PCTUSED is the percentage of space in a data block, which ORACLE attempts to fill before it allocates another block.

Hope I am also not sure about these parameters, But for you, I refered for these...
Logged

If most people said what’s on their minds, they’d be speechless.
Pages: [1]   Go Up
  Print  
 
Jump to: