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

ORACLE EXPLAIN PLANµÄ×ܽá

ÔÚORACLEÊý¾Ý¿âÖÐ,ÐèÒª¶ÔSQLÓï¾ä½øÐÐÓÅ»¯µÄ»°ÐèÒªÖªµÀÆäÖ´Ðмƻ®,´Ó¶øÕë¶ÔÐԵĽøÐе÷Õû.ORACLEµÄÖ´Ðмƻ®µÄ»ñµÃÓм¸ÖÖ·½·¨,ÏÂÃæ¾ÍÀ´×ܽáÏÂ
1¡¢EXPLAINµÄʹÓÃ
    Oracle RDBMSÖ´ÐÐÿһÌõSQLÓï¾ä£¬¶¼±ØÐë¾­¹ýOracleÓÅ»¯Æ÷µÄÆÀ¹À¡£ËùÒÔ£¬Á˽âÓÅ»¯Æ÷ÊÇÈçºÎÑ¡Ôñ(ËÑË÷)·¾¶ÒÔ¼°Ë÷ÒýÊÇÈçºÎ±»Ê¹Óõģ¬¶ÔÓÅ»¯SQLÓï¾äÓкܴóµÄ°ïÖú¡£Explain¿ÉÒÔÓÃÀ´Ñ¸ËÙ·½±ãµØ²é³ö¶ÔÓÚ¸ø¶¨SQLÓï¾äÖеIJéѯÊý¾ÝÊÇÈçºÎµÃµ½µÄ¼´ËÑË÷·¾¶(ÎÒÃÇͨ³£³ÆΪAccess Path)¡£´Ó¶øʹÎÒÃÇÑ¡Ôñ×îÓŵIJéѯ·½Ê½´ïµ½×î´óµÄÓÅ»¯Ð§¹û¡£
1.1 ¡¢°² ×°                                                                                                                       
 ÒªÊ¹ÓÃEXPLAINÊ×ÏÈÒªÖ´ÐÐÏàÓ¦µÄ½Å±¾£¬´´½¨³öExplain_plan±í¡£
¾ßÌå½Å±¾Ö´ÐÐÈçÏ£º
   $ORACLE_HOME/rdbms/admin/utlxplan.sql (UNIX)  ¸Ã½Å±¾ºó»áÉú³ÉÒ»¸ö±íÕâ¸ö³ÌÐò»á´´½¨Ò»¸öÃûΪplan_tableµÄ±í¡£
1.2 ¡¢Ê¹ÓÃ
³£¹æʹÓÃÓï·¨£º
explain PLAN [ SET STATEMENT_ID [=] < string literal > ] [ INTO < table_name > ]
FOR < sql_statement >
ÆäÖУº
STATEMENT_ID£ºÊÇÒ»¸öΨһµÄ×Ö·û´®£¬°Ñµ±Ç°Ö´Ðмƻ®Óë´æ´¢ÔÚͬһPLANÖеÄÆäËüÖ´Ðмƻ®Çø±ð¿ªÀ´¡£
TABLE_NAME£ºÊÇplan±íÃû£¬Ëü½á¹¹ÈçÇ°Ëùʾ£¬Äã¿ÉÒÔÈÎÒâÉ趨Õâ¸öÃû³Æ¡£
SQL_STATEMENT£ºÊÇÕæÕýµÄSQLÓï¾ä¡£                                       


Ïà¹ØÎĵµ£º

Oracle±í¿Õ¼ä¹ÜÀí

extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î»      --segment    management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......

oracle ºǫ́½ø³Ì

Ò»¸öʵÀý¿ÉÒÔÓжà¸öºǫ́½ø³Ì,µ«ÊÇ£¬²¢²»ÊÇÿһ¸öºǫ́½ø³Ì¶¼»á³ö³ö£¬Í¨¹ýÊÓͼv$bgprocess¿ÉÒԲ鿴ºǫ́½ø³ÌÐÅÏ¢¡£
Ò»°ãÎÒÃÇÊÇͨ¹ýÒÔÏÂsql²é¿´ºǫ́±ØÐëµÄºǫ́½ø³Ì.
1.²é¿´ºǫ́½ø³Ì
select paddr,name,description
from v$bgprocess
order by paddr desc
£»
2.Õâ¸öÊÓͼÖÐpaddr<>'00'µÄÐж¼ÊÇϵͳÉÏÅäÖúÍÔËÐеĽø³ ......

Oracle Hang Analysis

Author: rainnyzhong
Date:2010-1-15
 
1£®  Ö¢×´ÃèÊö£º
FALB12´ÓEXCEL IMPORT DATAµ½DB£¬Ô¤¼ÆÊÂÎñ»áÔËÐÐ1¸ö¶àСʱ£¬ÔÚ¿ªÊ¼²Ù×÷ºó40·ÖÖÓ×óÓÒ£¬ORACLE¹ÒËÀ£¬ÈκÎÓû§¶¼²»¿ÉÒÔÔٵǽÁË¡£
2£®  ·ÖÎö
£¨1£©        ÏÂÃæÊǹÒËÀʱOSµÄ×ÊÔ´×´¿ö£º
09:37:54  up 73 ......

ORACLE listerner.oraÎļþ ²ÎÊýÒâ˼

The following items are available in the network listener configuration file (listener.ora).
    * Listener Address Section
    * SID_LIST_listener_name Static Service Section
    * Control Parameters
The listener.ora file is located in $ORACLE_HOME/n ......

oracle Êý¾Ýͳ¼ÆÖеÄÃû´ÎÅÅÐòºÍ½ØÈ¡

exname stuname source
Íõº£ Êýѧ 86
ٮٮ Êýѧ 95
·¼¶ù Êýѧ 93
¹ø¯ Êýѧ 95
ÖÜѧ¾ü Êýѧ 93
Íõº£ ÓïÎÄ 86
ٮٮ ÓïÎÄ 95
·¼¶ù ÓïÎÄ 93
°´Ñ§¿ÆºÍ·ÖÊýÅÅÃû¡£ÅÅÃûÓÐ2ÖÖ·½Ê½,Ò»ÖÖÊÇÅÅÃûÖظ´Ôò²»ÏÔʾÏÂÒ»Ãû Ò»ÖÖÖظ´Ò²¼ÌÐøÏÔʾ¡£
ÅÅÃûÒ»£º
select t.exmename,
t.stuname ,
rank() over(partiti ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ