从ConnectionPool中检索后准备Oracle Connection [英] Preparing an Oracle Connection after being retrieved from a ConnectionPool

问题描述

我了解获得连接池后，应通过调用

I understand that after getting a connection pool I should clear state from all the packages with a call to

sys.DBMS_SESSION.reset_package;

此外，应该清除上下文，但是，上下文具有名称空间.

Furthermore the contexts are supposed to be cleared, however, contexts have a namespace.

我应该找到每个命名空间并清除它们吗?

Am I supposed to find every namespace and clear each of them?

如何找到所有名称空间? https://docs.oracle.com/cd/E18283_01/network.112/e16543/app_context.htm#CIHDAJDF

How do I find all of the namespaces? https://docs.oracle.com/cd/E18283_01/network.112/e16543/app_context.htm#CIHDAJDF

推荐答案

您可以使用

You can use dbms_session.list_context to get the list of existing contexts for the current session.

这篇关于从ConnectionPool中检索后准备Oracle Connection的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！