分布式事务，dblink，存储过程，共享池奇怪的问题

Yong Huang

最初由 璇璇 发布
[B]
...
我怀疑数据库B出4031错误和数据库A频繁使用数据链路ATOB有关，不知是否有人遇见过类似例子。我的猜测是否对？
...
[/B]

I don't see anything special. Whether the SQLs are generated locally, or they're generated because of a remote connection, why does it matter? If the SQLs need to be parsed, they are parsed, and take some shared pool memory. So the answer to your first question is definitely yes.

In case I misunderstand, are you really asking another question? I.e., in the following two cases, which one more easily causes ORA-4031:
(1) All SQLs in my application are local
(2) All SQLs in my application come from another database through a DB link
In other words, does the same SQL take more shared pool memory if it's generated because of a link? Or less? Or about the same?
I'm not sure about the answer but I think it's about the same. If they're not using bind variables, they're equally bad. We can check v$sql.sharable_mem and compare the numbers.

Yong Huang

wzy_75

感动