LogFileSync event can also be network related…

Hi there,

what’s wrong on the picture bellow?

logfilesync

When trying to get sql activity behind there is nothing.

 

select sql_id,wait_class, blocking_session from v$active_session_history where event ='log file sync';

null        Commit    6644
null        Commit    6644
null        Commit    6644
null        Commit    6644
null        Commit    6644
null        Commit    6644
...

 

 

What is session 6644 doing?

select event from v$active_session_history where session_id =6644;

LGWR-LNS wait on channel
LGWR-LNS wait on channel
LGWR-LNS wait on channel
LGWR-LNS wait on channel
LGWR-LNS wait on channel
LGWR-LNS wait on channel
LGWR-LNS wait on channel
LGWR-LNS wait on channel
LGWR-LNS wait on channel
LGWR-LNS wait on channel
LGWR-LNS wait on channel
...

Ok, here we have a data guard related issue.

They have a standby in Max Availability mode and after some discutions with OS team, is seems that they have some network problems…

After proper network tuning, problem is now gone.

jko

 

 

 

 

The following two tabs change content below.

Jacques

I am Oracle Certified Master 11g & 12c database architect with significant experience in heterogeneous environments, and strong ability to lead complex and critical projects requiring multiple technical implementations. at Trivadis SA

Leave a Reply

Your email address will not be published. Required fields are marked *