How to reset session context/variables in JDBC pooled connections - MySQL / Oracle
DBMS_SESSION.CLEAR_ALL_CONTEXT

This procedure clears application context information in the specified
namespace.

DBMS_SESSION.RESET_PACKAGE

This procedure de-instantiates all packages in this session. It frees
the package state.