Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: temporary segments

Re: temporary segments

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: Tue, 28 Sep 1999 11:36:53 -0400
Message-ID: <37F0E095.150B8686@Unforgettable.com>


Not necessarily. I've seen this type of thing many times. There really doesn't seem to be any rhyme or reason as to why segments are built at a particular location.

I suspect (but have not been able to prove) that if you were to do a ALTER TABLESPACE COALESCE it would probably reset things so that Oracle would start at the first empty block, but there doesn't seem to be any guarentees of that either. The thing that appears to be happening here is the engine itself is building temporary segments for its own purposes and that may be perfectly valid under any number of circumstances so the question becomes whether you hide them away in the SYSTEM tablespace and forget they even exist or tolerate them being in the designated tablespace for temporary segments chiefly used by user applications.

"David F. Newman" wrote:
>
> Kenneth C Stahl <BlueSax_at_Unforgettable.com> writes:
>
> > That doesn't answer the question. Do you have temporary tablespace for SYS
> > or SYSTEM pointed at the tablespace which you have designated for temporary
> > segments? If so, then either SYS or SYSTEM is building temporary segments
> > there and it is quite normal. If you want to get rid of them, point
> > temporary tablespace for SYS and SYSTEM at the SYSTEM tablespace and then
> > bounce the database. At that point you should be able to shrink the
> > tablespace.
> >
>
> If the database is bounced then won't the temporary segments go
> away? And then when the database comes back up and sys and system
> start generating temporary segments again won't they start at
> the beginning of the tablespace and not at the end?
>
> --
> David F. Newman
> Oracle DBA
> dnewman_at_ourvillage.com
Received on Tue Sep 28 1999 - 10:36:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US