´óÐÍORACLEÊý¾Ý¿âÓÅ»¯Éè¼Æ·½°¸
±¾ÎÄÖ÷Òª´Ó´óÐÍÊý¾Ý¿âORACLE»·¾³Ëĸö²»Í¬¼¶±ðµÄµ÷Õû·ÖÎöÈëÊÖ£¬·ÖÎöORACLEµÄϵͳ½á¹¹ºÍ¹¤×÷»úÀí£¬´Ó¾Å¸ö²»Í¬·½Ãæ½ÏÈ«ÃæµØ×ܽáÁËORACLEÊý¾Ý¿âµÄÓÅ»¯µ÷Õû·½°¸¡£
¹Ø¼ü´Ê ORACLEÊý¾Ý¿â»·¾³µ÷ÕûÓÅ»¯Éè¼Æ·½°¸
¶ÔÓÚORACLEÊý¾Ý¿âµÄÊý¾Ý´æÈ¡£¬Ö÷ÒªÓÐËĸö²»Í¬µÄµ÷Õû¼¶±ð£¬µÚÒ»¼¶µ÷ÕûÊDzÙ×÷ϵͳ¼¶°üÀ¨Ó²¼þƽ̨,
µÚ¶þ¼¶µ÷ÕûÊÇORACLE RDBMS¼¶µÄµ÷Õû, µÚÈý¼¶ÊÇÊý¾Ý¿âÉè¼Æ¼¶µÄµ÷Õû, ×îºóÒ»¸öµ÷Õû¼¶ÊÇSQL¼¶¡£Í¨³£ÒÀ´ËËļ¶µ÷Õû¼¶±ð¶ÔÊý¾Ý¿â½øÐе÷Õû¡¢ÓÅ»¯£¬Êý¾Ý¿âµÄÕûÌåÐÔÄÜ»áµÃµ½ºÜ´óµÄ¸ÄÉÆ¡£ÏÂÃæ´Ó¾Å¸ö²»Í¬·½Ãæ½éÉÜORACLEÊý¾Ý¿âÓÅ»¯Éè¼Æ·½°¸¡£
Ò»¡¢Êý¾Ý¿âÓÅ»¯×ÔÓɽṹOFA(Optimal flexible Architecture)
Êý¾Ý¿âµÄÂß¼ÅäÖöÔÊý¾Ý¿âÐÔÄÜÓкܴóµÄÓ°Ïì,Ϊ´Ë,ORACLE¹«Ë¾¶Ô±í¿Õ¼äÉè¼ÆÌá³öÁËÒ»ÖÖÓÅ»¯½á¹¹OFA¡£Ê¹ÓÃÕâÖֽṹ½øÐÐÉè¼Æ»á´ó´ó¼ò»¯ÎïÀíÉè¼ÆÖеÄÊý¾Ý¹ÜÀí¡£ÓÅ»¯×ÔÓɽṹOFA,¼òµ¥µØ½²¾ÍÊÇÔÚÊý¾Ý¿âÖпÉÒÔ¸ßЧ×ÔÓɵطֲ¼Âß¼Êý¾Ý¶ÔÏó,Òò´ËÊ×ÏÈÒª¶ÔÊý¾Ý¿âÖеÄÂß¼¶ÔÏó¸ù¾ÝËûÃǵÄʹÓ÷½Ê½ºÍÎïÀí½á¹¹¶ÔÊý¾Ý¿âµÄÓ°ÏìÀ´½øÐзÖÀà,ÕâÖÖ·ÖÀà°üÀ¨½«ÏµÍ³Êý¾ÝºÍÓû§Êý¾Ý·Ö¿ª¡¢Ò»°ãÊý¾ÝºÍË÷ÒýÊý¾Ý·Ö¿ª¡¢µÍ»î¶¯±íºÍ¸ß»î¶¯±í·Ö¿ªµÈµÈ¡£
Êý¾Ý¿âÂß¼Éè¼ÆµÄ½á¹ûÓ¦µ±·ûºÏÏÂÃæµÄ×¼Ôò£º£¨1£©°ÑÒÔͬÑù·½Ê½Ê¹ÓõĶÎÀàÐÍ´æ´¢ÔÚÒ»Æ𣻣¨2£©°´ÕÕ±ê׼ʹÓÃÀ´Éè¼Æϵͳ£»£¨3£©´æÔÚÓÃÓÚÀýÍâµÄ·ÖÀëÇøÓò£»£¨4£©×îС»¯±í¿Õ¼ä³åÍ»£»£¨5£©½«Êý¾Ý×Öµä·ÖÀë¡£
¶þ¡¢³ä·ÖÀûÓÃϵͳȫ¾ÖÇøÓòSGA£¨SYSTEM GLOBAL AREA)
SGAÊÇoracleÊý¾Ý¿âµÄÐÄÔà¡£Óû§µÄ½ø³Ì¶ÔÕâ¸öÄÚ´æÇø·¢ËÍÊÂÎñ£¬²¢ÇÒÒÔÕâÀï×÷Ϊ¸ßËÙ»º´æ¶ÁÈ¡ÃüÖеÄÊý¾Ý£¬ÒÔʵÏÖ¼ÓËÙµÄÄ¿µÄ¡£ÕýÈ·µÄSGA´óС¶ÔÊý¾Ý¿âµÄÐÔÄÜÖÁ¹ØÖØÒª¡£SGA°üÀ¨ÒÔϼ¸¸ö²¿·Ö£º
1¡¢Êý¾Ý¿é»º³åÇø£¨data block buffer cache£©ÊÇSGAÖеÄÒ»¿é¸ßËÙ»º´æ£¬Õ¼Õû¸öÊý¾Ý¿â´óСµÄ1%-2%£¬ÓÃÀ´´æ´¢´ÓÊý¾Ý¿âÖضÁÈ¡µÄÊý¾Ý¿é£¨±í¡¢Ë÷Òý¡¢´ØµÈ£©£¬Òò´Ë²ÉÓÃleast recently used (LRU,×î½ü×îÉÙʹÓÃ)µÄ·½·¨½øÐпռä¹ÜÀí¡£
2¡¢×ֵ仺³åÇø¡£¸Ã»º³åÇøÄÚµÄÐÅÏ¢°üÀ¨Óû§Õ˺ÅÊý¾Ý¡¢Êý¾ÝÎļþÃû¡¢¶ÎÃû¡¢ÅÌÇøλÖᢱí˵Ã÷ºÍȨÏÞ£¬ËüÒ²²ÉÓÃLRU·½Ê½¹ÜÀí¡£
3¡¢ÖØ×öÈÕÖ¾»º³åÇø¡£¸Ã»º³åÇø±£´æΪÊý¾Ý¿â»Ö¸´¹ý³ÌÖÐÓÃÓÚÇ°¹ö²Ù×÷¡£
4¡¢SQL¹²Ïí³Ø¡£±£´æÖ´Ðмƻ®ºÍÔËÐÐÊý¾Ý¿âµÄSQLÓï¾äµÄÓï·¨·ÖÎöÊ÷¡£Ò²²ÉÓÃLRUËã·¨¹ÜÀí¡£Èç¹ûÉèÖùýС£¬Óï¾ä½«±»Á¬Ðø²»¶ÏµØÔÙ×°È
Ïà¹ØÎĵµ£º
sql plus ±£´æsqlÓï¾ä
save 'd:\sql.txt';½«oracle»º´æÇøÖеÄsqlÓï¾ä´æÈëÎļþ¡£
get 'd:\sql.txt';´ËʱsqlÓï¾ä±»¼ÓÔص½oracle»º´æÇø£¬Ê¹ÓÃrun;ÃüÁîÖ´ÐÐsqlÓï¾ä¡£
@'d:\sql.txt';¼ÓÔØsqlÓï¾ä²¢Ö±½ÓÖ´ÐС£
oracleÖеĺ¯Êý
1. ת»»º¯Êý
TO_CHAR(number[,format])
½«Ò»¸öÊýֵת»»³ÉÓëÖ®µÈ¼ÛµÄ×Ö·û´®.Èç¹û²»Ö¸ ......
ÀûÓÃoracle×Ô´øµÄutl_file°ü¿ÉÒÔ·ÃÎÊ´ÅÅÌÎļþ£¬µ«ÓиöÏÞÖÆ--ÎÞ·¨·ÃÎÊÎļþ¼Ð£¿Ê²Ã´Òâ˼ÄØ£¿¾ÍÊÇ˵oracleÖ»ÄÜ·ÃÎÊÖ¸¶¨µÄÎļþ£¬¶ø²»ÄÜ·ÃÎÊÎļþ¼ÐϵÄδ֪Îļþ¡£ËùÒÔ£¬Èç¹ûҪͨ¹ýoracleÈ¥±éÀúijָ¶¨Â·¾¶ÏµÄËùÓÐÎļþ£¬sorry, impossible! µ«ÊÇ£¬ÓÐÒ»ÖÖÌæ´ú·½°¸¿ÉÒÔÖúÄãÒ»±ÛÖ®Á¦£¡
ÖÚËùÖÜÖªjavaÖ®FileÀàÖ¸ÏòµÄ¿ÉÒÔÊÇĿ¼Ҳ¿ÉÒÔÊ ......
1 ¡¢°²×°Ç°µÄ×¼±¸
1.1 ¼ì²éÓ²¼þ
ÎïÀíÄڴ棺 # grep MemTotal /proc/meminfo
½»»»¿Õ¼ä£º # grep SwapTotal /proc/meminfo
½»»»¿Õ¼äµÄ´óСÊǸù¾ÝÎïÀíÄÚ´æµÄ´óСÀ´ÉèÖõģ¬ÎïÀíÄÚ´æÉÙÓÚ 2G µÄÔò½»»»¿Õ¼äÉèΪÎïÀíÄÚ´æµÄÁ½±¶£¬ÎïÀíÄÚ´æ´óÓÚ 2G µÄÔò½»»»¿Õ¼äºÍÎïÀíÄÚ´æ´óСһÑù¡£Èç¹û²»·ûºÏÉÏÊö¹æ¶¨£¬ÄÇô¾ÍÐèÒªÖØÐÂÉèÖý ......
D:\oracle\product\10.2.0\db_2\NETWORK\ADMIN
6¡¢ÐÞ¸Äoracle°²×°Â·¾¶ÏÂD:\oracle\product\10.2.0\db_2\NETWORK\ADMIN\tnsnames.oraµÄtnsnames.oraÎļþ£¬Ìí¼Ó
XXX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.12.42 ......
ORACLEÊý¾Ý¿â²åÈëÐÔÄܲâÊÔ
MKing
2010-3-8
²âÊÔ»·¾³»ù±¾ÐÅÏ¢£º
OS£ºWindows XP sp3
DB£ºOracle 9.2.0.1 δÆôÓù鵵
DBÖØ×öÈÕÖ¾Îļþ´óС£º100MB
Ó²ÅÌÐͺţºSAMSUNG HD161GJ£¨SATA-300,160G,7200rpm,8M cache£©
CPU£ºIntel Core2 E8400£¨3.0G£©
Äڴ棺2G
ͨ¹ýHD TuneµÃµ½µÄÓ²ÅÌ»ù±¾²âÊÔÐÅÏ ......