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

sqlÓÅ»¯É¨Ã¤

1.oracleɨÃèµÄ˳ÐòΪ´Óϵ½ÉÏ£¬´ÓÓÒµ½×ó
           ËùÒÔÎÒÃÇÒª¾¡¿ÉÄܵİÑÊý¾ÝÉٵıí·ÅÔÚºóÃæ£¬½»²æ±í·ÅÔÚºóÃæ£¬×îÄܹýÂ˵ÄÌõ¼þ·ÅÔÚºóÃæ
2.²»ÒªÔÚË÷ÒýÉÏʹÓüÆËãºÍnot²Ù×÷·û
           Ë÷ÒýÒ»µ©²ÎÓë¼ÆËã»òʹÓÃÁËnot²Ù×÷·û£¬oracle½«»áºöÂÔÕâ¸öË÷Òý
3.¾¡Á¿Ê¹ÓÃinºÍand£¬¾¡Á¿±ÜÃâʹÓÃor£¬or»á²úÉú´óÁ¿µÄ¹ýÂË £¬Ö±½Óµ¼ÖÂÂß¼­¶Á´óÁ¿Ôö¼Ó
4.±ØÒªÊ±Ê¹ÓÃautotrace(sqlplusÖÐÓÐЧ£¬PL/SQLÖÐÎÞЧ)
           ÃüÁset autotrace on;
           ¹æÔò£º¾¡Á¿¼õÉÙÂß¼­¶Á£¬Ó¦¸Ã±ÜÃâÎïÀí¶Á£¬Ìá¸ß»º³åÇøÃüÖÐÂÊ £¬×îºÃ±£³ÖÔÚ95%ÒÔÉÏ¡£
           recursive calls      µÝ¹éµ÷ÓÃ
           db block gets       Êý¾Ý¿é¶ÁÈ¡
           consistent gets    Ò»ÖÂÐÔ¶ÁÈ¡
           physical reads      ÎïÀí¶ÁÈ¡
           redo size              ²úÉúµÄÖØ×öÈÕÖ¾´óС
Âß¼­¶Á=consistent gets + db block gets
»º³åÇøÃüÖÐÂÊ=(Âß¼­¶Á-ÎïÀí¶Á)/Âß¼­¶Á
Ò»¸ö½ø³Ì¿ÉÄܶÔÒÔºóÄܹ»Êý¾Ý¿éÖжà¸ösession¡£
sqlÓÅ»¯×îÖØ³£ÓõÄÊǰ취ÊÇ£ºÉóÊÓsqlÓï¾ä
Ò²¿ÉÒÔÖ´ÐÐÕâÌõsqlÀ´²éÕҷdz£ºÄ·Ñ¿Õ¼äµÄsql£º
select sql_text ,sharable_mem from v$sql where sharable_mem > '100000' order by sharable_mem ;


Ïà¹ØÎĵµ£º

SQL SERVER2000´ò²¹¶¡ÎÊÌâ»ã×Ü

SQL SERVER2000´ò²¹¶¡ÎÊÌâ»ã×Ü ¡¾http://hi.baidu.com/yanhai/blog/item/cf67c2ce07a9f50992457e9d.html¡¿
SQL ServerµÄ²¹¶¡°æ±¾¼ì²é²»ÈçWindows ²¹¶¡°æ±¾¼ì²éÖ±½Ó£¬Ò»¸öϵͳ¹ÜÀíÔ±£¬Èç¹û²»Á˽âSQL Server°æ±¾¶ÔÓ¦µÄ²¹¶¡ºÅ£¬¿ÉÄÜÒ²»áÓöµ½Ò»µãÂé·³£¬Òò´ËÔÚÕâ˵Ã÷һϣ¬Í¨¹ýÕâÑùµÄ°ì·¨Åбð»úÆ÷Êǰ²È«µÄ°ì·¨£¬²»»á¶Ôϵͳ²úÉúÈ ......

¼à¿ØSQL Server2005Êý¾Ý¿âµÄÔËÐÐ×´¿ö

ÄÜ¼à¿ØSQL ServerÊý¾Ý¿âÔËÐеÄÇé¿ö£¬¶Ô·þÎñÆ÷À´Ëµ¶¼ÊÇÒ»¼þ·Ç³£ÖØÒªµÄÊ£¬ÏÂÃæ¿ªÊ¼½éÉÜ¡£
Microsoft SQL Server 2005 ÌṩÁËһЩ¹¤¾ßÀ´¼à¿ØÊý¾Ý¿â¡£·½·¨Ö®Ò»ÊǶ¯Ì¬¹ÜÀíÊÓͼ¡£¶¯Ì¬¹ÜÀíÊÓͼ (DMV) ºÍ¶¯Ì¬¹ÜÀíº¯Êý (DMF) ·µ»ØµÄ·þÎñÆ÷״̬ÐÅÏ¢¿ÉÓÃÓÚ¼à¿Ø·þÎñÆ÷ʵÀýµÄÔËÐÐ×´¿ö¡¢Õï¶ÏÎÊÌâºÍÓÅ»¯ÐÔÄÜ¡£
³£¹æ·þÎñÆ÷¶¯Ì¬¹ÜÀí¶ÔÏó°ü ......

ORACLE sqlÓï¾ä±Ê¼Ç

windowsÉÏ´æÔÚ32bitµÄÏÞÖÆ£¬ÈçAIX¡¢HP UNIX µÈÓÐÃ÷È·µÄ64BIT OS and ORACLEµÄ°æ±¾£¬32bit oracle¿ÉÒÔ×°ÔÚ64bit os ÉÏ£¬64 bit oracle²»ÄÜ×°ÔÚ32 bit OSÉÏ
oracleÊÇ64bit or 32 bit,32bit ͨ³£ SGAÓÐ 1.7G µÄÏÞÖÆ(ijЩOSµÄ´¦Àí»òÕßWINDOWSÉÏÓÐÌØ¶¨É趨¿ÉÒÔÖ§³Öµ½2GÒÔÉÏÉõÖÁ´ïµ½3.7G
ÈçºÎ²é³öǰ̨ÕýÔÚ·¢³öµÄsqlÓï¾ä:
sele ......

SQL Server BI Step by Step SSIS 7 (End)

ºÍÆäËü³ÌÐòÒ»Ñù£¬SSIS°üͬÑùÐèÒª½¡×³£¬Îȶ¨µÄÔËÐУ¬ÕâÑùµÄ³ÌÐò²ÅÓпɿ¿ÐԺͿÉÉìËõÐÔ¡£SSISÌṩÁËÈçÏ·½ÃæµÄÖ§³Ö:
        1.ÊÂÎñ: ¿ÉÒÔ¶ÔÒ»¸ö³ÌÐò°üÉèÖóÉÒ»¸ö»òÕß¶à¸öÊÂÎñ£¬ÉõÖÁ¿ÉÒÔ¶ÔÁ½¸ö³ÌÐò°üÉèÖóÉÒ»¸öÊÂÎñ¡£ÎªÁ˱£Ö¤Êý¾ÝµÄÒ»ÖÂÐÔ£¬Ä㻹¿ÉÒÔDTCÊÂÎñ»òÕßSQL ServerÒýÇæ¼¶µÄÊÂÎñ¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ