Àí½âoracleÖÐÁ¬½ÓºÍ»á»°
1.
¸ÅÄͬ£º
Á¬½ÓÊÇÖ¸ÎïÀíµÄ¿Í
»§¶Ëµ½oracle·þÎñ¶ËµÄÁ¬½Ó¡£Ò»°ãÊÇͨ¹ýÒ»¸öÍøÂçµÄÁ¬½Ó¡£
ÔÚÒѽ¨Á¢µÄÁ¬½Ó
ÉÏ£¬½¨Á¢¿Í»§¶ËÓëoracle
µÄ»á»°£¬ÒÔºó¿Í
»§¶ËÓëoracle
µÄ½»»¥¶¼ÔÚÒ»¸ö»á»°»·¾³ÖÐ
½øÐС£
2.
¹ØϵÊǶà¶Ô¶à£º[ͬÒâÍøÓѵÄÒâ¼û£¬Ó¦¸ÃÊÇ1¶Ô
¶à¡£Ò»¸ö»á»°ÒªÃ´Ã»ÓÐÁ¬½Ó£¬ÒªÃ´ÔÚÒ»¸öÁ¬½ÓÉÏ¡£]
Ò»¸öÁ¬½ÓÉÏ¿ÉÒÔ½¨
Á¢0
¸ö£¬1
¸ö£¬2
¸ö£¬¶à¸ö»á»°¡£
Oracle
ÔÊÐí´æÔÚÕâÑùµÄ»á»°£¬¾ÍÊÇʧȥÁËÎïÀíÁ¬½ÓµÄ»á
»°¡£
3.
¸ÅÄîÓ¦Óãº
l
oracle
µÄsessions
²ÎÊý¾ö¶¨µÄÊǻỰÊý¶ø²»ÊÇÎïÀíÁ¬½ÓÊý¡£
l
oracle
µÄÁÙʱ±íÖеÄÊý¾ÝÊǸ÷»á»°¼ä¸ôÀëµÄ£¬¶øÓëÁ¬½Ó
¸ÅÄîÎ޹ء£
l
jdbc
µÄconnection
£¬¶Ôoracle
ÊÇÒ»¸ö»á»°µÄ¸ÅÄî¡£
4.
ʵ¼ÊÓ¦Óãº
Á¬½Ó
³Ø£¬ÎªÁËÌá¸ßÊý¾Ý¿â½»»¥Ð§ÂÊ£¬Ò»°ãÇý¶¯³ÌÐò¶¼ÓÐÁ¬½Ó³Ø¸ÅÄîµÄʵÏÖ¡£
Oracle
²»Í¬µÄÇý¶¯ÌṩÁ½ÖÖÁ¬½Ó³Ø¸ÅÄî¡£
Ò»ÖÖÒë
ΪÒþʽÁ¬½Ó»º³å
OracleDataSource ods =
new
OracleDataSource();
ods.setURL(
"jdbc:oracle:thin:@10.1.3.60:1521:orcl"
);
ods.setUser(
"NC50_DEV"
);
ods.setPassword(
"NC50_DEV"
);
ods.setConnectionCachingEnabled(
true
);
java.util.Properties jup
=
new
java.util.Properties();
jup.setProperty(
"InitialLimit"
,
"1"
);
jup.setProperty(
"MinLimit"
,
"1"
);
jup.setProperty(
"MaxLimit"
,
"2"
);
Ïà¹ØÎĵµ£º
Õâ´ÎµÄ¾ÀúÊÇ×Ô¼ºÕÒÀ´µÄ£¬ÔÚ°²×°ÁË10gµÄÄÇ̨»úÉÏÉý¼¶ÏÂÄÚ´æÒ²±ãÄܺöÓÆÄÇȺÓÑ£¬²»¹ýÏëÏ뻹ÊÇÕÛÌÚÏ°ɣ¬¸øÒƵ½ÅäÖúõãµÄServerÉÏÃ棬ËûÃÇÓÃÆðÀ´Ë³ÐÄ£¬ÎÒ×Ô¼ºÒ²ÄÜÕÛÌÚµã¾Ñé¡£
132µÄϵͳÊÇSuSE10.2µÄ£¬Ö®Ç°ÒѾ°²×°ÁËOracle 9i£¬Õâ¾ÍÒâζ×űØÐëÏÈжÔصô9i£¬±¾ÒÔΪ°²×°10gµÄrunInstallerÄܹ»Ð¶Ôصô9i£¬¿É³¢ÊÔÁ˺þö¼ÊdzöÏÖex ......
²©ÑåÅàѵ²¿ÊÇÄ¿Ç°¹úÄÚΨһµÄ Oracle ¹Ù·½ÊÚȨ ERP ÈÏÖ¤Åàѵ»ú¹¹
Ä¿Ç°£¬Oracle Ó¦ÓÃϵͳÔÚÈ«Çò¿ç¹ú¹«Ë¾µÃµ½¹ã·ºÓ¦Óã¬ÖîÈçÖйúÒƶ¯¡¢ÉîÛÚ»ªÎª¡¢»ôÄáΤ¶û¡¢¿µÃ÷˹Öйú¡¢ÃÀ¹úÂÁÒµ¡¢DHL ºÍ±¦ÐÅÈí¼þµÈÖªÃû¹«Ë¾¡£Îª´Ë£¬Oracle ×Éѯ¹ËÎÊÊÇÈ«ÇòºÍÖйúÊг¡ÉÏ×î½ôȱµÄÈ˲ÅÖ®Ò»¡£Í¨¹ýOracle ÉÌÎñÌ×¼þÈÏÖ¤µÄ×Éѯ¹ËÎ ......
ÔÚOracle 9iÖпÉÒÔ·½±ãµÄ°ÑÊý¾Ýµ¼³öΪÎļþ£¬»òÕß´ÓÎļþµ¼È롣ͨ¹ýOracleµÄÖÎÀí·þÎñÆ÷£¨Oracle Management Server£¬OMS£©¿ÉÒÔ·½±ãµÄʵÏÖ£¬Õû¸ö²Ù×÷¹ý³ÌÖÐÓкܶàµØ·½ÐèÒª½âÊÍ˵Ã÷£¬µ«ÊÇÍêÕûµÄÖ¸µ¼×ÊÁϲ»¶à¡£¸÷´óÂÛ̳ÉϺܶàËùνµÄ¸ßÊÖ£¬¶Ô¸ÃÖ÷ÌâµÄ»Ø´ðÍùÍùÊÇ£¬¸ßÊÖÊDz»ÓÃOMSµÄ£¬ÓÃeXP/impl°É¡£¼ÙÈçÄãÖ´Òâ×·ÎÊ£¬Ëû¶à°ë»á¸æËßÄ㣠......
oracle
ÖеĽÇÉ«
Ò»¡¢ºÎΪ½ÇÉ«£¿
¡¡¡¡ÎÒÔÚÇ°ÃæµÄƪ·ùÖÐ˵Ã÷ȨÏÞºÍÓû§¡£ÂýÂýµÄÔÚʹÓÃÖÐÄã»á·¢ÏÖÒ»¸öÎÊÌ⣺Èç¹ûÓÐÒ»×éÈË£¬
ËûÃǵÄËùÐèµÄȨÏÞÊÇÒ»ÑùµÄ£¬µ±¶ÔËûÃǵÄȨÏÞ½øÐйÜÀíµÄʱºò»áºÜ²»·½±ã¡£ÒòΪÄãÒª¶ÔÕâ×éÖеÄÿ¸öÓû§µÄȨÏÞ¶¼½øÐйÜÀí¡£
¡¡¡¡ÓÐÒ»¸öºÜºÃµÄ½â¾ö°ì·¨¾Í
ÊÇ£º½ÇÉ«¡£½ÇÉ«ÊÇÒ»×éȨÏ޵ļ¯ºÏ£¬½«½ÇÉ«¸³ ......
--²é³öËùÓб»ËøסµÄ±í
select b.owner TABLEOWNER, b.object_name TABLENAME, c.OSUSER LOCKBY, c.USERNAME LOGINID, c.sid SID, c.SERIAL# SERIAL
from v$locked_object a,dba_objects b, v$session c
where b.object_id = a.object_id AND a.SESSION_ID =c.sid;
--ͨ¹ýSID, SERIAL½âËø
--alter system kill sessio ......