Name
OPTIMIZER_SEARCH_LIMIT
Synopsis
Value: 0-10
Default: 5
Dynamic: ALTER SESSION
Specifies the number of tables for which Cartesian products will be considered during join operations. Obsolete with Oracle9i.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.