Re: Do you use ASSM (Automatic Segment Space Management)?
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 7 Aug 2009 13:52:19 +0100
Message-ID: <AvCdnUXC2N0evuHXnZ2dnUVZ8q2dnZ2d_at_bt.com>
Date: Fri, 7 Aug 2009 13:52:19 +0100
Message-ID: <AvCdnUXC2N0evuHXnZ2dnUVZ8q2dnZ2d_at_bt.com>
"kevin" <majunyue_at_hotmail.com> wrote in message
news:addf6fc8-111e-4cfb-89eb-a3fd4365ede3_at_y10g2000prg.googlegroups.com...
> On Aug 4, 8:07 am, ca111026 <ca111..._at_gmail.com> wrote:
>> Do you use ASSM (Automatic Segment Space Management)?
> Our compnay's DBs all use ASSM. It's fine! we don't need rebuild
> indexes again.
I can't think of any good reason why you would have needed to rebuild indexes before switching to ASSM, and not needed to afterwards. Any ideas ?
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.com Author: Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.htmlReceived on Fri Aug 07 2009 - 07:52:19 CDT