OracleÊý¾Ý¿â¼àÌýÅäÖÃ
½ü¶Îʱ¼äºÜ¶àÍøÓÑÌá³ö¼àÌýÅäÖÃÏà¹ØÎÊÌ⣬¿Í»§ÖÕ¶Ë(Client)ÎÞ·¨Á¬½Ó·þÎñÆ÷¶Ë(Server)¡£±¾ÎÄÏÖ¶Ô¼àÌýÅäÖÃ×÷Ò»¼òµ¥½éÉÜ£¬²¢Ìá³öһЩ¿Í»§ÖÕ¶ËÎÞ·¨Á¬½Ó·þÎñÆ÷¶ËµÄ½â¾ö˼·£¬Ô¸¶Ô¹ã´óÍøÓÑÓë¶ÁÕßÓÐһЩ°ïÖú¡£
Ò»¡¢¼àÌýÆ÷(LISTENER)
¡¡¡¡¼àÌýÆ÷ÊÇOracle»ùÓÚ·þÎñÆ÷¶ËµÄÒ»ÖÖÍøÂç·þÎñ£¬Ö÷ÒªÓÃÓÚ¼àÌý¿Í»§¶ËÏòÊý¾Ý¿â·þÎñÆ÷¶ËÌá³öµÄÁ¬½ÓÇëÇó¡£¼ÈÈ»ÊÇ»ùÓÚ·þÎñÆ÷¶ËµÄ·þÎñ£¬ÄÇôËüÒ²Ö»´æÔÚÓÚÊý¾Ý¿â·þÎñÆ÷¶Ë£¬½øÐмàÌýÆ÷µÄÉèÖÃÒ²ÊÇÔÚÊý¾Ý¿â·þÎñÆ÷¶ËÍê³ÉµÄ¡£
¶þ¡¢±¾µØ·þÎñÃû(Tnsname)
¡¡¡¡Oracle¿Í»§¶ËÓë·þÎñÆ÷¶ËµÄÁ¬½ÓÊÇͨ¹ý¿Í»§¶Ë·¢³öÁ¬½ÓÇëÇó£¬ÓÉ·þÎñÆ÷¶Ë¼àÌýÆ÷¶Ô¿Í»§¶ËÁ¬½ÓÇëÇó½øÐкϷ¨¼ì²é£¬Èç¹ûÁ¬½ÓÇëÇóÓÐЧ£¬Ôò½øÐÐÁ¬½Ó£¬·ñÔò¾Ü¾ø¸ÃÁ¬½Ó¡£
±¾µØ·þÎñÃûÊÇOracle¿Í»§¶ËÍøÂçÅäÖõÄÒ»ÖÖ£¬ÁíÍ⻹ÓÐOracleÃû×Ö·þÎñÆ÷(Oracle Names Server)µÈ¡£Oracle³£ÓõĿͻ§¶ËÅäÖþÍÊDzÉÓõı¾µØ·þÎñÃû£¬±¾ÎÄÖнéÉܵÄÒ²Ö÷ÒªÊÇ»ùÓÚ±¾µØ·þÎñÃûµÄÅäÖá£
Èý¡¢OracleÍøÂçÁ¬½ÓÅäÖ÷½·¨
¡¡¡¡Åä ÖÃOracle·þÎñÆ÷¶ËÓë¿Í»§¶Ë¶¼¿ÉÒÔÔÚÆä×Ô´øµÄͼÐλ¯OracleÍøÂç¹ÜÀíÆ÷(Oracle Net Manager)ÀïÍê³É£¨Ç¿ÁÒ½¨ÒéÔÚÕâ¸öͼÐλ¯µÄ¹¤¾ßÏÂÍê³ÉOracle·þÎñ¶Ë»ò¿Í»§¶ËµÄÅäÖã©¡£ÔÚWindowsÏ£¬µã»÷“¿ªÊ¼/³ÌÐò/Oracle - OraHome92/Configuration and Migration Tools/Net Manager”Æô¶¯OracleÍøÂç¹ÜÀíÆ÷¹¤¾ß£¬ÔÚLinux/UnixÏ£¬ÀûÓÃnetmgrÃüÁîÀ´Æô¶¯Í¼Ðλ¯OracleÍøÂç¹ÜÀíÆ÷£¬È磺
$ netmgr
WindowsÏÂÆô¶¯Net ManagerͼÐδ°¿ÚÈçÏÂͼʾ£º
ͼ(һ)
1¡¢ Oracle¼àÌýÆ÷ÅäÖÃ(LISTENER)
¡¡¡¡Èç ͼ(Ò»)ʾ£¬Ñ¡ÖÐÊ÷ÐÎĿ¼ÖмàÌý³ÌÐòÏÔÙµã»÷×óÉϲà“+”°´Å¥Ìí¼Ó¼àÌý³ÌÐò£¬µã»÷¼àÌý³ÌÐòĿ¼£¬Ä¬ÈÏмӵļàÌýÆ÷Ãû³ÆÊÇLISTENER(¸ÃÃû³ÆÒ²¿ÉÒÔ ÓÉÈÎÒâºÏ·¨×Ö·ûÃüÃû)¡£Ñ¡ÖиÃÃû³Æ£¬Ñ¡Öд°¿ÚÓÒ²àÀ¸ÏÂÀÑ¡ÏîÖеē¼àÌýλÖÔ£¬µã»÷Ìí¼ÓµØÖ·°´Å¥¡£ÔÚ³öÏÖµÄÍøÂçµØÖ·À¸µÄÐÒéÏÂÀÑ¡ÏîÖÐÑ¡ÖÐ “TCP/IP”£¬Ö÷»úÎı¾¿òÖÐÊäÈëÖ÷»úÃû³Æ»òIPµØÖ·(È
Ïà¹ØÎĵµ£º
ÉùÃ÷£ºÒÔÏÂÄÚÈÝת×Ô http://www.weixiuwang.com/Article/server/tech/200610/22126.html
1. ²éѯÕýÔÚÖ´ÐÐÓï¾äµÄÖ´Ðмƻ®(Ò²¾ÍÊÇʵ¼ÊÓï¾äÖ´Ðмƻ®)
select * from v$sql_plan where hash_value = (select sql_hash_value from v$session where sid = 1111);
ÆäÖÐidºÍparent_id±íʾ ......
alter system set nls_length_semantics='BYTE' scope=both
sql>show parameter length
NAME TYPE
------------------------------------ --------------------- ......
Õâ¸öOracleµÄ·ÖÒ³ÏÔʾ¾Ý˵ÊÇ×îÂé·³µÄ£¨MySQL×î¼òµ¥£©£¬µ«ÊÇÕâ¸ö·ÖÒ³ÏÔʾºÜÓÐÓá£ÏÖÔںܶàÍøÕ¾ÉϵÄÌõÄ¿¶¼·Ç³£¶à£¬ÀýÈçÐÂÎÅ£¬¿ÉÄܾ͸ոüеľÍÓÐÉÏ°ÙÌõ£¬ÔÙ¼ÓÉÏÒÔÇ°µÄ£¬Ò»ÕÅÒ³Ãæ¿Ï¶¨¾ÍÊǷŲ»ÏÂÁË£¬ËùÒÔ·ÖÒ³µÄºÃ´¦¾ÍÊÇ¿ÉÒÔ½â¾öÕâ¸öÎÊÌâ¡£
ÏÂÃæÒ»ÅÅÅŵĽÐÄãÑ¡ÔñµÚ¼¸Ò³£¬Ò»Ñ¡Ôñ£¬Ö±½Ó¾ÍÌøµ½ºóÃæµÄ¼¸Ò³È¥ÁË£¬²»ÓÃÕâÑù´ÓÉÏÒ ......
Oracle Êý¾ÝÀàÐͼ°´æ´¢·½Ê½
Ô¬¹â¶« Ô´´
¸ÅÊö
ͨ¹ýʵÀý£¬È«Ãæ¶øÉîÈëµÄ·ÖÎöoralceµÄ»ù±¾Êý¾ÝÀàÐͼ°ËüÃǵĴ洢·½Ê½¡£ÒÔORACLE 10GΪ»ù´¡£¬½éÉÜoralce 10gÒýÈëµÄеÄÊý¾ÝÀàÐÍ¡£ÈÃÄã¶ÔoracleÊý¾ÝÀàÐÍÓÐÒ»¸öȫеÄÈÏʶ¡£½ÒʾһЩ²»ÎªÈËÖªµÄÃØÃܺͱ»ºöÂÔµÄäµã¡£´ÓʵÓúÍÓÅ»¯µÄ½Ç¶È³ö·¢£¬ÌÖÂÛÿÖÖÊý¾ÝÀàÐ͵ÄÌص㡣´ÓÕ ......
×î½ü¹«Ë¾´òËãÔÚÏÂÒ»´ú¼Æ·ÑϵͳÀïÃæʹÓÃÄÚ´æÊý¾Ý¿âµÄ¼¼Êõ£¬ËùÒÔ×÷Ϊ¹«Ë¾µÄÉè¼ÆÈËÔ±Ö®Ò»µÄÎÒ£¬ÔÚoracleÍøÉÏÏÂÁ˸öTimesTen£¬°²×°ÔÚÎÒÃǵIJâÊÔ·þÎñÆ÷ÉÏÃæaix5£¬Õâƪ¶ÌÎÄÖ÷ÒªÊÇÎÒ²Ù×÷Êý¾Ý¿âµÄÒ»¸ö±Ê¼Ç£¬ÏÂһƪ´òËã·¢Ò»¸öc³ÌÐòµÄÀý×ÓºÍÎÒ²âÊԵĽá¹û£¬ºóÐø¿ÉÄÜ»¹»áʹÓÃTimesTen cache of oracleÕâ¸ö²úÆ·£¬Â½ÐøÒ²»á·¢Ò»ÏÂÕâ· ......