alert log shows error relating to network buffer

[Sambo8]

Hi There,

I'm getting the following error in my alert log:

2007/07/25 Wed 00:01:24 ORA-16166: LGWR timed out on Network Server 0 due to buffer full condition.
2007/07/25 Wed 00:01:24 ORA-16166: LGWR network server failed to send remote message
2007/07/25 Wed 00:01:24 ORA-16166: LGWR network server failed to send remote message
2007/07/26 Thu 00:01:18 ORA-16166: LGWR timed out on Network Server 0 due to buffer full condition.
2007/07/26 Thu 00:01:18 ORA-16166: LGWR network server failed to send remote message
2007/07/26 Thu 00:01:18 ORA-16166: LGWR network server failed to send remote message

Does anyone know what is causing this?

Many thanks,
Sam

 

[markrem]

It means log writer (LGWR) was able to pass data to the log network service (LNS) faster than the LNS was able to post the data to the remote or "standby" location. That make sense, because LGWR operates locally and LNS operates over the network, and network operations are slow relative to a local server. The LNS has a tunable buffer to deal with this issue. You need to increase the LNS buffer size. See the on-line Oracle documentation or Oracle Note 247129.1 for details.
-Mark