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
earlier, I think.
Yes, what you state is correct.
Jraed
[EMAIL 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
: 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
No, it is not retrospective.
You are setting parameters to be used when the next extent is created.
A better example is when setting next extent size to be different than the
existing extent size (dictionary managed tablespaces only).
It does not alter all the existing extents it only works on
Are you sure about that John?
On Tuesday 24 September 2002 04:28, [EMAIL PROTECTED] wrote:
No, it is not retrospective.
You are setting parameters to be used when the next extent is created.
A better example is when setting next extent size to be different than the
existing extent size
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 that if a table is fully loaded upto its pctfree/pctused limits
I'm not sure either as I am rereading a document by
Craig Shallamaher where he is saying to change pctused
and pctfree in order to reduce data block
fragmentation. I have to test that.
At my new job, the DBAs are doing massive
export/import to reduce fragmentation... (with their
dictionnary
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
John,
You are right, I just find out note 1029850.6 on
metalink : A block is relinked to a free list if
after DELETE or UPDATE operations, the percentage of
the used space falls below PCTUSED.
--- [EMAIL PROTECTED] a écrit : Well I was
sure about it until you had the temerity
to
: 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
15 matches
Mail list logo