ºìÁªLinuxÃÅ»§
Linux°ïÖú

½¨Á¢oracle11GÊý¾Ý¿â

·¢²¼Ê±¼ä:2007-08-25 00:01:51À´Ô´:ºìÁª×÷Õß:furshow
¡¡¡¡Ö®Ç°°Ñserver½¨ÍêÁË£¬ÏÂÃ濪ʼ´´½¨database£¬Ö´ÐÐdbcaÆô¶¯´´½¨½çÃæ¡£ÄÚÈݸúÒÔÇ°Ò²²î²»¶à£¬Èç¹û¶Ôoracle½á¹¹±È½ÏÊìµÄ»°£¬½¨Òé×Ô¼º¶¨ÖÆËùÓеÄÑ¡ÏÕâ¸ö¿âÔÝʱû´òËãÓÃasm£¬ËùÒÔÏà¹ØµÄÑ¡Ïî²»Óùܡ£µ½×îºóÒ»²½ÎÒûֱ½Ó½¨¿â£¬¶øÊÇÖ»Éú³É½¨¿â½Å±¾£¬½áÊøÏòµ¼ºóÕÒµ½ÕâЩ½Å±¾£¬¼ì²éÓÐûÐèÒªµ÷ÕûµÄµØ·½¡£ÊÖ¹¤Ö´Ðнű¾ºóÊý¾Ý¿â½¨ºÃ£¬²é¿´°²×°ÈÕÖ¾ÊÇ·ñÓÐÒì³£µÄ´íÎó¡£Æäʵ½Å±¾»ù±¾ÊÇͨÓõģ¬Ö»ÒªÊÇÏàͬµÄÊý¾Ý¿â°æ±¾£¬¸Ä¸Ä¾Í¿ÉÒÔÖ±½ÓÓÃÁË£¬²»ÓÃÿ´Î¶¼ÓÃdbca×öÏòµ¼¡£

¡¡¡¡Èç¹ûҪʹÓÃ×Ô¶¯ÄÚ´æ¹ÜÀí£¬É趨memory_targetÖµ¾Í¿ÉÒÔÁË£¬ÔÚÒÔºóÊý¾Ý¿âÆô¶¯Íê³Éºó²é¿´Îļþϵͳtmpfs£¬»á·¢ÏÖËü±»Ê¹ÓÃÁË£¬ÁíÍâtmpfs£¨/dev/shm£©×îС²»ÄܵÍÓÚ300M£¬memory_targetµÄÉ趨ֵҲ²»ÄÜ´óÓÚÎļþϵͳtmpfsµÄÉ趨ֵ£¬·ñÔòÆô¶¯Ê±»á±¨´íORA-00845: MEMORY_TARGET not supported on this system£¬¿ÉÄÜʱÓÉÓÚtmpfsµÄÌØÐÔÎÊÌ⣬memory_targetºÍlock_sga²ÎÊý²»Äܹ²Óá£

¡¡¡¡Èç¹ûҪʹÓôóÄڴ棨µ÷Õûshm£¬¼ûserver°²×°²¿·Ö£¬ÄÇÀï700mÖ»ÊǸöÀý×Ó£¬ºÇºÇ£©ÐèÒªÉ趨USE_INDIRECT_DATA_BUFFERSΪtrue£¬Õâ¸ö²ÎÊýµÄ½âÊÍÈçÏ£º

¡¡¡¡USE_INDIRECT_DATA_BUFFERS controls how the system global area (SGA) uses memory. It enables or disables the use of the extended buffer cache mechanism for 32-bit platforms that can support more than 4 GB of physical memory. On platforms that do not support this much physical memory, this parameter is ignored.

¡¡¡¡¸Ð¾õÏà¶ÔÓÚAIX¡¢HP-UXϵͳÀ´Ëµ£¬linux¶ÔoracleµÄÖ§³ÖÒ»Ö±²»ÊǺÜÖÇÄÜ£¬5°æ±¾µ½µ×Óкα仯£¬»¹ÓдýÓÚÒÔºóµÄ·¢ÏÖÁË¡£¶ÔÓÚÎÒÕâ¸ölinux²ËÄñÀ´Ëµ£¬ÒªÁ˽âµÄ¶«Î÷»á¸ü¶à¡£
ÎÄÕÂÆÀÂÛ

¹²ÓÐ 0 ÌõÆÀÂÛ