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
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
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
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
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
: 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
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 ?
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
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
(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
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
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
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
]
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
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
: 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
16 matches
Mail list logo