Common methods to solve IO problems:
Through SQL optimization, you can reduce the IO requests of the database:
Adjust the instance parameters to reduce the database's IO requests:
Compared to 1000 data transmission requests per 10000 kb or 100 data transmission requests per 10 KB, data transmission requests per 1 MB is obviously faster. When the limit value is reached, the difference is not so obvious: 1 GB of data transmission, each 10 MB size request 100 times (if the operating system maximum IO transfer size limit is allowed ), the efficiency may be the same as that for one transmission of 1 GB. The reason is that the time for one IO processing mainly includes two components:
IO optimization at the operating system level:
Balance database IO by using Oracle ASM (Automatic Storage Manager:
Balance database IO by Using Strip, RAID, SAN, or NAS:
:
The data volume capacity of the current database is reduced by migrating old data.
Use more and faster hardware.