LogFileSync event can also be network related…

      11 Comments on 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.
 
[code language=”sql”]
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

[/code]
 
 
What is session 6644 doing?
[code language=”sql”]
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

[/code]
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
 
 
 
 


     

Leave a Reply

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