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

Introduction to Oracle Wait Interface notes

     ÎÄÕÂÌáµ½£¬ÓÃCache hit ratioµÄ·½·¨À´¼ì²éORACLEÐÔÄÜÎÊÌâ¹ýʱÁË£¬ÀïÃæÓоä·Ç³£ÐÎÏóµÄ»°£ºÕâÎÞÒìÓÚÒ»¸öÒ½ÉúÖ»ÖªµÀ¸ù¾ÝѪѹµÄÀ´ÖÎÁƲ¡ÈË£¬¶ø²¡ÈËÓÉÓÚÌÛÍ´£¬Éñ¾­ÐË·Ü£¬ÑªÑ¹ÔÚÒ»¸öºÏÀíµÄ·¶Î§ÄÚ£¬Ò½ÉúÈ´¸æËß»¼Õߣ¬Äãû²¡£¬µÈÄãѪѹµÍµÄʱºòÔÙÀ´¡£Í¬ÑùµÄ£¬ÎÒÃDz»Äܽö½ö¸ù¾ÝCache hit ratioÀ´ÅжÏORACLEÊý¾Ý¿âÊÇ·ñ³öÁËÎÊÌ⣬ÐèÒª×ۺϿ¼ÂÇ£¬ÎÒÃÇDBAÄܵ±ÄǸöÒ½ÉúÂð£¿
     ¸ßµÄcache hit ratio ²»ÄÜ˵Ã÷ÐÔÄܾÍÒ»¶¨ºÜºÃ£¬µÍµÄcache hit ratioÒ²²»×ÜÊÇ˵ÐÔÄܲ»ºÃ£¬ÊÂʵÉÏÓкܶàʱºò£¬cache hit ratio ¾­³£ºÜµÍ£¬µ«ÊÇÐÔÄÜȴûÓжªÊ§¡£
     ÎÄÕÂÓÖÌáµ½£¬OWIÊÇÎÒÃÇÊ×Ñ¡µÄµ÷·½·¨£¬ÔÚORACLE10gEM performanceµÄÒ³ÃæÒ²Ã»ÓгöÏÖcache hit ratio,Ëü±»ORACLEÅׯúÁË¡£
     ÏÖÔÚ¿´µ½µÚÒ»ÕŵÚÎåÒ³.....Ã÷Ìì¼ÌÐø¡£
     ÏÖÔÚORACLEÌá³öÁËÊý¾Ý¿âÏìӦʱ¼ä£¨Response Time£©µÄµ÷ÕûÄ£ÐÍ Response Time=ServiceTime+WaitTime.
     ServiceTime ÊÇÒ»¸ö½ø³Ì»¨·ÑÔÚCPUÉϵÄ×Üʱ¼ä£¬WaitTimeÊÇÒ»¸ö½ø³ÌΪÁ˼ÌÐø¹¤×÷¶øµÈ´ýËùÐè×ÊÔ´µÄ×Üʱ¼ä¡£Ò»¸ö½ø³ÌҪô´¦Óڻ״̬£¨ÀûÓÃCPU´¦ÀíÇëÇ󣩣¬ÒªÃ´³öÓڵȴý״̬£¨CPUµÈ´ý£©£¬ÎÒÃÇ¿ÉÒÔͨ¹ýËõ¶ÌServiceTime,»òÕßWaitTimeÀ´ÌáResponsetime¡£
      ÔÚÎÒÃÇÕÆÎÕOWI·½·¨Ö®Ç°£¬ÎÒÃDZØÐë¸Ä±ä3ÖֹؼüµÄÐÐΪ:
    1.ÎÒÃDZØÐëֹͣͨ¹ý²âÁ¿·ÇÍÌÍÂÁ¿µÄÃüÖÐÂÊÀ´¼ì²âÐÔÄÜ¡£
    2.ÎÒÃÇÒª¿ªÊ¼Ñ§Ï°²âÁ¿process response timeÀ´¼ì²âÐÔÄÜ¡£
    3.ÎÒÃDZØÐë¹Û²ìresponse time µ÷Õû·½·¨ÖеÄ×ÊÔ´ÏûºÄ¡£
¿´ÍêÕâÕº󣬸øÎÒµÄ×ÜÌå¸Ð¾õ¾ÍÊÇ×÷ÕßÏëÒªÎÒÃǶÁÕßѧ»á¹Û²ìResponse TimeµÄ·½·¨À´µ÷ÕûORACLEµÄÐÔÄÜ¡£


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

ORACLE PL/SQL ¶ÔÏó(object)ѧϰ±Ê¼Ç(Èý)

7¡¢¶ÔÏóÀàÐͼ̳Ð
 
¶ÔÏóÀàÐÍʵÏÖÔÊÐíÎÒÃÇ´´½¨Ò»¸ö»ùÀàÐÍ£¬»ò½Ð¸¸ÀàÐÍ£¬ÕâÖÖÀàÐ͵ÄÊôÐÔ»ò·½·¨¿ÉÒÔ±»ÁíÒ»¸ö¶ÔÏóÀàÐͼ̳С£È»ºó¿ÉÒÔ´´½¨Ò»¸ö×ÓÀàÐÍ£¬»ò½Ðº¢×ÓÀàÐÍ£¬Ö±½ÓʹÓü̳йýÀ´µÄÊôÐÔ»ò·½·¨£¬»òÕßÓÃ×Ô¼ºµÄÊôÐԺͷ½·¨ÖØÐ´¸¸ÀàÐ͵ÄÊôÐÔ»ò·½·¨¡£
 
INSTANTIABLE¹Ø¼ü×Ö±íʾÎÒÃÇ¿ÉÒÔ´Ó¸ÃÀàÐÍÖÐʵÀý»¯»òÕß´´½¨¶ÔÏ ......

CentOS 5ϰ²×°Oracle 11g

Oracle¹«Ë¾Ðû³ÆÔÚLinuxϰ²×°Oracle9iÊý¾Ý¿âÖÁÉÙÒªÓÐ512MBµÄÄÚ´æºÍÖÁÉÙ1GB»òÕßÁ½±¶     
ÄÚ´æ´óСµÄ½»»»¿Õ¼ä£¬¶ÔÓÚϵͳÄÚ´æ´óÓÚ2GBµÄ·þÎñÆ÷£¬½»»»¿Õ¼ä¿ÉÒÔ½éÓÚ2GB—4GBÖ®¼ä¡£     
Èç¹ûÊÇΪÁËÔÚһ̨½öÓÐ256MÄÚ´æµÄÆÕͨPC»úÉÏÊÔÓÃOracle9i£¬ÔÚ·ÖÅäÁË1GB×óÓҵĽ»»» ......

oracle´æ´¢¹ý³ÌÓ÷¨

  ´æ´¢¹ý³ÌÔÚ·þÎñÆ÷¶ËÔçÒѱ༭ִÐйýµÄ´úÂë¡£Óû§Òª×öµÄÖ»Êǵ÷ÓúͽÓÊÕ´æ´¢¹ý·µ»ØµÄ½á¹û¡£ËùÒÔµ÷Óô洢¹ý³Ì±ÈÆÕͨµÄÓòéѯÓï¾ä·µ»ØÖµÒª¿ìµÃ¶à,´æ´¢¹ý³ÌµÄÖ´ÐÐËٶȸü¿ì,´æ ´¢¹ý³ÌÊDZ£´æÆðÀ´µÄ¿ÉÒÔ½ÓÊܺͷµ»ØÓû§ÌṩµÄ²ÎÊýµÄ Transact-SQL Óï¾äµÄ¼¯ºÏ¡£¿ÉÒÔ´´½¨Ò»¸ö¹ý³Ì¹©ÓÀ¾ÃʹÓ㬻òÔÚÒ»¸ö»á»°ÖÐÁÙʱʹÓ㨾ֲ¿ÁÙʱ¹ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ