A little more of the query would have been
helpful, as I think we would have seen some
very boring column aliases as well as a CASE
statement, and possible a SAMPLE clause.
It looks like the start of a query run by run-time
dynamic sampling - during which dynamic sampling
is switched off, bind variable substitution is blocked,
and column_monitoring is disabled.
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
The Co-operative Oracle Users' FAQ
"Lily" <com> wrote in message