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

OracleµÄÓÅ»¯Æ÷ÓÐÁ½ÖÖÓÅ»¯·½Ê½(¶þ)

15. /*+USE_CONCAT*/
¶Ô²éѯÖеÄWHEREºóÃæµÄORÌõ¼þ½øÐÐת»»ÎªUNION  ALLµÄ×éºÏ²éѯ. (ã¶®°¡,ÏÈ´æ×Å)
ÀýÈç:
select /*+use_concat */ * from emp where deptno=10 OR empno=7788;
Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=2 Bytes=174)
   1    0   TABLE ACCESS (FULL) OF 'EMP' (Cost=2 Card=2 Bytes=174)
16. /*+NO_EXPAND*/
¶ÔÓÚWHEREºóÃæµÄOR »òÕßIN-LISTµÄ²éѯÓï¾ä,
NO_EXPAND½«×èÖ¹Æä»ùÓÚÓÅ»¯Æ÷¶ÔÆä½øÐÐÀ©Õ¹.
SELECT /*+NO_EXPAND*/  *  from  EMP  WHERE DEPTNO=10 AND job='MANAGER';
Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1 Bytes=87)
   1    0   TABLE ACCESS (FULL) OF 'EMP' (Cost=2 Card=1 Bytes=87)
17. /*+NOWRITE*/
½ûÖ¹¶Ô²éѯ¿éµÄ²éÑ¯ÖØÐ´²Ù×÷.
18. /*+REWRITE*/
¿ÉÒÔ½«ÊÓͼ×÷Ϊ²ÎÊý.
19. /*+MERGE(TABLE)*/
Äܹ»¶ÔÊÓͼµÄ¸÷¸ö²éѯ½øÐÐÏàÓ¦µÄºÏ²¢.
20. /*+NO_MERGE(TABLE)*/
¶ÔÓÚÓпɺϲ¢µÄÊÓͼ²»Ôٺϲ¢.
21. /*+ORDERED*/
¸ù¾Ý±í³öÏÖÔÚfromÖеÄ˳Ðò,ORDEREDʹORACLEÒÀ´Ë˳Ðò¶ÔÆäÁ¬½Ó.
SELECT  /*+ORDERED*/  D.DNAME, E.ENAME,E.SAL from EMP E,DEPT D WHERE E.DEPTNO=D.DEPTNO;
Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=5 Card=82 Bytes=4510)
   1    0   HASH JOIN (Cost=5 Card=82 Bytes=4510)
   2    1     TABLE ACCESS (FULL) OF 'EMP' (Cost=2 Card=82 Bytes=2706)
   3    1     TABLE ACCESS (FULL) OF 'DEPT' (Cost=2 Card=82 Bytes=1804)
¶Ò»»ÏÂEMPºÍDEPTµÄ˳Ðò,µÃµ½
SELECT  /*+ORDERED*/  D.DNAME, E.ENAME,E.SAL from DEPT D, EMP E WHERE E.DEPTNO=D.DEPTNO;
Execution Plan
--------------------


Ïà¹ØÎĵµ£º

Oracle NULL ¿Õ×Ö·û´®¡£¡£¡£¡£¡£¡£

º¬Òå½âÊÍ£º
ÎÊ£ºÊ²Ã´ÊÇNULL£¿
´ð£ºÔÚÎÒÃDz»ÖªµÀ¾ßÌåÓÐʲôÊý¾ÝµÄʱºò£¬Ò²¼´Î´Öª£¬¿ÉÒÔÓÃNULL£¬ÎÒÃdzÆËüΪ¿Õ£¬ORACLEÖУ¬º¬ÓпÕÖµµÄ±íÁ㤶ÈΪÁã¡£
ORACLEÔÊÐíÈκÎÒ»ÖÖÊý¾ÝÀàÐ͵Ä×Ö¶ÎΪ¿Õ£¬³ýÁËÒÔÏÂÁ½ÖÖÇé¿ö£º
1¡¢Ö÷¼ü×ֶΣ¨primary key£©£¬
2¡¢¶¨ÒåʱÒѾ­¼ÓÁËNOT NULLÏÞÖÆÌõ¼þµÄ×Ö¶Î
˵Ã÷£º
1¡¢µÈ¼ÛÓÚûÓÐÈκ ......

oracle 10g undo±í¿Õ¼äʹÓÃÂʾӸ߲»ÏÂbug

¶ÔÓÚUNDO
±í¿Õ¼ä´óСµÄ¶¨ÒåÐèÒª¿¼ÂÇUNDO_RETNETION
²ÎÊý¡¢²úÉúµÄUNDO BLOCKS/
Ãë¡¢UNDO BLOCK
µÄ´óС¡£undo_retention
£º¶ÔÓÚUNDO
±í¿Õ¼äµÄÊý¾ÝÎļþÊôÐÔΪautoextensible,
Ôòundo_retenion
²ÎÊý±ØÐëÉèÖã¬UNDO
ÐÅÏ¢½«ÖÁÉÙ±£ÁôÖÁundo_retention
²ÎÊýÉ趨µÄÖµÄÚ£¬µ«UNDO
±í¿Õ¼ä½«»á×Ô¶¯À©Õ¹¡£¶ÔÓڹ̶¨UNDO
±í¿Õ¼ä ......

oracle ĬÈÏÁÙʱ±í¿Õ¼ä

¡¡¡¡ ÎÒÃÇ¿ÉÒÔͨ¹ýÏÂÃæµÄÓï¾äÀ´²éѯÊý¾Ý¿âµÄĬÈÏÁÙʱ±í¿Õ¼ä£º
¡¡¡¡
¡¡¡¡SQL> select * from database_properties where property_name = 'DEFAULT_TEMP_TABLESPACE'£»
¡¡¡¡¡¡
¡¡¡¡ ĬÈÏÁÙʱ±í¿Õ¼äµÄÏÞÖÆ£º
¡¡¡¡
¡¡¡¡1. ĬÈÏÁÙʱ±í¿Õ¼ä±ØÐëÊÇTEMPORARYµÄ:
¡¡¡¡
¡¡¡¡SQL> alter database default temporary t ......

SQL SERVERÊý¾Ý¿â¿ìËÙתORACLEʵս

²Ù×÷²½ÖèÈçÏ£¬¹©²Î¿¼¡£
 Êý¾Ý¿âתÐ͹¤×÷Éæ¼°µÄ¹¤×÷ÊÂÏî·ÖÎö£º±í£¬±íÊý¾Ý£¬Ë÷Òý£¬Íâ¼üÔ¼Êø£¬×Ö¶ÎĬÈÏÖµ¡£
´æ´¢¹ý³Ì¡¢º¯Êý¡¢´¥·¢Æ÷¡¢ÊÓͼµÈÓÉÓÚÓï·¨´æÔÚ²îÒ죬ֻÄÜ×ÔÐиÄд´¦Àí¡£
 
(Ò»)ÔÚMS SQL SERVER·þÎñÆ÷¶ËµÄ×¼±¸¹¤×÷¡£
1).´´½¨¹ØÓÚ±í¡¢ÊÓͼ¡¢Ö÷¼ü¡¢Ë÷Òý¡¢×Ö¶Î×ֵ䡢ĬÈÏÖµÔ¼ÊøµÄ¶ÔÏóÊÓͼ¡£ÒÔ·½±ãÏÂÒ»²½ ......

.netµ÷ÓÃoracle³öÏÖÎÞ·¨¼ÓÔØoramts.dll

.netµ÷ÓÃoracle³öÏÖÎÞ·¨¼ÓÔØoramts.dll
     ÔÚµ÷ÓÃoracleʱ³öÏÖÎÞ·¨¼ÓÔØoramts.dll Õâʱ¿ÉÒÔ³¢ÊÔÒÔÏ·½·¨£º
ÏÈÒª¿´ÔÚÁ¬½Ó×Ö·û´®ÖÐ.ÊÇ·ñÌí¼ÓÁËenlist=false;ͨ³£²»Ìí¼ÓÕâ¸öÊôÐÔ..ϵͳ½«²»»áÈ¥×Ô¶¯µ÷ÓÃoramts.dll
ÏêÇéÇë¿´
   ½«msvcrtd.dll¿½µ½ C:windows\system32\
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ