Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracle Êý¾Ý¿âµÄ°ó¶¨±äÁ¿ÌØÐÔ¼°Ó¦ÓÃ

¹Ø¼ü´Ê:
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿âϵͳǰ,ÓÐË­¶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ¥ÕÆÎÕÁËSQLµÄд·¨,¾Í¿ªÊ¼ÁËÊý¾Ý¿âµÄ¿ª·¢,Æä½á¹ûÖ»ÄÜÊÇ¿ª·¢Ò»¸öûÓÐЧÂÊ,ҲûÓпÉÀ©Õ¹µÄϵͳ;
Òò´Ë,ÎÒдÕâ¸öÖ÷ÌâÒ²ÊÇÏ£ÍûÈôó¼Ò¸ü¶àµØÕÆÎÕOracleÊý¾Ý¿âµÄÌØÐÔ,´Ó¶øÔڼܹ¹Ò»¸öÐÂϵͳʱ,ÄÜ¿¼ÂÇϵͳµÄ¿ÉÀ©Õ¹,¿ÉÉìËõÐÔ,Ò²¼æ¹ËϵͳµÄЧÂʺÍÎȶ¨;
ʹÓð󶨱äÁ¿ÊÇOracleÊý¾Ý¿âµÄÌØÐÔÖ®Ò»;ÓÚÊÇ´ó¼ÒÒªÎÊ,ΪʲôʹÓÃ,ÔõÑùʹÓÃ,ËüµÄʹÓÃÏÞÖÆÌõ¼þÊÇʲô?ÎһᰴÕÕÕâÑùµÄÏ뷨ȥ½â´ð´ó¼ÒµÄÒÉÎÊ,ÎÒÒ²»áÒÔ¾ÙÀý×ӵķ½Ê½À´»Ø´ðÕâЩÎÊÌâ;
1. ΪʲôʹÓð󶨱äÁ¿?
ÕâÊǽâ¾öOracleÓ¦ÓóÌÐò¿ÉÉìËõÐÔµÄÒ»¸ö¹Ø¼ü»·½Ú;¶øOracleµÄ¹²Ïí³Ø¾Í¾ö¶¨ÁË¿ª·¢ÈËÔ±±ØÐëʹÓð󶨱äÁ¿;Èç¹ûÏëÒªOracle ÔËÐмõÂý,ÉõÖÁÍêÈ«ÖÕÖ¹,ÄǾͿÉÒÔ²»Óð󶨱äÁ¿;
ÕâÀï¾ÙÀý˵Ã÷ÉÏÊöÎÊÌâ;
ΪÁ˲éѯһ¸öÔ±¹¤´úºÅÊÇ123,Äã¿ÉÒÔÕâÑù²éѯ:
select * from emp where empno=’123’;
ÄãÒ²¿ÉÒÔÕâÑù²éѯ:
select * from emp where empno=:empno;
ÏóÎÒÃÇÍù³£Ò»Ñù,Äã²éѯԱ¹¤’123’Ò»´ÎÒÔºó,ÓпÉÄÜÔÙÒ²²»ÓÃ;½Ó×ÅÄãÓпÉÄܲéѯԱ¹¤’456’,È»ºó²éѯ’789’µÈµÈ;Èç¹û²éѯʹÓÃÏóµÚÒ»¸ö²éѯÓï¾ä,Äãÿ´Î²éѯ¶¼ÊÇÒ»¸öеIJéѯ(ÎÒÃǽÐËüÓ²±àÂëµÄ²éѯ·½·¨);Òò´Ë,Oracleÿ´Î±ØÐë·ÖÎö,½âÎö,°²È«¼ì²é, ÓÅ»¯µÈµÈ;
µÚ¶þ¸ö²éѯÓï¾äÌṩÁ˰󶨱äÁ¿:empno,ËüµÄÖµÔÚ²éѯִÐÐʱÌṩ,²éѯ¾­¹ýÒ»´Î±àÒëºó,²éѯ·½°¸´æ´¢ÔÚ¹²Ïí³ØÖÐ,¿ÉÒÔÓÃÀ´¼ìË÷ºÍÖØÓÃ;ÔÚÐÔÄܺÍÉìËõÐÔ·½Ãæ,ÕâÁ½ÕߵIJîÒìÊǾ޴óµÄ,ÉõÖÁÊǾªÈ˵Ä;ͨË׵㽲,¾Í²»ÊÇÒ»¸ö¼¶±ð;
µÚÒ»¸ö²éѯʹÓÃµÄÆµÂÊÔ½¸ß,ËùÏûºÄµÄϵͳӲ¼þ×ÊÔ´Ô½´ó,´Ó¶ø½µµÍÁËÓû§µÄʹÓÃÊýÁ¿;ËüÒ²»á°ÑÓÅ»¯ºÃµÄÆäËü²éѯÓï¾ä´Ó¹²Ïí³ØÖÐÌß³ö;¾ÍÏóÒ»¸öÀÏÊó»µÁËÒ»¹øÌÀËÆµÄ,ϵͳµÄÕûÌåÐÔÄܽµµÍ; ¶øÖ´Ðа󶨱äÁ¿,Ìá½»Ïàͬ¶ÔÏóµÄÍêÈ«ÏàͬµÄ²éѯµÄÓû§(Õâ¾ä»°,´ó¼ÒÌýÆðÀ´±È½ÏÄÑÀí½â,ËæºóÎÒ»á¸ø³öÏêϸµÄ½âÊÍ),Ò»´ÎÐÔʹÓþͿÉÖØ¸´Ê¹ÓÃ,ÆäЧÂʲ»ÑÔ¶úÓï; ´ò¸öÐÎÏóµÄ±ÈÓ÷À´Ëµ,µÚÒ»¸ö²éѯ¾ÍÏóÒ»´ÎÐÔʹÓõĿê×Ó,¶øµÚ¶þ¸ö²éѯÏóÊÇÌú¿ê×Ó,ֻҪϴ¸É¾»,ÕÅÈýÀîËͼÄÜÓÃ,ºÏÀíÓÐЧµØÊ¹ÓÃÁË×ÊÔ´;
ÏÂÃæ¾ÙÀý×ÓÈ¥ÏêϸÂÛÖ¤ÉÏÊöµÄÎÊÌâ,²»Ê¹Óð󶨱äÁ¿ÎªÉú²¡×´¿ö:
ÕâÊÇÒ»¸öδʹÓõİ󶨱äÁ¿(³Ôҩǰ):
set echo on;(°ÑÖ´Ðнá¹ûÏÔʾ³öÀ´)
alter system flush shared_pool;
Õâ


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

28.2 OracleÊý¾Ý¿â·þÎñÆ÷µÄ°²×°

28.2  OracleÊý¾Ý¿â·þÎñÆ÷µÄ°²×°
Óû§¿ÉÒÔͨ¹ýOracleµÄ¹Ù·½ÍøÕ¾ÏÂÔØµ½×îеÄOracleÊý¾Ý¿â²úÆ·µÄÈí¼þ°²×°°ü£¬ÔÚ°²×°Oracle 11gǰÐèÒª¼ì²éϵͳµÄÈíÓ²¼þ»·¾³ÊÇ·ñ·ûºÏ°²×°ÒªÇó¡£Oracle 11gÌṩͼÐλ¯µÄ°²×°³ÌÐò½çÃæ£¬Óû§¿ÉÒÔͨ¹ýµ¥»÷Êó±êÍê³ÉOracleµÄ°²×°¡£ ......

28.2.1 ÈçºÎ»ñµÃOracle°²×°°ü

28.2.1  ÈçºÎ»ñµÃOracle°²×°°ü
ËäÈ»OracleÊý¾Ý¿âÊÇÒ»Ì×ÉÌÒµÈí¼þ£¬µ«ÊÇÓû§¿Éͨ¹ýOracle¹Ù·½ÍøÕ¾http://www.oracle.comÃâ·ÑÏÂÔØOracleÊý¾Ý¿âµÄ°²×°°üÎļþ¡£µ«ÔÚÏÂÔØÇ°ÐèÒªÏÈ×¢²áÒ»¸öÓû§Õ˺ţ¬²¢ÇÒ²»ÄܰÑÏÂÔØµÃµ½µÄOracleÈí¼þÓÃÓÚÉÌÒµÓÃ;£¬Èçͼ28.1Ëùʾ¡£
ͼ28.1 ÏÂÔØOracle 11g
Ñ¡ÔñÏÂÔØ“Oracle Database 11 ......

oracle Æô¶¯ºÍÍ£Ö¹Êý¾Ý¿â

Æô¶¯ºÍÍ£Ö¹Êý¾Ý¿â
Àý³Ì£­>ÅäÖã­>Ò»°ãÐÅÏ¢ÖÐ Æô¶¯ºÍÍ£Ö¹Êý¾Ý
Í£Ö¹Êý¾Ý¿âÓ¦¸ÃÑ¡Ôñ£ºµ±ËùÓÐÊÂÎñ½áÊøÊ±¡£
Ò²¿ÉÒÔÓÃÃüÁîÆô¶¯ºÍÍ£Ö¹(ÓÃoracleÓû§µÇ½)
Æô¶¯   £º lsnrctl start     //Æô¶¯ lister
          sqlplus /nolog <<EO ......

28.4.3 ¼ì²âOracleÊý¾Ý¿â״̬

28.4.3  ¼ì²âOracleÊý¾Ý¿â״̬
OracleÆô¶¯ºó£¬Îª¼ì²âOracle·þÎñµÄÔËÐÐÊÇ·ñÕý³££¬¿ÉÒÔÖ´ÐÐpsÃüÁî¼ì²éÏà¹ØµÄOracle·þÎñ½ø³Ì£¬Ò²¿ÉÒÔͨ¹ýOracleËùÌṩµÄÃüÁî½øÐмì²é¡£¾ßÌå½éÉÜÈçÏÂËùʾ¡£
£¨1£©Ö´ÐÐpsÃüÁî²é¿´Êý¾Ý¿â½ø³ÌÇé¿ö¡£
 
ps -ef | grep oracle
 
£¨2£©ÔÚsqlplusÖÐÖ´ÐÐÃüÁî²é¿´Êý¾Ý¿â״̬¡£
&nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ