Subject: RE: PCTUSED - when
is block added to freelist?
[EMAIL PROTECTED]
09/04/2002 11:03
AM
Please respond to
ORACLE-L
Yes, that's what I inte
from user_tables
09:34:50 3 where table_name = 'FB'
09:34:50 4 /
BLOCKS EMPTY BLOCKS
---
70
1 row selected.
09:34:50 rsysdevdb.radisys.com - jkstill@dv01 SQL>
09:34:50 rsysdevdb.radisys.com - jkstill@dv01 SQL> set echo off
cc:
Sent by: Subject: RE: PCTUSED - when is block
added to freelist?
[EM
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
action
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
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 l
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: Tues