This is technically possible, but only by calling the UPI layer directly and specifying that the statement type is not shareable. However, as Dave Ensor pointed out the U in UPI is something of a misnomer, because it is not really meant for users. So effectively the answer is, No.

In a discussion (on another list) a list member asked "Is there a way to tell Oracle NOT TO KEEP a SQL statement in the SGA?" I scanned through manuals but couldn't find any. Basically with using NDS and dynamic SQL etc, the member wanted to know if he could flag such statements so that they won't be kept in the SGA after their execution. I too got interested in this as this could be useful in certain cases ...

Is this possible at all?