avoid materialization in query factoring
Hello everybody,
in our applcation (on an Oracle 11gR2 5-nodes RAC) we make huge use of 'subquery factoring', which is the most prevalent operation along the workload, meaning that it's used about 10 times per second. Unfortunetly we are not sure about the choice of the optimizer in choosing wether materialize the subquery into the temporary segments or keeping them inline. We know about the 'inline' hint (Doc ID 1662498.1), but we'd use it only in the case the optimizer is at present materializing the subqueries.
Our question is: is there a way to check what is the present choice of the optimizer?