Excessicely High log file sync - seemed a media problem with us -
We did a RE-Initialisation of our RAID Box , Created the Filesystems AFRESH
, put Back the Data
RESULT - log file syncs Disappeared
> -----Original Message-----
> From: Steve Adams [SMTP:steve.adams_at_ixora.com.au]
> Sent: Saturday, September 16, 2000 2:46 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: log file sync and processes
>
> Hi Russell,
>
> The only negative effect of a high processes value that I am aware of is
> that
> certain things that query the session specific data structures (such as
> autotrace) take longer. I am not aware of any impact on 'log file syncs'.
> I
> could believe that it might make them take longer, but short of timeouts I
> doubt
> that it would cause more waits. If you try it, I'll be interested to know
> whether it has any effect.
>
> @ Regards,
> @ Steve Adams
> @ http://www.ixora.com.au/
> @ http://www.christianity.net.au/
> @
> @ Going to OpenWorld?
> @ Catch the Ixora performance tuning seminar too!
> @ See http://www.ixora.com.au/seminars/ for details.
>
>
> -----Original Message-----
> Sent: Saturday, 16 September 2000 1:31
> To: Multiple recipients of list ORACLE-L
>
>
> Hi,
> During a conversion we are getting very high numbers of log file sync.
> We
> can't really do much with the striping and I am investigating some other
> options. One of the recommendations I have run across indicates if that
> this can occur if processes is unnecessarily high. In our case processes
> is
> set to 1000 and the shadow processes are running around 90. I'm getting
> some push back from others who do not accept that a high number of
> processes
> can have this effect. Anyone know of corroborating information from
> experts
> or documentation? I don't see anything confirming it in Metalink or on
> Steve Adams' site.
>
> Regards,
> Russ Brooks
>
> --
> Author: Russell Brooks
> INET: russell.brooks_at_amctechnology.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Author: Steve Adams
> INET: steve.adams_at_ixora.com.au
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Tue Sep 19 2000 - 03:10:32 CDT
