| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Optimizer Mode cost How to do this ?
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C00BB3.1FC4A46A
Content-Type: text/plain;
charset="iso-8859-1"
And then you need to analyze your objects, or the database will "choose" to do rule-based optimization.
-----Original Message-----
From: Alex Hillman [mailto:alex_hillman_at_physia.com]
Sent: Monday, August 21, 2000 5:06 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Optimizer Mode cost How to do this ?
And if there is nothing to open you should go to technet.oracle.com, register free, go to documentation and find Oracle 8i server reference, where there is a list of available documented parameters with explanation.
To save you some time - in your case the value is choose.
Alex Hillman
-----Original Message-----
From: Khedr, Waleed [ mailto:Waleed.Khedr_at_FMR.COM
<mailto:Waleed.Khedr_at_FMR.COM> ]
Sent: Monday, August 21, 2000 2:36 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Optimizer Mode cost How to do this ?
You should open Oracle documentation.
-----Original Message-----
Sent: Saturday, August 19, 2000 8:34 AM
To: Multiple recipients of list ORACLE-L
Dear List,
I want to put my database in cost mode when I try to
put
optimizer_mode = cost
in initsid.ora it is giving error at database startup
what should I do?Thanks in advance.
Regards,
Rajanish Joshi
-- Author: Rajanish Joshi INET: dbaoracle2000_at_yahoo.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: Khedr, Waleed INET: Waleed.Khedr_at_FMR.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). ------_=_NextPart_001_01C00BB3.1FC4A46A Content-Type: text/html; charset="iso-8859-1"Received on Mon Aug 21 2000 - 16:02:24 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: Optimizer Mode cost How to do this ?</TITLE>
<META content="MSHTML 5.00.3017.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=187500421-21082000>And
then you need to analyze your objects, or the database will "choose" to do rule-based optimization.</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Alex Hillman [mailto:alex_hillman_at_physia.com]<BR><B>Sent:</B> Monday, August 21, 2000 5:06 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: Optimizer Mode cost How to do this ?<BR><BR></DIV></FONT> <P><FONT size=2>And if there is nothing to open you should go to technet.oracle.com, register free, go to documentation and find Oracle 8i server reference, where there is a list of available documented parameters with explanation.</FONT></P> <P><FONT size=2>To save you some time - in your case the value is choose.</FONT> </P> <P><FONT size=2>Alex Hillman</FONT> </P><BR> <P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: Khedr, Waleed [<A href="mailto:Waleed.Khedr_at_FMR.COM">mailto:Waleed.Khedr_at_FMR.COM</A>]</FONT> <BR><FONT size=2>Sent: Monday, August 21, 2000 2:36 PM</FONT> <BR><FONT size=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT size=2>Subject: RE: Optimizer Mode cost How to do this ?</FONT> </P><BR> <P><FONT size=2>You should open Oracle documentation.</FONT> </P> <P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>Sent: Saturday, August 19, 2000 8:34 AM</FONT> <BR><FONT size=2>To: Multiple recipients of list ORACLE-L</FONT> </P><BR> <P><FONT size=2>Dear List,</FONT> <BR><FONT size=2>I want to put my database in cost mode when I try to</FONT> <BR><FONT size=2>put</FONT> <BR><FONT size=2>optimizer_mode = cost </FONT><BR><FONT size=2>in initsid.ora it is giving error at database startup </FONT><BR><FONT size=2>what should I do?Thanks in advance.</FONT> <BR><FONT size=2>Regards,</FONT> <BR><FONT size=2>Rajanish Joshi </FONT></P><BR><BR> <P><FONT size=2>__________________________________________________</FONT> <BR><FONT size=2>Do You Yahoo!?</FONT> <BR><FONT size=2>Send instant messages & get email alerts with Yahoo! Messenger.</FONT> <BR><FONT size=2><A href="http://im.yahoo.com/" target=_blank>http://im.yahoo.com/</A></FONT> <BR><FONT size=2>-- </FONT><BR><FONT size=2>Author: Rajanish Joshi</FONT> <BR><FONT size=2> INET: dbaoracle2000_at_yahoo.com</FONT> </P> <P><FONT size=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT size=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT size=2>--------------------------------------------------------------------</FONT> <BR><FONT size=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT size=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT size=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT size=2>(or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT size=2>also send the HELP command for other information (like subscribing).</FONT> <BR><FONT size=2>-- </FONT><BR><FONT size=2>Author: Khedr, Waleed</FONT> <BR><FONT size=2> INET: Waleed.Khedr_at_FMR.COM</FONT> </P> <P><FONT size=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT size=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT size=2>--------------------------------------------------------------------</FONT> <BR><FONT size=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT size=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT size=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT size=2>(or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT size=2>also
 |
 |