inline views and parallelism
On Oracle 11.2, our application uses a "lot" of inline views.
Not knowing much about the benefits or advantages to using inline views, I wondered a few things about the use of them.
First, When I look in OEM, SQL Monitoring, I noticed that queries on inline views that have tables with parallelism set, the queries on inline views do not appear to be using parallelism on the inner query. Or, perhaps they are, but I'm not able to see that they are. How can I tell if they are?
If they are not, would it be necessary to use a hint to use parallelism?
So what are the advantages of using inline views?
I would assume they would use more PGA and/or temp tablespace, but that doesn't seem to be the case in our database (or at least it is not causing any impact that I can tell).