Àí½â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"
);
Ïà¹ØÎĵµ£º
ÏÂÃæÁ½ÆªÎÄÕÂÈ«²¿ÊÇתÌû~
ÔµØÖ·£ºhttp://www.im80hou.com/html/oracle/2009/0722/824.html
ÀíÂÛ£º
ÄÚ´æÓëÓ²Å̵ÄËٶȲîÒ죬´ÓÄÚ´æÖжÁÈ¡Êý¾ÝÒª±È´ÓÓ²ÅÌÖжÁÈ¡Êý¾Ý¿ì10000±¶
ÖÚËùÖÜÖª£¬´ÓÄÚ´æÖжÁÈ¡Êý¾ÝÒª±È´ÓÓ²ÅÌÖжÁÈ¡Êý¾Ý¿ì10000±¶¡£ÕâÖ÷ÒªÊÇÄÚ´æÓëÓ²Å̵ÄËٶȲîÒìËùÔì³ÉµÄ¡£Îª´ËÔÚOracleÊý¾Ý¿âÖÐÌá³öÒ»¸öÊý¾Ý»º´æµÄ ......
Õâ´ÎµÄ¾ÀúÊÇ×Ô¼ºÕÒÀ´µÄ£¬ÔÚ°²×°ÁË10gµÄÄÇ̨»úÉÏÉý¼¶ÏÂÄÚ´æÒ²±ãÄܺöÓÆÄÇȺÓÑ£¬²»¹ýÏëÏ뻹ÊÇÕÛÌÚÏ°ɣ¬¸øÒƵ½ÅäÖúõãµÄServerÉÏÃ棬ËûÃÇÓÃÆðÀ´Ë³ÐÄ£¬ÎÒ×Ô¼ºÒ²ÄÜÕÛÌÚµã¾Ñé¡£
132µÄϵͳÊÇSuSE10.2µÄ£¬Ö®Ç°ÒѾ°²×°ÁËOracle 9i£¬Õâ¾ÍÒâζ×űØÐëÏÈжÔصô9i£¬±¾ÒÔΪ°²×°10gµÄrunInstallerÄܹ»Ð¶Ôصô9i£¬¿É³¢ÊÔÁ˺þö¼ÊdzöÏÖex ......
²©ÑåÅàѵ²¿ÊÇÄ¿Ç°¹úÄÚΨһµÄ Oracle ¹Ù·½ÊÚȨ ERP ÈÏÖ¤Åàѵ»ú¹¹
Ä¿Ç°£¬Oracle Ó¦ÓÃϵͳÔÚÈ«Çò¿ç¹ú¹«Ë¾µÃµ½¹ã·ºÓ¦Óã¬ÖîÈçÖйúÒƶ¯¡¢ÉîÛÚ»ªÎª¡¢»ôÄáΤ¶û¡¢¿µÃ÷˹Öйú¡¢ÃÀ¹úÂÁÒµ¡¢DHL ºÍ±¦ÐÅÈí¼þµÈÖªÃû¹«Ë¾¡£Îª´Ë£¬Oracle ×Éѯ¹ËÎÊÊÇÈ«ÇòºÍÖйúÊг¡ÉÏ×î½ôȱµÄÈ˲ÅÖ®Ò»¡£Í¨¹ýOracle ÉÌÎñÌ×¼þÈÏÖ¤µÄ×Éѯ¹ËÎ ......
Ò»¡¢Óï·¨
´óÖÂд·¨£ºselect * from some_table [where Ìõ¼þ1] connect by [Ìõ¼þ2] start with [Ìõ¼þ3];
ÆäÖÐ connect by Óë start with Óï¾ä°Ú·ÅµÄÏȺó˳Ðò²»Ó°Ïì²éѯµÄ½á¹û£¬[where Ìõ¼þ1]¿ÉÒÔ²»ÐèÒª¡£
[where Ìõ¼þ1]¡¢[Ìõ¼þ2]¡¢[Ìõ¼þ3]¸÷×Ô×÷Óõķ¶Î§¶¼²»Ïàͬ£º
[where Ìõ¼þ1]ÊÇÔÚ¸ù¾Ý“connect by [Ìõ¼þ2] ......
=================================================================================
Oracle RAC ²úÆ·¸ÅÊö
Oracle Real Application Server£¬ÕæÕýÓ¦Óü¯Èº£¬¼ò³ÆOracle RAC £¬ÊÇOracleµÄ²¢Ðм¯Èº£¬Î»ÓÚ²»Í¬·þÎñÆ÷ϵͳµÄOracleʵÀýͬʱ·ÃÎÊͬһ¸öOracleÊý¾Ý¿â£¬½ÚµãÖ®¼äͨ¹ý˽ÓÐÍøÂç½øÐÐͨÐÅ£¬ËùÓеĿØÖÆÎļþ¡¢Áª»úÈÕÖ ......