Buffer busy waits

Ketika saya menginsert data sejumlah ratusan ribu rekord, instance database hang.

Setelah saya selidiki dengan query di bawah ini:

select sid, username, event, blocking_session,
seconds_in_wait, wait_time
from v$session where state = 'WAITING'
and wait_class != 'Idle';

SID|USERNAME                      |EVENT                               |BLOCKING |SECONDS_IN_WAIT| WAIT_TIME
                                  |                                    | SESSION |
---|------------------------------|------------------------------------|---------|---------------|----------
125|                              |log file switch (archiving needed)  |         |            498|         0
127|DBO_BAKOX_LAMA                |log file switch (archiving needed)  |         |           1014|         0
129|                              |log file switch (archiving needed)  |         |            975|         0
130|DBO_BAKOX_LAMA                |log file switch (archiving needed)  |         |           1014|         0
132|DBO_BAKOX_LAMA                |log file switch (archiving needed)  |         |           1014|         0
137|DBO_BAKOX_LAMA                |log file switch (archiving needed)  |         |           1014|         0
142|SYSTEM                        |log file switch (archiving needed)  |         |            609|         0
144|DBO_BAKOX_LAMA                |log file switch (archiving needed)  |         |           1014|         0
156|                              |control file sequential read        |         |              0|         0
161|                              |log file switch (archiving needed)  |         |           1005|         0
164|                              |buffer busy waits                   |      132|            741|         0


Untuk mengatasi ini, maka saya perbesar db_recovery_file_dest

Dag> sho parameter recovery
db_recovery_file_dest |string     |D:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size                                                      |big integer|5G
recovery_parallelism                                                            |integer    |0
Dag> alter system set db_recovery_file_dest_size=10G scope=both;

System altered.

Elapsed: 00:00:00.07