maria_1992Всем привет.

Может ли оптимизатор в случае нехватки temp space'а для with использовать inlining?
Столкнулась с проблемой, когда запрос с использованием with иногда падает с ошибкой "ORA-12801: error signaled in parallel query server P027
ORA-32036: unsupported case for inlining of query name in WITH clause", позже, в периоды минимальной нагрузки на сервер, отрабатывает без проблем

OV: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.5.0.0.0
Это читали?
http://www.dba-oracle.com/t_ora_32036_unsupported_case_for_inlining_of_query_name_in_with_clause.htm ORA-32036: unsupported case for inlining of query name in WITH clause tips
Oracle Database Tips by Donald BurlesonSeptember 1, 2015

Question: I am gettuing the ORA-32036: unsupported case for inlining of query name in WITH clause.




The query runs in SQL*Plus, SQL Developer and TOAD but fails when embedded in Java. How do I address the ORA-03236 error?

Answer: The oerr utility shows this for the ORA-32036 error solution:

ORA-32036: unsupported case for inlining of query name in WITH clause

Cause: There is at least one query name which is inlined more than once because it's definition query is too simple and references another query name. This is currently unsupported yet.

Action: remove such query name and retry

In this case, complex queries with nested WITH clauses can throw this error, but ONLY when working SQL is embedded into Java, .Net or C#.

In is a "feature" (bug) in Java, and a common problem when coders try to do too much in SQL and then embed the SQL into Java.

The workaround for the ORA-32026 error is to re-write the SQL WITH clauses using global temporary tables or in-line views.
Ещё есть много багов с такой ошибкой.
Посмотрите на сайте My Oracle Support.