The database system can check performance bottlenecks, but the small components written by itself cannot ., Database bottleneck

The database system can check performance bottlenecks, but the small components written by itself cannot ., Database bottleneck

After receiving the company's task, the three standalone databases of the same user must be merged. Therefore, the import library module is completed based on the previous functions. After the actual database is imported, it is found that the speed is getting slower and slower. A total of 1700 projects, initially 200 projects per hour; 200 projects per hour after 90 minutes; 50 projects per hour after one day; 1 project per hour after several hours, 1 hour, 10 projects.

In a hurry, call the database administrator. He asked me to view the v $ session_event table. The v $ sqlarea table is easier to understand,

Soon we found that multiple operations were performed in the same table. After a select count (*) operation, we found more than 1 million rows of Repeated Records. Locate the problem.