Thanks to everybody. You saved me some time when I most needed it. :-)
On 22.05.2017 21:26, Stefan Koehler wrote:
... or use a slightly modified version of Tanel's hinth SQL script to get more
information :-)
NAME VERSION PATH
---------------------------------------------------------------- ----------
------------------------------------------------------------
NO_USE_INVISIBLE_INDEXES 11.1.0.6 ALL ->
COMPILATION -> CBO -> ACCESS_PATH -> INDEX
USE_INVISIBLE_INDEXES 11.1.0.6 ALL ->
COMPILATION -> CBO -> ACCESS_PATH -> INDEX
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: @OracleSK
Upcoming online seminar: http://tinyurl.com/17-06-13-Shared-Pool-Internals
Ls Cheng <exriscer@xxxxxxxxx> hat am 22. Mai 2017 um 21:16 geschrieben:
Hi
You can find it in v$sql_hint
Regards
On Mon, May 22, 2017 at 8:44 PM, Lothar Flatz <l.flatz@xxxxxxxxxx
mailto:l.flatz@xxxxxxxxxx ;> wrote:
Hi,
thanks ! Did you pick this up from an outline?
Regards
Lothar