Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
• ORA 12540: TNS:internal limit restriction exceeded
• ORA 12838 please : Is possible to append two times to the same table befo
• ORA 12838 please : Is possible to append two times to the same table before
• ora 04031
• ora 12500 on windows
• ORA 32004: obsolete and/or deprecated parameter(s) specified
• ORA 01925: maximum of 30 enabled roles exceeded
• ORA 01925: maximum of 30 enabled roles exceeded
• ora 12500 on windows
• ORA 01650, one idea
• ORA 01650
• ORA 4030
• ORA 12838 please : Is possible to append two times to thesametable before do
• ORA 12838 please : Is possible to append two times to thesame table before d
• ORA 01536
• ORA 03113 end of file on communication channel
• ORA 32004: obsolete and/or deprecated parameter(s) specified
• ORA 00600:
• ORA 00020: maximum number of processes (%s) exceeded
• ORA 01925: maximum of 30 enabled roles exceeded
• ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
• ora 12500 on windows
• ora 12500 on windows
• ora 12500 on windows
• ORA 01650, one idea
• ora 12500 on windows
• ora 12500 on windows
• ora 12500 on windows
• ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
• ORA 01650, one idea
• ORA 01650, one idea
• ORA 01650, one idea
• ORA 01650
• ORA 01650
• ORA 01031
• ORA 4030
• ORA 4030
• ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
• ORA 01722 invalid number
 
LOG FILE SYNC wait event

LOG FILE SYNC wait event

2007-09-05       - By Adrian

 Back
Unfortunately you dont provide full information as to the profile of the log
file sync wait event. Does "Lot of" mean large numbers of events of short
duration or a large amount of wait time attributable to log file sync.



For better understanding of the way forward please consider providing



*   Select * from v$event_histogram where event in ('log file parallel
write', 'log file sync');
*   AWR output to determine the average wait time and if timeouts are
occurring.
*   Information on whether the server is CPU bound as this will
exacerbate log file sync times.
*   Platform and file system information, including database and
filesystem block size.



Cheers

Adrian



 __ __  

From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]
On Behalf Of DBA Deepak
Sent: 03 September 2007 16:48
To: oracle-l
Subject: LOG FILE SYNC wait event



Hi All,



We are having a lot of Log file sync waits because of frequent commits
issued from the third party application. What are the solutions to fix this
apart from the follwing one...



> To move the redo logs to faster disks(Not feasible in our case).



We are using AUTO SGA (10g R2) which can tune log buffer on its own(Please
correct me if I am wrong).  



--
Regards,

Deepak
Oracle DBA


<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft
-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1=
"urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC
-html40">

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@(protected)
  {font-family:Wingdings;
  panose-1 (See http://ose-1.ora-code.com):5 0 0 0 0 0 0 0 0 0;}
@(protected)
  {font-family:Tahoma;
  panose-1 (See http://ose-1.ora-code.com):2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
  {margin:0cm;
  margin-bottom:.0001pt;
  font-size:12.0pt;
  font-family:"Times New Roman";}
a:link, span.MsoHyperlink
  {color:blue;
  text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
  {color:purple;
  text-decoration:underline;}
span.EmailStyle17
  {mso-style-type:personal-reply;
  font-family:Arial;
  color:navy;}
@(protected) Section1
  {size:612.0pt 792.0pt;
  margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
  {page:Section1;}
/* List Definitions */
@(protected) l0
  {mso-list-id:639850723;
  mso-list-type:hybrid;
  mso-list-template-ids:-1997772022 67698689 67698691 67698693 67698689 67698691
67698693 67698689 67698691 67698693;}
@(protected) l0:level1
  {mso-level-number-format:bullet;
  mso-level-text:\F0B7;
  mso-level-tab-stop:36.0pt;
  mso-level-number-position:left;
  text-indent:-18.0pt;
  font-family:Symbol;}
ol
  {margin-bottom:0cm;}
ul
  {margin-bottom:0cm;}
-->
</style>

</head>

<body lang=EN-US link=blue vlink=purple>

<div class=Section1>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Unfortunately you dont provide full
information as to the profile of the log file sync wait event. Does &#8220;<st1
:place
w:st="on">Lot</st1:place> of&#8221; mean large numbers of events of short
duration or a large amount of wait time attributable to log file sync.<o:p></o
:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>For better understanding of the way
forward please consider providing <o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<ul style='margin-top:0cm' type=disc>
<li class=MsoNormal style='color:navy;mso-list:l0 level1 lfo1'><font size=2
    color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial'
>Select
    * from v$event_histogram where event in (&#8216;log file parallel write&
#8217;,
    &#8216;log file sync&#8217;);<o:p></o:p></span></font></li>
<li class=MsoNormal style='color:navy;mso-list:l0 level1 lfo1'><font size=2
    color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial'>AWR
    output to determine the average wait time and if timeouts are occurring.<o
:p></o:p></span></font></li>
<li class=MsoNormal style='color:navy;mso-list:l0 level1 lfo1'><font size=2
    color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial'
>Information
    on whether the server is CPU bound as this will exacerbate log file sync
    times.<o:p></o:p></span></font></li>
<li class=MsoNormal style='color:navy;mso-list:l0 level1 lfo1'><font size=2
    color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial'
>Platform
    and file system information, including database and filesystem block size.
<o:p></o:p></span></font></li>
</ul>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Cheers<o:p></o:p></span></font></p>

<p class=MsoNormal><st1:City w:st="on"><st1:place w:st="on"><font size=2
 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
 color:navy'>Adrian</span></font></st1:place></st1:City><font size=2
color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'><o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<div>

<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>

<hr size=3 width="100%" align=center tabindex=-1>

</span></font></div>

<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> oracle-l-bounce
@(protected)
[mailto:oracle-l-bounce@(protected)] <b><span style='font-weight:bold'>On
Behalf Of </span></b>DBA Deepak<br>
<b><span style='font-weight:bold'>Sent:</span></b> 03 September 2007 16:48<br>
<b><span style='font-weight:bold'>To:</span></b> oracle-l<br>
<b><span style='font-weight:bold'>Subject:</span></b> LOG FILE SYNC wait event<
/span></font><o:p></o:p></p>

</div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Hi All,<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>We are having a lot of Log file sync waits because of frequent commits
issued&nbsp;from the third party application. What are the solutions to fix
this apart from the follwing one... <o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&gt; To move the redo logs to faster disks(Not feasible in our case).<o
:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>We are using AUTO SGA (10g R2) which can tune log buffer on its
own(Please correct me if I am wrong).&nbsp;&nbsp;<br clear=all>
<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
-- <br>
Regards,<br>
<br>
Deepak<br>
Oracle DBA <o:p></o:p></span></font></p>

</div>

</div>

</body>

</html>