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.