Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Analyze /LMT Question .....
For details about converting to LMT (and the
reason why you shouldn't bother with
the dbms_space_admin package to do it)
see Connor McDonald's article on
www.oaktable.net
-- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon one-day tutorials: Cost Based Optimisation Trouble-shooting and Tuning Indexing Strategies (see http://www.jlcomp.demon.co.uk/tutorial.html ) ____UK_______March 19th ____USA_(FL)_May 2nd Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) ____USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Mahesh Hardikar wrote in message <4a1c57c2.0302192127.35df46a2_at_posting.google.com>...Received on Thu Feb 20 2003 - 03:19:58 CST
>Hello all ,
>
>I am a bit new to Oracle. We are having Oracle EE 8.1.7.1 on HP-UX 11
>We do index rebuild & analyze table compute statistics weekly.
>
>Do I need to recompile all procedures after analyze in order touse
>fresh statistics ? Or they will get automatically recompiled upon
next
>execution ?
>
>Is there anything else I need to do ?
>
>One more question :
>
>We have all tablespaces as DICTIONARY managed. I wish to turn them
>(except SYSTEM) LMT's with Uniform Extent Size. I read about
>dmbs_space_admin.tablespace_migrate_to_local. But will it reorganise
>existing data as per new storage settings or affect only future
>allocation ?
>On Test , I saw it converted tablespace to LMT but made it
>AUTOALLOCATE . How can I make it UNIFORM & specify size ?
>
>Will it be advisable to export schema , drop user , convert
tablespace
>to LMT (or drop existing TS & create new LMT with specified size ,
run
>DDL's for Tables ) & then do Import ?
>
>Any help is kindly appreciated ...
>
>Thanks for reading such a long post ...
>
>Regards ,
>Mahesh Hardikar