Re: LMT and DMT

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Wed, 05 Feb 2003 10:36:03 -0800
Message-ID: <3E415993.FA3A4BD7@exesolutions.com>

Frank wrote:

> <snipped>
>
>
> I think this remark is along the route of 'using autoextending
> tablespaces is lazy DBA approach'.
> I -personally- disagree, provided an automated
> system monitoring tools is in place and being used.
>

Doesn't seem like you disagree at all.

> Just returned from a client with performance issues, and thay
> have all users granted dba role, or "else the software won't run".
> Resulted in a huge amount of indexes being created in SYSTEM tablespace,
> which is now totally cluttered. Some objects had ##,### extents...
> Advised to go LMT... And upgrade to the latest patch level.
> Among others.
>
> Cheers,
>
> Frank

Giving someone the DBA role has nothing to do with anything being created in the SYSTEM tablespace. What were they thinking? Or were they?

Daniel Morgan Received on Wed Feb 05 2003 - 12:36:03 CST