Re: Use of SYSTEM tablespace

In article <38912D5A.28E26E1D_at_erols.com>,   Jerry Gitomer <jgitomer_at_erols.com> wrote:
> ed.stevens_at_home.com wrote:
> >
> > When we first stated setting up our Oracle databases, neither of our
> > DBAs had any Oracle experience (I was just coming into DBA from
apps,
> > the other was coming to Oracle from DB2), so we were feeling our way
> > along. After a few iterations and a lot of reading (and having a
few
> > databases already in production) we reviewed what we had done and
came
> > up with some standards, but they were still from a position of a
lot of
> > ignorance. That brings us to where we are today, and my question.
> >
> > While we knew to make data and index tablespaces for the application
> > data, we still defaulted user SYSTEM to the system tablespace.
> > Everything I'm reading is telling me that only SYS should own
objects
> > in the system tablespace. My partner is very much a "if it ain't
> > broke, don't fix it" person, and I'm having a difficult time
convincing
> > him that we should make this change -- creating a TOOLS tablespace
and
> > moving all of SYSTEM's objects to it. Everything is saying this is
> > "best" practice, but nothing is really explaining "why" well enough
to
> > make a convincing argument.
> >
> > Anyone want to help me make the case?
> >
> > - Ed Stevens
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> Ask him if he knows what happens when the system tablespace
fills
> up. Then tell him that, since he is the one that doesn't want it
fixed
> he can be the guy that gets to come in a 3:00 AM to fix things when
they
> break. (I think it is Murphy's Law #39 -- The system will crash and
> the
> database will need rebuilding only when running very large time
critical
> jobs between the hours of 1:30 and 2:20 AM local time.)
> --
> Jerry Gitomer
> Once I learned how to spell DBA, I became one.
>

--
The reply to that question will be "why would the system tablespace fill up?" The only users defaulted to it are SYS and SYSTEM. Once the data dictionaries are built, what else would cause an unexpected increase in space usage on the that tablespace?

I don't mean to be argumentative -- just playing devil's advocate because I know what I'm up against in proposing any changes to our current practice.

• Ed Stevens (Opinions are not necessarily those of my employer)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jan 28 2000 - 07:54:33 CST