Re: About defragmentation

Hi John.

I agree with you about that campaign agains Oracle.

One of my customer are running an SAP/Oracle environment, and there are no time window of doing an reorg. We have to do a lot of maintanance to keep the extents not reach max. value, and not to mentioned pctfree and pctused etc.......

.Jan Fure

John P. Higgins wrote in message <365F0AC3.B5FE9DD3_at_deere.com>...
>Oracle does not provide this.
>
>DB2 on OS390 just got this capability in V5.
>
>Oracle likes to say that we can avoid reorgs by proper space management.
>However, we sometimes have unforseen growth which un-balances our I/O,
>etc. So some reorgs are inevitable.
>
>There are several products on the market that reduce the reorg outage.
>In a 7X24 shop, these are still inadequate.
>
>I have done an near-line reorg. The outage was about 1 second. I used
>several triggers, an X-Ref table, a unix file, and a package of several
>proceedures. Unfortunately, it was hand-coded for a specific table --
>not very generic. Nor could it handle LONG's over 32K -- need some PRO*C
>or OCI for that.
>
>Let's start a campaign to get Oracle to add generic on-line reorg.
>
>Anastasios Tsibelekidis wrote:
>
>> Hello,
>>
>> How can i perform ONLINE defragmentation.
>> (I have 8.0.3 on Sun Solaris.)
>>
>> Regards, Anastassios Tsivelekidis,
>> INTRACOM S.A., Greece
>
>
>
Received on Sat Nov 28 1998 - 02:36:46 CST