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/

@

-----Original Message-----
From: Russell Brooks [mailto:russell.brooks_at_amctechnology.com] Sent: Saturday, 16 September 2000 1:31
To: Multiple recipients of list ORACLE-L Subject: log file sync and processes

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).