The correct parameter is:
optimizer_mode=choose
Then run the following:
spool /tmp/analyze_all.sql;
select 'execute dbms_utility.analyze_schema(' || '''' || username || ''''
||','|| '''' || 'COMPUTE' || '''' || ');'
from all_users
where username not in ('SYS', 'SYSTEM')
order by username;
spool off;
@/tmp/analyze_all.sql;
Be sure to change the spool path to suit your needs.
HTH,
- Alex Hillman <alex_hillman_at_physia.com> wrote:
> 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-----
> Sent: Monday, August 21, 2000 2:36 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
> --
> 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).
>
Rocky Welch
Oracle DBA Consultant
rockyw_99_at_yahoo.com
Do You Yahoo!?
Received on Mon Aug 21 2000 - 15:55:35 CDT
