BYPASS_RECURSIVE_CHECK oracle hint purpose?

oracle11g hint
Osy picture Osy · Apr 12, 2013 · Viewed 11k times · Source

Someone knows the purpose of this undocumented oracle hint :

BYPASS_RECURSIVE_CHECK

Why to use it or not?

Answer

Justin Cave picture Justin Cave · Apr 12, 2013

You should never use that hint. It's undocumented for a reason. If you were meant to use it, it would be documented.

As far as I'm aware, there are occasional cases where the optimizer generates plans differently when optimizing recursive SQL statements. This hint is intended to affect that. Realistically, unless you are a developer working for Oracle who is having a conversation with the optimizer group as to why some of your recursive SQL statements aren't generating the plans you would expect or you're a developer with an open SR with Oracle Support that is instructed to use this hint to work around an optimizer bug, you're almost certainly better off ignoring this and any other undocumented hints you come across.

If you really want more information, you can take a look at MOS ID 398605.1 which has links to a few related bugs.

Related questions

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More
How do I do top 1 in Oracle?

How do I do the following? select top 1 Fname from MyTbl In Oracle 11g?

Read More
ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client

I'm trying to connect to a schema on 11g (v11.2.0.1.0) from a PC with 9i (v9.2.0.1) client. It seems to connect fine to some schemas, but not this one - it comes back with a ORA-01017 Invalid Username/Password error …

Read More