Re: SYSTEM's default and temp tablespace

Hi Joel,

It will go away - normally immediately, unless the sort was done in a recursive call in which case it may take a couple of hours or more. The only way to make an inactive temporary segment in the SYSTEM tablespace persist indefinitely is to set event 10061.

Nevertheless, I also vote for the TOOLS/TEMP setup for the SYSTEM user, as well as SYSTEM/TEMP for the SYS user.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/

On Mon, 19 Jun 2000 20:37:38 GMT, Joel Garry <jgarry_at_my-deja.com> wrote:

>In article <394E2846.1F629839_at_mar.dfo-mpo.gc.ca>,
> James Hanway <hanwayj_at_mar.dfo-mpo.gc.ca> wrote:
>> Morning all,
>>
>> Whats the general rule for the SYSTEM account's default/temporay
>> tablespaces?
>>
>> I've always thought *both* should be set to the SYSTEM tablespace, but
 I
>> have seen a number of other setups like: SYSTEM/TEMP, TOOLS/TEMP, etc.
>> Is SYSTEM/SYSTEM the generally accepted defualt/temporary tablespace
>> setup?
>
>If you should happen to run a sort as system (say, to generate some
>management reports), and the sort happens to require more space than
>sort_area_size (hey, it could happen), then a temporary segment will be
>created in the system tablespace. This does not go away, since Oracle
>thinks if you used it once, you will probably use it again, so it hangs
>around in your system tablespace. Naturally, system tablespace is
>critical, and there is no {cheap|sane} way to defragment it, so the net
>effect is you are using up a critical resource for no good reason.
>
>jg
>--
>These opinions mine
>mailto:joel-garry_at_nospam.home.com
>Remove nospam to mail
>http://ourworld.compuserve.com/homepages/joel_garry
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Jun 20 2000 - 00:00:00 CDT