Re: Queries which causes log file sync

On Fri, Oct 15, 2010 at 1:37 PM, LS Cheng <exriscer@xxxxxxxxx> wrote:
> Hi
>
> I am reviewing a database which is suffering some high log file sync
> contention. When I 10046 traced an user I see some ALTER o queries which
> waits on dblink and log file sync as follows:
>
> PARSING IN CURSOR #33 len=46 dep=0 uid=39 oct=42 lid=39 tim=1256972268965166
> hv=258095734 ad='0'
> ALTER SESSION SET NLS_DATE_FORMAT='yyyy-mm-dd'
> END OF STMT
> PARSE #33:c=0,e=8,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=1256972268965164
> WAIT #33: nam='SQL*Net message to dblink' ela= 1 driver id=1413697536
> #bytes=1 p3=0 obj#=32461 tim=1256972268965356
> WAIT #33: nam='SQL*Net message from dblink' ela= 5273 driver id=1413697536
> #bytes=1 p3=0 obj#=32461 tim=1256972268970653


Hi

Did you check what is that objects

obj#=32461

maybe it give you some light.

regards,

-- 
Marcin Przepiorowski
http://oracleprof.blogspot.com
--
http://www.freelists.org/webpage/oracle-l


Other related posts: