]
house.com cc:
Sent by: Subject: RE: PCTUSED - when
is block added to freelist?
[EMAIL PROTECTED]
09/04/2002 11:03
AM
Please respond
Yes, that's what I intended to ask :).
Thanks, Jared.
Jay
-Original Message-
Sent: Tuesday, September 03, 2002 9:18 PM
To: Multiple recipients of list ORACLE-L
If I understand Jay's question correctly, what he's asking is
not how PCTUSED and PCTFREE work, but what action or
[EMAIL PROTECTED]
house.com cc:
Sent by: Subject: RE: PCTUSED - when is block
added to freelist?
[EMAIL PROTECTED
respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: PCTUSED - when is block added to freelist?
See Note: 1029850.6 on MetaLink for more details but here is algorithm
used
for freelist
1- Delete means freeing space.
2- When the used space in the blocks falls below PCTUSED, the block needs to
go back to the free list.
3- This requires extra processing cost.
4- So lowering PCTUSED will lower the frequency of triggering this
procedure.
Waleed
-Original Message-
Sent:
Title: RE: PCTUSED - when is block added to freelist?
The way I understand it:
If you have a low pctused, then you have less blocks being moved to the freelist (because it's less probably that a block will be moved to the freelist): so reduced processing costs during update (if a row length
If I understand Jay's question correctly, what he's asking is
not how PCTUSED and PCTFREE work, but what action or
actions trigger Oracle to put a block back on the freelist after
changing PCTUSED to a higher value?
Is that correct Jay?
Jared
On Tuesday 03 September 2002 15:38, Miller, Jay