Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 server 2005µÄsaÕ˺ÅÃÜÂëÍü¼ÇÁËÔõô°ì

¾ßÌå½â¾ö²½Öè:
µÚÒ»²½:´ò¿ª SQL2005 ÓùÜÀíÔ±µÇ¼ÏÈ,È»ºóÔÚ·þÎñÃû´¦ÓÒ»÷Ñ¡ÊôÐÔ>°²È«ÐÔ>ÓұߵĵǼ·½Ê½Ñ¡Ïî¸ÄΪ Éí·ÝÑéÖ¤ È·¶¨!
µÚ¶þ²½:Ñ¡Ôñ°²È«ÐÔ(Õ¹¿ª)>µÇ¼Ãû>Ë«»÷sa>ÃÜÂë¸Ä³ÉÄãÐèÒªµÄÃÜÂë È·¶¨!
È»ºó¹ØµôSQL2005 »òÕß ¶Ï¿ªÁ¬½Ó
µÚÈý²½:µã¿ªÊ¼>³ÌÐò>Ñ¡ÔñSQL2005>ÅäÖù¤¾ß>´ò¿ª configurat ......

sql²éѯ

1¡¢²éѯÈýÃŹ¦¿Î¶¼ÔÚ80·ÖÒÔÉϵÄͬѧÐÕÃû(Ò»ÌõsqlÓï¾ä)
   name   kecheng    fenshu
   ÕÅÈý   ÓïÎÄ        78
   ÕÅÈý   Êýѧ        81
   ÕÅÈý  ......

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×Ö·û´®²Ù×÷º¯Êý´óÈ«

selectÓï¾äÖÐÖ»ÄÜʹÓÃsqlº¯Êý¶Ô×ֶνøÐвÙ×÷£¨Á´½Ósql server£©£¬
select ×Ö¶Î1 from ±í1 where ×Ö¶Î1.IndexOf("ÔÆ")=1;
ÕâÌõÓï¾ä²»¶ÔµÄÔ­ÒòÊÇindexof£¨£©º¯Êý²»ÊÇsqlº¯Êý£¬¸Ä³Ésql¶ÔÓ¦µÄº¯Êý¾Í¿ÉÒÔÁË¡£
left£¨£©ÊÇsqlº¯Êý¡£
select ×Ö¶Î1 from ±í1 where charindex£¨'ÔÆ',×Ö¶Î1£©=1;
×Ö·û´®º¯Êý¶Ô¶þ½øÖÆÊý¾Ý¡¢×Ö·û´®º ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ