Hi,
Our production and warehouse database was recently upgraded from 10.2.0.3 to 11.2.0.4.
There is a bulk insert of rows from production to the warehouse using a dblink. After the upgrade, the inserts are taking 10 times longer and is very very slow.
The wait events are SQL*Net more data from client and SQL*Net more data to client.
The top wait event in the destination is
| Event | Waits | Total Wait Time (sec) | Wait Avg(ms) | % DB time | Wait Class |
|---|
| SQL*Net more data from client | 151 | 3448.5 | 22838 | 166.5 | Network |
The top wait event in the source is
| Event | Waits | Total Wait Time (sec) | Wait Avg(ms) | % DB time | Wait Class |
|---|
| SQL*Net more data to dblink | 143 | 2161.3 | 15114 | 19.2 | Network |
The SDU in listener.ora is set to 32KB. Any suggestions ?
The query which is run is something like this
Insert into dest_table@dest_db_link(col1,col2,col3)
from source_table where rowid='ADAasfdfgdgDADDADFF'