Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Tunning Issue

Re: SQL Tunning Issue

From: Girish Jashnani <girishjashnani_at_worldnet.att.net>
Date: 6 Aug 1998 01:36:11 GMT
Message-ID: <6qb1ab$r9k@bgtnsc03.worldnet.att.net>

I am NOT sure but try using :

alter session set optimizer_goal = all_rows OR first_rows

OR change optimzer_mode in INIT.ORA

All the best. Received on Wed Aug 05 1998 - 20:36:11 CDT

This message: [ Message body ]
Next message: Girish Jashnani: "Oracle Password"
Previous message: Peter.McKenzie_at_health.wa.gov.au: "REP 1800 trying to produce html output on Unix"
In reply to: Roman Gelfand: "SQL Tunning Issue"
Next in thread: Monique van Daal: "Re: SQL Tunning Issue"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US