Re: LMT and DMT

From: Frank <fvanbortel_at_netscape.net>
Date: Wed, 05 Feb 2003 22:05:20 +0100
Message-ID: <3E417C90.2090707@netscape.net>

DA Morgan wrote:

> 
> 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
> 

I feel like I am missing out on two things here... 1) I do not think autoextending tablespaces should be discarded as 'a lazy DBA's approach'. I disagree with that; I find then useful in remotely controlled environments with a control room monitoring system resources.

2) "What were they thinking? Or were they?" Like: were they [thinking AT ALL]? Am I missing the(/a) point here?

Goin' for a beer, smoke a pipe, nighty-night! Frank Received on Wed Feb 05 2003 - 15:05:20 CST