Re: Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-26 Thread Hemant K Chitale
PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2002 09:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Is the effect of modifying PCTFREE/PCTUSED immediate ? Well I was sure about

RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-26 Thread Deshpande, Kirti
PROTECTED] cc: Subject:RE: Is the effect of modifying PCTFREE/PCTUSED immediate ? Well I was sure about it until you had the temerity to question me :) I think we agree on extents sizes not being changed after the event so it is now a discussion on whether

RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-26 Thread Hemant K Chitale
Yes, I think I need to test it for myself and see what I get. As for the busy table in a production environment [24x7, so there's no time to rebuild the table normally], I've put in a request for 30minutes downtime [I am allowed an occassional 15 to 30 minutes every two months] to rebuild the

Re: Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-26 Thread Alan Davey
ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Is the effect of modifying PCTFREE/PCTUSED immediate ? Well I was sure about it until you had the temerity to question me :) I think we agree on extents sizes not being changed after the event so it is now

RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-25 Thread Hemant K Chitale
of modifying PCTFREE/PCTUSED immediate ? If I do an ALTER TABLE tablename PCTFREE 99 PCTUSED1, does this take effect immediately, even for existing blocks. [If so, existing blocks would not get new rows inserted]. Or is it effective only in new Extents ? In that case, existing blocks

Re: Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-25 Thread Alan Davey
: Is the effect of modifying PCTFREE/PCTUSED immediate ? Well I was sure about it until you had the temerity to question me :) I think we agree on extents sizes not being changed after the event so it is now a discussion on whether changes to a pctfree/pctused are retrospective. I contend

RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-25 Thread John . Hallas
Hemant wrote Therefore, to reduce the contention for the hot blocks, I decide to have only 1 row in each block. Normally, with a *NEW* table, PCTFRE 99 and PCTUSED 1 would ensure that I have only 1 row per block. But if I have a large number of blocks in a few extents created when PCTFREE was

Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-24 Thread hkchital
Is the effect of modifying PCTFREE/PCTUSED immediate ? If I do an ALTER TABLE tablename PCTFREE 99 PCTUSED1, does this take effect immediately, even for existing blocks. [If so, existing blocks would not get new rows inserted]. Or is it effective only in new Extents ? In that case

RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-24 Thread John . Hallas
on the next one that is created. HTH John -Original Message- Sent: 24 September 2002 10:58 To: Multiple recipients of list ORACLE-L Is the effect of modifying PCTFREE/PCTUSED immediate ? If I do an ALTER TABLE tablename PCTFREE 99 PCTUSED1, does this take effect immediately, even

Re: Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-24 Thread Jared Still
(dictionary managed tablespaces only). It does not alter all the existing extents it only works on the next one that is created. HTH John -Original Message- Sent: 24 September 2002 10:58 To: Multiple recipients of list ORACLE-L Is the effect of modifying PCTFREE/PCTUSED immediate

RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-24 Thread John . Hallas
managed tablespaces only). It does not alter all the existing extents it only works on the next one that is created. HTH John -Original Message- Sent: 24 September 2002 10:58 To: Multiple recipients of list ORACLE-L Is the effect of modifying PCTFREE/PCTUSED immediate ? If I

Re: Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-24 Thread paquette stephane
recipients of list ORACLE-L Is the effect of modifying PCTFREE/PCTUSED immediate ? If I do an ALTER TABLE tablename PCTFREE 99 PCTUSED1, does this take effect immediately, even for existing blocks. [If so, existing blocks would not get new rows inserted]. Or is it effective

RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-24 Thread Jared . Still
by: [EMAIL PROTECTED] 09/24/2002 09:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Is the effect of modifying PCTFREE/PCTUSED immediate ? Well I was sure about it until you had the temerity

RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-24 Thread paquette stephane
] Sent by: [EMAIL PROTECTED] 09/24/2002 09:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Is the effect of modifying PCTFREE/PCTUSED immediate ? Well I was sure about it until you had

RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-24 Thread paquette stephane
only). It does not alter all the existing extents it only works on the next one that is created. HTH John -Original Message- Sent: 24 September 2002 10:58 To: Multiple recipients of list ORACLE-L Is the effect of modifying PCTFREE/PCTUSED immediate ? If I do

RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?

2002-09-24 Thread Jared . Still
: Is the effect of modifying PCTFREE/PCTUSED immediate ? Well I was sure about it until you had the temerity to question me :) I think we agree on extents sizes not being changed after the event so it is now a discussion on whether changes to a pctfree/pctused are retrospective. I contend