Work notes - Adjust index and table space

xiaoxiao2021-03-06  91

The process of customer database original data acquisition has automatically calculated 10 hours.

As the following optimization:

1. Adjust the initialization parameters open_cursors = 400, the original is the original 2500db_file_multiblock_read_count = 16 8db_block_buffers = 89600 * 8192 = 700M, originally 19200shared_pool_size = 104857600, originally 52428800sort_area_size = 1058576, originally 65536optimizer_mode = all_rows, originally first_rows

2. Adjust the allocation and size of the data file in the table space, cancel the automatic extension attribute of the data file

3. Adjust Index, the primary key of the original table accounts for nearly 7G space, but the data table itself has only 1G size to delete the original primary key, recreate, use compress, and the space is reduced to 3G. Such a situation also appears in other large tables, the same processing.

4. Deleted a temporary table created by some on-site personnel, and these temporary tables occupy nearly 1G space.

5. Remove some repetitive indexes

7. Reorganized the INDEX table space, originally occupied 9G space, only 900M space after the restructuring

After optimization, data acquisition and automatic calculation time is shortened to 5 hours, 100% efficiency

No use of any deep technology, just some basic optimization work, has met the customer's needs, see the installation of Oracle all the way, although it can be used, but it will be very uncomfortable.

转载请注明原文地址:https://www.9cbs.com/read-125163.html

New Post(0)