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

OracleÊý¾Ý¿âÖ÷»úÃûÖØ¹¹£¨For Windows£©

ÔÚNet Manager¹¤¾ßÖУ¬  
  ½«¼àÌý³ÌÐòµÄ¼àÌýλÖõÄÖ÷»úÃû¸ÄΪ  лúÃû  
  ½«·þÎñÃûÖжÔÓ¦Êý¾Ý¿âµÄÖ÷»úÃû¸ÄΪ  лúÃû  
   
  ¸ÄÁ˼àÌý³ÌÐòºó£¬ÔÚMS-DOSÖÐÔËÐР 
  lsnrctl   stop  
  lsnrctl   start
  (ÖØÆô¼àÌý³ÌÐò£¬Èç¹ûûÓÐÆô¶¯¼àÌý£¬¿ÉÒÔʡȥ´Ë²½Öè)


Ïà¹ØÎĵµ£º

Oracleѧϰ±Ê¼Ç5 JDBC²Ù×÷Oracle

ÓÃJavaÀ´²Ù×÷Êý¾Ý¿â£¬ÓÐÈçϼ¸ÖÖ·½Ê½£º
1JDBC-ODBCÇÅ£ºODBCÊý¾ÝÔ´ÔÚ²Ù×÷ϵͳ²ãÃæ¸øÓèÁËÖ§³Ö£¬ÎÒÃÇ¿ÉÒÔ²»ÓÃÁ˽âµ×²ãµ½µ×ÊÇ·â×°µÄÄÄÖÖÊý¾ÝÔ´£¬Ò²ÕÕÑù¿ÉÒÔÍê³É¶ÔÊý¾ÝµÄ²Ù×÷¡£µ«ÊÇËüÓÐÆ½Ì¨ÒÀÀµÐÔ£¬²»Ì«ÍƼöʹÓá£
2Javaµ½±¾µØAPI
3Javaµ½ÍøÂçЭÒé
4Javaµ½Êý¾Ý¿âЭÒ飺ËÙ¶È×î¿ì
Á¬½ÓÊý¾Ý¿â¿ÉÒÔ·ÖΪËIJ½£º
A¼ÓÔØÇý¶¯³ÌÐò£¨Ï ......

ORACLE°ó¶¨±äÁ¿µÄʹÓà ժ³­×ÔһƬÌû×Ó

±¾ÎÄÀ´×Ôhttp://www.cnblogs.com/rootq/articles/1177562.html
Oracle Êý¾Ý¿âµÄ°ó¶¨±äÁ¿ÌØÐÔ¼°Ó¦ÓÃ
¹Ø¼ü´Ê:
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿âϵͳǰ,ÓÐË­¶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ ......

ORACLE Êý¾Ý¿âÃû¡¢ÊµÀýÃû¡¢ORACLE_SIDµÄÇø±ð

Êý¾Ý¿âÃû(DB_NAME)¡¢ÊµÀýÃû(Instance_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)
ÔÚORACLE7¡¢8Êý¾Ý¿âÖÐÖ»ÓÐÊý¾Ý¿âÃû(db_name)ºÍÊý¾Ý¿âʵÀýÃû(instance_name)¡£ÔÚORACLE8i¡¢9iÖгöÏÖÁËеIJÎÊý£¬¼´Êý¾Ý¿âÓòÃû(db_domain)¡¢·þÎñÃû(service_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)¡£ÕâЩ¶¼´æÔÚÓÚͬһ¸öÊý¾Ý¿âÖеıêʶ£¬ÓÃÓÚÇ ......

oracle 10.2.0.4ÏÂÔØµØÖ·


ÏÂÔØ·½·¨£ºÔÚÏÂÃæµÄÁ¬½ÓÉϵã»÷ÓÒ¼ü£¬Ñ¡ÔñʹÓÃѸÀ×ÏÂÔØ¡£Ê¹ÓñðµÄÏÂÔØ¹¤¾ßÎÞ·¨ÏÂÔØ¡£
oracle 10.2.0.4 ²¹¶¡ÏÂÔØ£¨ÊÊÓÃÓÚËùÓвÙ×÷ϵͳ£©:
ftp://updates.oracle.com/6810189/p6810189_10204_AIX5L.zip
ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-IA64.zip
ftp://updates.oracle.com/6810189/p6810189_10204 ......

Oracle¶¯Ì¬ÐÔÄÜÊÓͼѧϰ֮ V$ROLLSTAT

À´Ô´ÓÚhttp://hi.baidu.com/edeed/blog/item/33576327d1b73d00918f9dd4.html
±¾ÊÓͼ×ÔÆô¶¯¼´±£³Ö²¢¼Ç¼¸÷»Ø¹ö¶Îͳ¼ÆÏî¡£ÔÚѧϰ±¾ÊÓͼ֮ǰ£¬ÎÒÃÇÏÈÀ´Á˽âһϻعö¶Î(rollback segment)µÄÏà¹Ø¸ÅÄ
»Ø¹ö¶Î¸ÅÊö
»Ø¹ö¶ÎÓÃÓÚ´æ·ÅÊý¾ÝÐÞ¸Ä֮ǰµÄÖµ£¨°üÀ¨Êý¾ÝÐÞ¸Ä֮ǰµÄλÖúÍÖµ£©¡£»Ø¹ö¶ÎµÄÍ·²¿°üº¬ÕýÔÚʹÓõĸûعö¶ÎÊÂÎñµÄÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ