Re: SYSTEM and SYSAUX Tablespace Opinions Requested

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 11 Sep 2007 21:30:03 +0200
Message-ID: <fc6qbn$g5m$1@news5.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

DA Morgan wrote:
> Frank van Bortel wrote:

>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
[major snip]

>>
>> Any thoughts on granting quota to users on SYSAUX
>> - --
>> Regards,
>> Frank van Bortel

>
> According to my understanding of what Oracle has documented we are
> supposed to treat SYSAUX with the same "hands-off" we do SYSTEM.
>
> Here's what the docs say:
> "The SYSAUX tablespace serves as an auxiliary tablespace to the SYSTEM
> tablespace. Because it is the default tablespace for many Oracle
> Database features and products that previously required their own
> tablespaces, it reduces the number of tablespaces required by the
> database and that you must maintain. Other functionality or features
> that previously used the SYSTEM tablespace can now use the SYSAUX
> tablespace, thus reducing the load on the SYSTEM tablespace."
>
> http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/create003.htm#BABFHHAG
>

So? I used to do that manually (alter about every script that remotely did 'create user') since 8.0.

Making sure all these nice (sub-)systems like Context and statspack ended up in a tablespace where they belonged: anywhere outside of SYSTEM, where Oracle put them by default, in spite of every manual advocating not to do so.

OK - So finally Oracle realized it should handle the issue, and it creates SYSAUX. BTDT,BTTS.

In the days, I did this manually, stuff would end up in TOOLS, UTILS, or even USERS - whatever the name of the tablespace was. There's nothing against putting objects of ordinary users in TOOLS, UTILS, or USERS, too.

So, why would there be problem in loading objects into SYSAUX?

• -- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFG5uy7Lw8L4IAs830RAkKVAKCXFixjcHHq6D89IRzf2NcYNYRevACgnpum GMpeOzAqKW1YYIU69JKAQrg=
=Oafa
-----END PGP SIGNATURE----- Received on Tue Sep 11 2007 - 14:30:03 CDT