oracleÅúÁ¿(batch)²Ù×÷µÄʹÓÃ
/**
* ¸üмǼ£¬Ô×Ó²Ù×÷£¬²»»ácommit
* @param sql_id
* @param condition
* @return
* @throws SQLException
*/
public boolean updateBatchSql(String sql, List<List<String>> conditions) throws SQLException {
boolean b = false;
if (sql == null || sql.trim().length() == 0) {
return b;
}
Connection conn = null;
ResultSet rs = null;
PreparedStatement pstmt = null;
//Ö´ÐÐsql
try {
conn = handler.getConnection();
pstmt = conn.prepareStatement(sql);
//Ñ»·¸³Öµ
for (List<String> condition : conditions) {
for (int i = 0; i < condition.size(); i++) {
pstmt.setString(i + 1, condition.get(i));
}
pstmt.addBatch();
}
&
Ïà¹ØÎĵµ£º
http://space.itpub.net/4227/viewspace-68592
ÎﻯÊÓͼµÄ¿ìËÙË¢ÐÂÒªÇó»ù±¾±ØÐ뽨Á¢ÎﻯÊÓͼÈÕÖ¾£¬ÕâÆªÎÄÕ¼òµ¥ÃèÊöÒ»ÏÂÎﻯÊÓͼÈÕÖ¾Öи÷¸ö×ֶεĺ¬ÒåºÍÓÃ;¡£
ÎﻯÊÓͼÈÕÖ¾µÄÃû³ÆÎªMLOG$_ºóÃæ¸ú»ù±íµÄÃû³Æ£¬Èç¹û±íÃûµÄ³¤¶È³¬¹ý20룬Ôòֻȡǰ20룬µ±½Ø¶Ìºó³öÏÖÃû³ÆÖظ´Ê±£¬Oracle»á×Ô¶¯ÔÚÎﻯÊÓͼÈÕÖ¾Ãû³ÆºóÃæ¼ ......
µ±LGWR´¦ÓÚ¿ÕÏÐ״̬ʱ£¬ËüÒÀÀµÓÚrdbms rpc messageµÈ´ýʼþ£¬´¦ÓÚÐÝÃß״̬£¬Ö±µ½ÈýÃëʱ¼äµ½£¬Èç¹ûÕâ¸öʱºòLGWR·¢ÏÖÓÐRedoÐÅÏ¢ÐèҪд³öµÄ»°£¬ÄÇôLGWR½«Ö´ÐÐдµÄ²Ù×÷£¬log file parallel writeµÈ´ýʼþ½«»á³öÏÖ¡£
¡¡¡¡×ܽáÒ»ÏÂRedoдµÄ´¥·¢Ìõ¼þ£º
¡¡¡¡1£¬Ã¿ÈýÃëÖÓ³¬Ê±(timeout)£º
µ±LGWR´¦ÓÚ¿ÕÏÐ״̬ʱ£¬ËüÒÀÀµÓÚrdbms r ......
ÔÚOracleµÄQuery RewriteÖÐÖ÷ÒªÓÐÈýµã, µÚÒ»ÊÇҪʹÓÃCBO; µÚ¶þÊÇÒªÉèÖÃquery rewrite enabled²ÎÊýΪTRUE; µÚÈýÊÇÒªÏÈÔñÉèÖÃquery rewrite integrity²ÎÊýµÄÖµ(stale_tolerated, trusted, enforced). ¶ÔÓÚµÚÒ»µã, ÎÒÃÇ×îºÃanalyzeÏà¹ØµÄ±í¼°Ë÷Òý¼°MV; ¶ÔÓÚµÚ¶þµã,Õâ¸ö²ÎÊýÖ»ÓÐÁ½¸öÖµ(true, false), ºÜ¼òµ ......
Oracle ´´½¨ÐòÁУº
create sequence SEQ_Tablename_id
increment by 1 &nbs ......
ÔËÐÐÁËOracleµÄLinux·þÎñÆ÷¸ü¸ÄÖ÷»úÃû
¼ÙÈçÒª°ÑÖ÷»úÃû¸ÄΪoratest¡£
$±íʾoracleÓû§²Ù×÷£»
#±íʾrootÓû§²Ù×÷¡£
DB£ºoracle10.2
OS£ºRHEL4.5
µÚÒ»²½£¬¹Ø±ÕÊý¾Ý¿âºÍ¼àÌý£¬dbconsole£º
$ dbshut
$ lsnrctl stop
µÚ¶þ²¿£º
# hostname oratest
µÚÈý²½£º
# vi /etc/sysconfig/network
¸ü¸Ähostname²ÎÊý¡£
µÚËIJ½ ......