i read some oracle documentation that recommends you keep the number of extents below
1024.
do you feel that this is inaccurate in an LMT? What if Im stuck with dictionary
tablespacse and am not allowed to change? Does it matter? I do keep all my extents
uniform. I thought there were issuse
What Oracle documentation would that be?
At 09:39 AM 5/30/2003 -0800, you wrote:
i read some oracle documentation that recommends you keep the number of
extents below 1024.
do you feel that this is inaccurate in an LMT? What if Im stuck with
dictionary tablespacse and am not allowed to change?
: Friday, May 30, 2003 1:15 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: Tablespace management.
What Oracle documentation would that be?
At 09:39 AM 5/30/2003 -0800, you wrote:
i read some oracle documentation that recommends you keep
the number of
extents below 1024.
do
To quote the paper:
Oracle supports an unlimited number of extents in a segment. The
performance for DML operations is largely independent
of the number of extents in the segment. However, certain DDL operations
such as dropping and truncating of segments are
sensitive to the number of extents.
-Original Message-
From: Wolfgang Breitling [mailto:[EMAIL PROTECTED]
Sent: Friday, May 30, 2003 4:00 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: Tablespace management.
To quote the paper:
Oracle supports an unlimited number of extents in a segment. The
performance