Re: Automatic Segment Space Management

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Thu, 4 Mar 2010 05:59:38 -0800 (PST)
Message-ID: <12b58037-2107-448c-b078-66a2d2e34e18_at_q16g2000yqq.googlegroups.com>



On Mar 4, 7:13 am, moongeegee <moongee..._at_gmail.com> wrote:

snip

> I have some old SQL scripts that use PCTFREE and PCTUSED.
> As now we have 10g, should I modify the scripts using ASSM instead of
> PCTFREE
> and PCTUSED?
> Thanks in advance.

Have you looked at the Oracle documentation?

The short answer is that you scripts don't have to change although some of the parameters may start getting ignored.

Are you going to modify things manually instead of using some kind of tool and/or script that re-creates only the relevant parameters applicable to your changing environment? Received on Thu Mar 04 2010 - 07:59:38 CST

Original text of this message