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

ORACLEÌåϵ½á¹¹ ÄÚ´æ½á¹¹

ORACLEÊý¾Ý¿âÆô¶¯Ê±·ÖÅäÒ»´ó¿é·Ç³£´óµÄÄÚ´æÇøÓò¡£ORACLEÔËÐйý³ÌÖÐËùÓеIJÙ×÷¶¼ÔÚÕâÀï½øÐС£
ORACLEÄÚ´æ=SGA+PGA¡£
SGA=Êý¾Ý¸ßËÙ»º³åÇø+ÈÕÖ¾»º³åÇø+¹²Ïí³Ø+´ó³Ø+Java³Ø¡£
Êý¾Ý¸ßËÙ»º³åÇø£ºÊý¾Ý¸ßËÙ»º³åÇøÊÇ×î½ü´ÓÊý¾ÝÎļþÖмìË÷³öÀ´µÄÊý¾Ý£¬»º´æÆðÀ´¹©ËùÓÐÓû§¹²Ïí¡£
ÈÕÖ¾»º³åÇø£º»º´æÓû§¶ÔÊý¾Ý¿âÖ´Ðеĸ÷Àà²Ù×÷µÄÖØ×ö¼Ç¼¡£
¹²Ïí³Ø£º»º´æ×î½üÖ´ÐйýµÄSQLÃüÁî¡¢PL/SQL³ÌÐò¡¢Êý¾Ý×ֵ䡣ÊǶÔSQL¡¢PL/SQL½øÐзÖÎö¡¢±àÒë¡¢Ö´ÐеÄÇøÓò¡£
¹²Ïí³Ø=¿â»º´æ£¨SQL¹¤×÷Çø+PL/SQL¹¤×÷Çø£©+Êý¾Ý×ֵ仺´æ
´ó³Ø£ºÕâÊÇÒ»¸ö¿ÉÑ¡µÄÄÚ´æÅäÖÃÏÖ÷ҪΪORACLE¶àÏ̷߳þÎñÆ÷¡¢·þÎñÆ÷I/O½ø³Ì¡¢Êý¾Ý¿â±¸·ÝºÍ»Ö¸´²Ù×÷¡¢Ö´ÐоßÓдóÁ¿ÅÅÐò²Ù×÷µÄSQLÓï¾äµÈÐèÒª´óÁ¿»º´æÊ±ÌṩÄÚ´æ¿Õ¼ä¡£
Java³Ø£ºÌá¸ß¶ÔJava³ÌÐò¿ª·¢µÄÖ§³Ö£¬ÓÃÓÚ´æ´¢Java³ÌÐò¡¢JavaÓï·¨·ÖÎö±í¡¢JavaÓï¾äµÄÖ´Ðз½°¸ºÍJava³ÌÐò¿ª·¢
PGA=ÅÅÐòÇø+»á»°Çø+ÓαêÇø+¶ÑÕ»Çø
ÅÅÐòÇø£ºÓÃÓÚ´æ·ÅÅÅÐò²Ù×÷Ëù²úÉúµÄÁÙʱÊý¾Ý
»á»°Çø£º´æ´¢µ±Ç°»á»°µÄÐÅÏ¢£¬Óû§Ãû¡¢¿ÚÁȨÏÞ¡¢½ÇÉ«µÈÐÅÏ¢
ÓαêÇø£º´æ·ÅÓαê²Ù×÷ʱ²úÉúµÄÊý¾Ý
¶ÑÕ»Çø£ºÓÃÓÚ±£´æ»á»°¹ý³ÌÖеıäÁ¿


Ïà¹ØÎĵµ£º

Oracle Êý¾Ý¿âµÄ°²×°

 
   ×°ÁËÒ»Ò¹µÄÈí¼þ£¬ÏÈÊÇMySQL£¬myEclipse,Oracle ,²»¶ÏµÄ³ö´í£¬OracleServise²»ÄÜÆô¶¯£¬ºÜÊÇ·³ÈË£¬Ð¶ÔØÁËOracelÁ½´Î£¬ÓÖ֨װ£¬´íÎóµÃµ½Ò»Ð©½â¾ö£¬×¢²á±í³öÏÖÁ˺öàµÄÎÊÌ⣬ÒÔǰÔÚÐ¶ÔØÈí¼þµÄʱºò£¬¶¼Ã»ÓÐÓÃרÓõŤ¾ß£¬×¢²á±íÒ»ÍÅÂÒ£¬ÕæÊÇÏ൱µÄºó»Ú£¬ÏÖÔÚ¿´À´ÒªÏë¸Ä¹ýÀ´È·ÊµÊǺÜÄѵÄÀ²£¡ÒÔºóÕâ·½ÃæÒª¶à¼ ......

Oracle RACѧϰ±Ê¼Ç (¶þ)

Oracle RAC Workload Management:
service   usage   preferred instances      available instances     prority         response time warning/critical
ERP      &nb ......

Oracle³£¼ûÎÊÌâÕï¶Ï


1       ORA-12571¡¢ORA-03113¡¢ORA-03114¡¢ORA-01041
ÌØÕ÷£º¿Í»§¶Ë£¨´úÀí»òÓ¦Ó÷þÎñÆ÷£©ÓÐʱ±¨ÕâÀà¶ÏÁ¬´íÎó
Ô­Òò£ºÈç¹ûż¶û³öÏÖÒ»´Î£¬Ôò¿ÉÄÜÎªÍøÂçÔ­Òò»òÓû§Òì³£ÖÐÖ¹£¬Èç¹û¾­³£³öÏÖÔòΪ¿Í»§¶ËÓë·þÎñ¶ËµÄ×Ö·û¼¯²»Ò»Ö¡£
´ëÊ©£ºÈç¹ûż¶û³öÏÖ£¬¿ÉÔÚ·þÎñ¶ËµÄЭÒéÅäÖÃÎļþPROTOCOL.ORAÖÐÔö¼ÓÒ»ÐÐ
TC ......

oracle 11g ORA 12514´íÎó£¬ÎҵĽâ¾ö°ì·¨

ǰÑÔ:ÍøÉÏÓкܶà½â¾ö°ì·¨£¬É¾listener.oraÒ²ºÃ£¬»¹ÊÇʲôҲºÃ£¬¶¼½â¾ö²»ÁËÎÒÕâ¸öÎÊÌ⣬ÒÀÈ»±¨12514´íÎó£¬ÒÔÏÂÊÇÎÒÖð¸ö³¢ÊÔºó³É¹¦µÄ¼àÌý×Ö·û´®¡£¡£
listener.oraÎļþ£º
# listener.ora Network Configuration File: d:\app\john\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration too ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ