I believe a connection pool contains a set of connections(sessions) on a Database.
Please let me know what happens when certain code in a package was changed, and the Database stopped and started again. Does this change reflect in the all the connections when the Database comes back up. Is it possible that a few connections can have the older version of the package in their SGA.
Please help asap. I'm debugging an issue and this is the only possibility I can see (if this is possible).