It's possible. But only if there are multilple archiving destinations involved...
- Kirti
- babette.turnerunderwood_at_hrdc-drhc.gc.ca 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_at_fatcity.com [mailto:ml-errors_at_fatcity.com] 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_at_radisys.com 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/
Received on Sat Jan 24 2004 - 09:03:35 CST