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 ²¹¶¡µÄ°æ±¾ [http://blog.sina.com.cn/s/blog_4a5bf0b7010008bz.html]
ÈçºÎ²é¿´SQL Server ²¹¶¡µÄ°æ±¾£¿Õâ¸öÌâÄ¿ÌýÆðÀ´Ê®·ÖÞÖ¿Ú£¬Ó¢ÎÄÓ¦¸ÃÕâÑùд“How to find the service pack version installed on SQL Server using”£¬Õâ¸öÎÊÌâÎÒÒ»Ö±ÔÚÕÒ£¬SQL ServerһֱûÓÐÏñÆ ......
SQL SERVER2000´ò²¹¶¡ÎÊÌâ»ã×Ü ¡¾http://hi.baidu.com/yanhai/blog/item/cf67c2ce07a9f50992457e9d.html¡¿
SQL ServerµÄ²¹¶¡°æ±¾¼ì²é²»ÈçWindows ²¹¶¡°æ±¾¼ì²éÖ±½Ó£¬Ò»¸öϵͳ¹ÜÀíÔ±£¬Èç¹û²»Á˽âSQL Server°æ±¾¶ÔÓ¦µÄ²¹¶¡ºÅ£¬¿ÉÄÜÒ²»áÓöµ½Ò»µãÂé·³£¬Òò´ËÔÚÕâ˵Ã÷һϣ¬Í¨¹ýÕâÑùµÄ°ì·¨Åбð»úÆ÷Êǰ²È«µÄ°ì·¨£¬²»»á¶Ôϵͳ²úÉúÈ ......
1¡£Sysdate µ±Ç°ÈÕÆÚºÍʱ¼ä
SQL> Select sysdate from dual;
SYSDATE
----------
21-6ÔÂ -05
2¡£Last_day ±¾ÔÂ×îºóÒ»Ìì
SQL> Select last_day(sysdate) from dual;
LAST_DAY(S
----------
30-6ÔÂ -05
3¡£Add_months(d,n) µ±Ç°ÈÕÆÚdºóÍÆn¸öÔÂ
ÓÃÓÚ´ÓÒ»¸öÈÕÆÚÖµÔö¼Ó»ò¼õÉÙһЩÔ·Ý
date_value:=add_mont ......
×Ô¶¯ÌáʾµÄ¿ì½Ý¼ü£ºF6
¿ÉÒÔ¸ü¸Ä£ºTools->Preferences->User interface->Key Configuration ,ÔÚItemÁÐÀïÕÒµ½“Tools/Code Assistant”,ÔÚºóÃæ¶ÔÓ¦µÄ¿ì½Ý¸Ä³É×Ô¼ºÏ²»¶µÄ¡£
ĬÈÏÊDz»ÄÜ×Ô¶¯Ìá½»µÄ£¬°´ F10 ¼ü¿ÉÒÔÔÚ×ö¸ü¸ÄºóÌá½»¡£ ......
1¡¢SQL ServerÈÕÆÚÊý¾Ý¿âÄÚ²¿±íʾ¼°²éѯÊä³ö£º
SQL ServerÄÚ²¿¶ÔDateTimeÀàÐ͵ıíʾÊÇÓÃ8¸ö×Ö½ÚÀ´±íʾ£¬ÆäÖÐǰ4¸ö×Ö½Ú±íʾµÄÊýֵΪ×Ô1900Äê1ÔÂ1ÈÕÁãʱÒÔÀ´µÄÌìÊý£¬ºóËĸö×Ö½ÚÊÇÌìÊýÖ®ÍâµÄÓжàÉÙ¸ö1/300Ã룬ÕâҲ˵Ã÷SQL ServerÄÚ²¿±íʾʱ¼äµÄ¾«¶ÈΪ1/300Ã룬Լ3.3ºÁÃë¡£
³£¹æµÄSQL²éѯ£¬Õý³£ÈÕÆÚÊä³ö¸ñʽΪ:yyyy-MM-dd hh: ......