 | | | optimizer time reported as? | optimizer time reported as? 2006-01-11 - By Wolfson Larry - lwolfs
I got asked about performance on a database that was recently upgraded
from 8.1.7.4 to 9.2.0.6.
Looking at the initora I noticed
optimizer_max_permutations integer
79999
The DBA doing the upgrade said she only changed the parmaeters
relating to the upgrade.
I know the default changed from 8's 80000 to 9's 2000 and there was an
earlier TAR telling us to change the
80000 to 79999.
I thought this might be an issue and I ran Tim Gorman's sp_time
script to see where the overhead was.
I just wanted to verify that the optimizer_max_permutations time is
accounted for in the
Parsing SQL time and not somewhere else.
TIA
Larry Wolfson
*************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank you.
*************************************************************************
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Re: Rman/NetBackup problem</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1528" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=350444120-11012006>I got asked about performance on a database that was
recently upgraded from 8.1.7.4 to 9.2.0.6.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=350444120-11012006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=350444120-11012006>Looking at the initora I noticed</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=350444120-11012006>optimizer_max_permutations
integer
79999</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=350444120-11012006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=350444120-11012006> The DBA doing the upgrade said she
only changed the parmaeters relating to the upgrade.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=350444120-11012006>I know the default changed from 8's 80000 to 9's 2000
and there was an earlier TAR telling us to change the </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=350444120-11012006>80000 to 79999.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=350444120-11012006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=350444120-11012006> I thought this might be an issue
and
I ran Tim Gorman's sp_time script to see where the overhead
was.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=350444120-11012006>I just wanted to verify that the
optimizer_max_permutations time is accounted for in
the </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=350444120-11012006>Parsing SQL time and not somewhere
else.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=350444120-11012006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=350444120-11012006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=350444120-11012006> TIA</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=350444120-11012006> Larry Wolfson</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=350444120-11012006> </SPAN></FONT></DIV><pre>**********
***************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank you.
*************************************************************************
</pre></BODY></HTML>
|
|
|