Re: Queries which causes log file sync
- From: LS Cheng <exriscer@xxxxxxxxx>
- To: Marcin Przepiorowski <pioro1@xxxxxxxxx>
- Date: Fri, 15 Oct 2010 17:14:53 +0200
select object_name, object_type from dba_objects where object_id = 32461
IDOX_PATIENT INDEX
On Fri, Oct 15, 2010 at 4:42 PM, Marcin Przepiorowski <pioro1@xxxxxxxxx>wrote:
> 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
>
Other related posts:
