Re: SYS and SYSTEM users

Hi ,

      Thanks to all gurus.

Regards,
Raman

• Message History ----------------------------------------

From: super_trek_at_email.msn.com on 04/10/2000 04:50 GMT

Please respond to ORACLE-L_at_fatcity.com

To: ORACLE-L_at_fatcity.com
cc:
Subject: Re: SYS and SYSTEM users

The command:

alter user system default tablespace DATA_00
> temporary tablespace TEMP_00;
> alter user system quota unlimited on DATA_00;

The commands above change the system user default tablespace to DATA_00 and the
temporary tablespace to TEMP_00. Any new objects created by the system will
not go into the System Tablespace by default and any sorting performed by the system user will be done in the external tablespace TEMP_00 instead of in the small temp area in the System Tablespace. Essentially, the system user will not using causing contention (disk I/O) on the system tablespace.

Only data dictionary objects and other objects that belong to sys should goes into the System Tablespace.

I hope this help.

Pete

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, October 03, 2000 8:50 PM

> Hi all,
>
> What is the impact in doing the following.
>
> alter user system default tablespace DATA_00
> temporary tablespace TEMP_00;
> alter user system quota unlimited on DATA_00;
> alter user sys temporary tablespace TEMP_00;
>
> These commands are in our database creation scripts. Don't know for what
they did this. Like to know the ups and downs.
> Can gurus comment about this.
>
> Thanks and regards,
> Raman
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: raman.yagna_at_db.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Peter Lee
  INET: super_trek_at_email.msn.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may