Re: Information on Reorganizing Large Tables on 8i and 9i

I don't remember which version, but in higher versions of oracle you can compress both table data and index data.

On 6 Apr 2004 10:12:18 -0700, basis_consultant_at_hotmail.com (SAP BASIS Consultant) wrote:

>Hi,
>
>Thanks for the information.
>
>The main reason behind the reorganization will be to save
>disk space (Yes, disk space is cheap..but that is the nature
>of the request). The data will likely be deleted using SAP
>archiving techniques.
>
>As a matter of fact, I may be allowed to save disk space even
>at the expense of performance, to a reasonable extent. (Changing
>PCTFREE and PCTUSED, etc..).
>
>I am not sure what the maint. windows will be.
>
>
>
>Thanks,
>SAP BASIS Consultant
>
>
>
>andreyNSPAM_at_bookexchange.net (NetComrade) wrote in message news:<4071c72d.1482811700_at_localhost>...
>> The only reason i would do a 'reorganize' is
>> 1) i need to delete large chunks of it (go to partitions)
>> 2) i need to backup/restore quicker (go to partitions)
>> 3) i have a lot of chained rows in tables (exp/imp and set proper
>> pctfree/pctused afterwards)
>>
>> Are you trying to improve performance of tables or performance of
>> reorganizing (do you have maint windows available?)
>>
>> On 5 Apr 2004 11:52:33 -0700, basis_consultant_at_hotmail.com (SAP BASIS
>> Consultant) wrote:
>>
>> >Hello,
>> >
>> >Thanks to all those who took the time to answer my previous question
>> >regarding the rebuilding of online indexes.
>> >
>> >I have reorganized small and medium sized tables (Say, up to 500MS or
>> >so) in Oracle 7.x, 8.0.x, and 8.i.
>> >
>> >Now, it looks like I will be doing so with larger tables (Say, 1GB to
>> >10GB+) on AIX. The tables will likely be composed mainly (Or all) of
>> >VARCHAR fields; Few, if any, will have LOBs.
>> >
>> >(Yes, I understand that my artibrary concept of small, medium-sized,
>> > and large tables my be differ from other peoples'....)
>> >
>> >I tried to find some documentation, both online and in a bookstore,
>> >regarding issues associated with reorganizing large tables (How to
>> >improve performance, prevent potential problems, etc..), but I did
>> >not find much.
>> >
>> >Does anybody recommend any Website, article, or book dealing with
>> >these issues?
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >Thanks,
>> >SAP BASIS Consultant
>>
>> .......
>> We use Oracle 8.1.7.4 on Solaris 2.7 boxes
>> remove NSPAM to email

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Thu Apr 08 2004 - 15:24:56 CDT