Re: Ownership of Temp Segments

From: Eugene Firyago <efiryago_at_bisys.com>
Date: Tue, 1 Jun 1999 14:42:24 -0400
Message-ID: <7j19i1$oou$1@autumn.news.rcn.net>

That is right. Oracle DBMS, i.e. on behalf the SYS user, is handling temporary segments by itself. You can control a temporary tablespace usage and performance through the tablespace storage parameters and instance initialization parameters which names prefixed by SORT_... (see Oracle Server Reference manual). You just need to avoid a temporary tablespace extensive usage (temp segments allocation particularly) during data sort operation so that most of these operations be done in SGA instead of disk.

Good luck,
Eugene.

Dennis Flinn <dflinn_at_eastman.com> wrote in message news:37542002.F870876A_at_eastman.com...
> I was wondering if anyone knew how to tell who is using segments in
> temporary tablespace. We are running primarily Oracle v7.3.x but the
> question also applies to Oracle 8.x. We can see segment being used in
> the temporary tablespace, but would like to find out who is using them.
> We have looked at dba_segments but the owner always appears to be SYS.
>
> Thanks,
> Dennis
Received on Tue Jun 01 1999 - 13:42:24 CDT