tdy218 發(fā)表于 2012-02-14 21:35
一般般,而且內(nèi)容偏舊,尤其是WebLogic & Tuxedo,GG中甚至有點(diǎn)兒模棱兩可的東西,而且操作居多,又不是搞開(kāi) ...
1、WebLogic內(nèi)存溢出專(zhuān)題探討
2、Goldengate數(shù)據(jù)遷移注意事項(xiàng)及常見(jiàn)問(wèn)題
3、Tuxedo中IPC相關(guān)故障探討
4、常見(jiàn)的中間件調(diào)優(yōu)手段
成皿田心 發(fā)表于 2012-02-20 09:04
回復(fù) 62# huanglao2002
從日常的運(yùn)維監(jiān)控角度來(lái)說(shuō),個(gè)人認(rèn)為幾個(gè)方面值得關(guān)注:
Untitled.jpg (66.38 KB, 下載次數(shù): 61)
“2.3 JDBC調(diào)優(yōu)
增加Statement Cache Size對(duì)于大量使用PreparedStatement對(duì)象的應(yīng)用程序很有幫助,WebLogic能夠?yàn)槊恳粋(gè)連接緩存這些對(duì)象,此值默認(rèn)為10。在保證數(shù)據(jù)庫(kù)游標(biāo)大小足夠的前提下,可以根據(jù)需要提高Statement Cache Size ”
If anything causes a change to a database table or procedure, such as adding an index, or recompiling the procedure, all existing JDBC PreparedStatements that access it must be re-prepared before they can be used again. This is a limitation of the Informix database management system. WebLogic Server caches, retains, and reuses application PreparedStatements along with pooled connections, so if your application uses prepared statements that access tables or procedures that are dropped and recreated or for which the definition is changed, re-execution of a cached prepared statement will fail once. WebLogic Server will then remove the defunct prepared statement from the cache and replace it when the application asks for the statement again.
To avoid any PreparedStatement failure due to table or procedure changes in the DBMS while WebLogic Server is running, set the Statement Cache Size to 0. WebLogic will make a new PreparedStatement for each request. However, with the statement cache disabled, you will lose the performance benefit of statement caching.
歡迎光臨 Chinaunix (http://www.72891.cn/) | Powered by Discuz! X3.2 |