[oracle-l] Re: Parallel Query determined by?
- From: Kirtikumar Deshpande <kirtikumar_deshpande@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 24 Jan 2004 07:03:35 -0800 (PST)
It's possible. But only if there are multilple archiving destinations
involved...
- Kirti
--- babette.turnerunderwood@xxxxxxxxxxxxxxx wrote:
> Could they possibly be talking about LGWR SYNC=3DPARALLEL Wait Events ??
>
> From the 9.2.0.4 Install HTML:
>
> "LGWR ASYNC or LGWR SYNC=3DPARALLEL Wait Events=20
> The following wait events are for standby destinations configured with =
> either the log writer (LGWR) ASYNC or LGWR SYNC=3DPARALLEL attributes:=20
>
> LGWR wait on LNS: This wait event monitors the amount of time spent by =
> the LGWRprocess waiting to receive messages on IPC channels from the =
> network server.=20
>
> LNS wait on LGWR: This wait event monitors the amount of time spent by =
> the network server waiting to receive messages on IPC channels from the =
> LGWR process.=20
>
> LGWR-LNS wait on channel: This wait event monitors the amount of time =
> spent by the LGWR process or the network server processes waiting to =
> receive messages on IPC channels. "
>
> - Babette
>
> -----Original Message-----
> From: ml-errors@xxxxxxxxxxx [mailto:ml-errors@xxxxxxxxxxx] On Behalf Of =
> Kirtikumar Deshpande
> Sent: 2004-01-21 9:39 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Parallel Query determined by?
>
>
> I could not find an Oracle wait event named 'Parellel Sync Wait' (in =
> v$event_name view in 7.3.4,
> 8.1.7.4, 9.2.0.4). =20
>
> Precise may be calling something else a 'Parallel Sync Wait', or is =
> smart enough to figure this
> out when it seems Oracle isn't instrumented for this particular wait(?). =
> Just pondering...=20
>
> Does Presice on-line help have any mention of this wait?=20
> Have you contacted Precise Tech Support?=20
> =20
> - Kirti=20
>
>
> --- Jared.Still@xxxxxxxxxxx wrote:
> > No other replies yet, so here goes.
> >=20
> > First of all, what does it really mean when you say:
> >=20
> > users are complaining that Precise is showing a whole lot of time in=20
> > "Parallel Sync Wait".
> >=20
> > Are these end users, or developers? Seems rather curious that users =
> would=20
> > be mentioning this.
> >=20
> >=20
> > Second, what % of wait time do the Sync Waits contribute to?
> >=20
> > If a small % of total, then there's not much point in spending time on =
> it.
> >=20
> > Third, is this actually causing a performance problem, or is it just=20
> > appearing
> > as a 'trouble' item on some monitor?
> >=20
> > Jared
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
Other related posts:
