Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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°²×°³öÏÖora 12154

ǰÁ½Ì죬ÔÚ¿Í»§µÄÐéÄâ»úÉϰ²×°oracleÈí¼þÓÃÓÚ²¿Êð×Ô¼ºµÄÓ¦ÓᣲÅ×°ºÃ²»¾Ã£¬ÓÉÓÚÐèÒªÅäÖÃÍøÂ簲ȫ£¬°ÑÕû¸öÐéÄâ»ú¶¼²ùµô£¬¿Ë¡Á˸öÅäÖúÃÍøÂ簲ȫµÄÐéÄâ»ú¸øÎÒÃÇʹÓã¬Ö»µÃ֨װoracle 10g¡£
µ±µÚ¶þ´ÎÔÚÐéÄâ»úÉϰ²×°oracleʱ£¬Êý¾Ý¿âÃûºÍϵͳÕ˺ŵÄÃÜÂë¶¼×öÁ˸͝£¬½á¹ûÖ±½Óµ¼ÖÂÔÚ´´½¨oracleʵÀýʱµ¯³öora-12154´íÎó¡£Ñ¡Ôñ¡¾º ......

oracle dg µÄ»ù±¾ÃüÁî

1£¬²é¿´µ±Ç°µÄ±£»¤Ä£Ê½
 select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;
2£¬²é¿´ÈÕÖ¾µÄ´«ËÍ·½Ê½£»
 select dest_name,archiver from v$archive_dest;
3£¬Í£Ö¹standbyµÄ×Ô¶¯»Ö¸´×´Ì¬
 alter database recover manager standby database finish;
4£¬Ìí¼Óstandby logfile
&nb ......

ÈçºÎÊÖ¹¤´´½¨OracleÊý¾Ý¿â

ÈçºÎÊÖ¹¤´´½¨OracleÊý¾Ý¿â
http://www.cnhacker.com/Security/System/200808/t20080818_6325.html
½ñÌ죬ÎÒÔÚ²âÊÔ»úÆ÷ÉÏÀ´Á˸öÎó²Ù×÷rm * backup/*,°ÑÕýÔÚÔËÐеÄÊý¾Ý¿âÖеÄÊý¾ÝÎļþÈ«²¿É¾³ýÁË£¬ÕæÊÇÓôÃÆ!»¹ºÃÕâ¸öÊǸøÎÒÃÇÐÂÈËÃDzâÊÔÍæµÄ£¬Òª²»È»¾ÍËÀ¶¨ÁË!ÔÚ´ËÒ²×öÒ»¸öÌáÐÑ£¬ÉíΪDBA£¬ÒªÓÀÔ¶¼ÇסʲôÉ÷ÓûòÕß½ûֹʹÓÃrmÃüÁ ......

Oracleµ÷ÕûÓëSQL Óï¾äµÄµ÷ÓŵĹØÏµ

Oracleµ÷ÕûÓëSQL Óï¾äµÄµ÷ÓŵĹØÏµ
ÔÚOracleµ÷ÕûÖÐÎÒÃÇ»¹»áÉæ¼°µ½SQL Óï¾äµÄµ÷ÓÅ£¬ÎÒÃǽÓÏÂÀ´¾ÍÀ´¿´ÒÔÏ嵀 SQL Óï¾äµÄµ÷ÓÅ¡£ÎÒÃǶ¼ÖªµÀ Oracle ÖÐµÄ SQL µ÷ÓÅÊÇÒ»¸öÏ൱¸´ÔÓµÄÖ÷Ì⣬ÉõÖÁÊÇÐèÒªÕû±¾ÊéÀ´½éÉÜ Oracle SQL µ÷ÓŵÄϸ΢²î±ð¡£
²»¹ýÓÐһЩ»ù±¾µÄ¹æÔòÊÇÿ¸ö Oracle DBA ¶¼ÐèÒª¸ú´ÓµÄ£¬ÕâЩ¹æÔò¿ÉÒÔ¸ÄÉÆËûÃÇϵͳµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ