I’m doing several tests using Oracle 19c and SQL Developer involving repeated executions of a set of statements and I would like to work in an isolated fashion, and so I want that the statements executed from my session doesn’t share cursors with statements executed from other sessions.
Some statements are inside packages that I can’t touch, and so my only choice is to change something in my session. Is there any “trick”, any session parameter for example, that could cause Oracle to treat the statements executed from my session from now on as a different “execution context” and so forcing Oracle to hard parse the statements that are execute from now on?