Re: Locally Managed vs Dictionary managed tablespaces

I wouldn't be surprised if Steve had in mind the sites where the DBA has set up a job to scan dba_segments once per hour to produce warnings of 'full tablespaces' or 'objects nearing maxextents'.

As commonly occurs within the management side of Oracle, it's one of those things that doesn't really matter if you know how to do the job properly anyway.

I think your last para - quoted below - sums it up really quite well. (NB British understatement)

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.



>

>Anyway, as he says, running two DBA reports is the only real drawback

>associated with LMTs.  Would I stuff up a database just to make my DBA

>reports run a bit faster?  Nah.  Not on your nelly.

>