oracle¾ÓÈ»Äܵ÷ÓÃjava³ÌÐò
ÒÔǰֻ֪µÀjavaÄܵ÷ÓÃoracle´æ´¢¹ý³ÌºÍº¯Êý£¬µ«½ñÌìÎÒ·¢ÏÖÔÀ´oracleÒ²¿ÉÒÔµ÷ÓÃjava
²âÊÔ»·¾³oracle 10g
call dbms_java.set_output(5000);
--Ê×ÏÈÔÚoracleÖбàÒëjavaÎļþ ÒÔÏÂÊǸö¼òµ¥µÄ
create or replace and compile java source named helloworld as
public class helloworld {
static public String Message(String name) {
return " Hello, " + name;
}
}
--È»ºóÓú¯Êýµ÷ÓÃjava
create or replace function hello (name VARCHAR2 ) return VARCHAR2
as language java name
' Hello.Message (java.lang.String) return java.lang.String ' ;
--µ÷Óú¯Êý
select hello( ' world! ' ) from dual;
À©Õ¹£º
1¡£ oracle±àÒëjava ÐèÒªclassÎļþÂ𣿠ÔÚµçÄÔÖÐËÑË÷ûÓÐÕÒµ½¡£ ºÜÉñÆæ£¬ ûÓÐclass JVMÈçºÎµ÷ÓÃjavaµÄ£¿£¿
2¡£ Èç¹ûjava³ÌÐòÒª·µ»Ø¼¯ºÏÔõô°ì£¿
3¡£ oracle ±àÒëjava ±¨´íÂ𣬠¿ÉÒÔÒì³£´¦ÀíÂð£¿
Ïà¹ØÎĵµ£º
max_commit_propagation_delayĬÈÏֵΪ700£¬¼´7Ã루µ¥Î»0.01s£¬http://www.orafaq.com/parms/parm1217.htm£©¡£
Õâ¸ö²ÎÊýÓ¦¸ÃÅäÖõÄÊÇRAC£¨Real Application Cluster£©Ö®¼äͬ²½Êý¾ÝµÄƵÂÊ¡£ÐÞ¸ÄÕâ¸ö²ÎÊýµÄºÃ´¦¾Í²»ÓÃ˵ÁË£¨
±¾ÈËÉîÊÜÆä¿à°¡
£©£¬µ«ÊÇÈç¹û×ßÁíÒ»¸ö¼«¶Ë£¬¿ÉÄÜ»á¸øÊý¾Ý¿âÔì³É¸ü´óµÄѹÁ¦
²ÎÊýÖ¸¶¨Ò»¸öinstance ......
ºÃ¾Ã¾ÍÏë¿´oracleÁË£¬ÓÉÓÚ×Ô¼ºÌ«ÀÁ£¬×î½ü²Å¿ªÊ¼¡£Ï£ÍûÒÔºóÄÜÑø³ÉºÃϰ¹ß¡£
Ò»¡¢oracle 10g ·þÎñÆ÷
1.Ò»¸öoracle 10g·þÎñÆ÷°üº¬Ò»¸öoracleÊý¾Ý¿âºÍÒ»¸öoracle·þÎñÆ÷ʵÀý¡£
2.ÿµ±Êý¾Ý¿âÆô¶¯Ê±ºò£¬ÏµÍ³È«¾ÖÇø£¨SGA£©±»·ÖÅ䣬²¢Æô¶¯ÁËoracleºǫ́½ø³Ì¡£SGAÊÇÓÃÓÚÊý¾Ý¿âÓû§¹²ÏíÊý¾Ý¿âÐÅÏ¢µÄÄÚ´æÇøÓ ......
select table_name from user_tables; //µ±Ç°Óû§µÄ±í
select table_name from all_tables; //ËùÓÐÓû§µÄ±í
select table_name from dba_tables; &n ......
ÔÚJavaÖУ¬²»Í¬µÄÀà¶¼ÓÐ×Ô¼ºµ¥¶ÀµÄCache»úÖÆ£¬ÊµÏֵķ½·¨Ò²¿ÉÄÜÓÐËù²»Í¬£¬ÎÄÕÂÁоÙÁËJavaÖг£¼ûµÄ¸÷ÀàCache»úÖÆµÄʵÏÖ·½·¨£¬Í¬Ê±½øÐÐÁË×ۺϵıȽϡ£
OSCache
OSCacheÊǸöÒ»¸ö¹ã·º²ÉÓõĸßÐÔÄܵÄJava EE»º´æ¿ò¼Ü£¬OSCacheÄÜÓÃÓÚÈκÎJavaÓ¦ÓóÌÐòµÄÆÕͨµÄ»º´æ½â¾ö·½°¸¡£
OSCacheÓÐÒÔÏÂÌØµã£º»º´æÈκζÔÏó£¬Äã¿ÉÒÔ²»ÊÜÏÞÖ ......
ÎÒÃÇ´ó¼Ò¶¼ÖªµÀ£¬¶ÔÓÚ¾²Ì¬±äÁ¿¡¢¾²Ì¬³õʼ»¯¿é¡¢±äÁ¿¡¢³õʼ»¯¿é¡¢¹¹ÔìÆ÷£¬ËüÃǵijõʼ»¯Ë³ÐòÒÀ´ÎÊÇ£¨¾²Ì¬±äÁ¿¡¢¾²Ì¬³õʼ»¯¿é£©>£¨±äÁ¿¡¢³õʼ»¯¿é£©>¹¹ÔìÆ÷¡£ÎÒÃÇÒ²¿ÉÒÔͨ¹ýÏÂÃæµÄ²âÊÔ´úÂëÀ´ÑéÖ¤ÕâÒ»µã£º
Java´úÂë
public class InitialOrderTest {
......