When oracle dbwn is written out, the update statement is executed for 1-3 seconds, which is tens of milliseconds normally

  Kiến thức lập trình

In production, a table with nearly 300 fields is frequently inserted, and another table is executed for more than 1s and less than 3s every once in a while during update (no resource contention at the application layer). The instant is the point in time when the dbwn cache block is written, 12 dbw background threads are executed together, and the IO usage is 20MB, which is much lower than the average of the server hard disk. The server is configured with 4 cpus, 96 logical threads, and 128 GB of memory

Enable concurrent thread insertion, fast insertion speed, fast dbwn frequency, and fast update delay.

DBWN writes data to hard disks. Update delay exceeds 1 second. This phenomenon is bound to occur
When dbwn writes data, update insert and other operations are not affected

New contributor

notcare is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

Theme wordpress giá rẻ Theme wordpress giá rẻ Thiết kế website Kho Theme wordpress Kho Theme WP Theme WP

LEAVE A COMMENT