Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: temporary segments
<terrysutton_at_usa.net> writes:
> Kenneth C Stahl wrote in message <37F0E095.150B8686_at_Unforgettable.com>...
I have finally figured this out. When Oracle grabs a new extent it is created at the begining of a free extent, but not the first free extent. I seems to choose the free extent at random. I noticed this when I had to rebuild an index. With a coalesced tablespace Oracle started grabing space at the begining of the tablespace until it was filled. For the next index I had to rebuild the temporary tablespace was fragmented with free extents. Oracle started grabing free extents at random until the tablespace was filled. It was kind of neat to watch it with tablespace manager.
So armed with this new information I set the pctincrease of the tablespace to 1 so that when the DB was shutdown at night the tablespace was automatically coalesced. When the DB started up again my temporary segments were at the beginning of the tablespace and not at the end.
p.s. I'm usually a command-line sql*plus kind of guy, but this is one situation where a GUI came in handy.
--
David F. Newman
Oracle DBA
dnewman_at_ourvillage.com
Received on Fri Oct 01 1999 - 11:46:39 CDT
![]() |
![]() |