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Óï¾ä¡£
Ïà¹ØÎĵµ£º
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
Ò»¸öʵÀý¿ÉÒÔÓжà¸öºǫ́½ø³Ì,µ«ÊÇ£¬²¢²»ÊÇÿһ¸öºǫ́½ø³Ì¶¼»á³ö³ö£¬Í¨¹ýÊÓͼv$bgprocess¿ÉÒԲ鿴ºǫ́½ø³ÌÐÅÏ¢¡£
Ò»°ãÎÒÃÇÊÇͨ¹ýÒÔÏÂsql²é¿´ºǫ́±ØÐëµÄºǫ́½ø³Ì.
1.²é¿´ºǫ́½ø³Ì
select paddr,name,description
from v$bgprocess
order by paddr desc
£»
2.Õâ¸öÊÓͼÖÐpaddr<>'00'µÄÐж¼ÊÇϵͳÉÏÅäÖúÍÔËÐеĽø³ ......
Author: rainnyzhong
Date:2010-1-15
1£® Ö¢×´ÃèÊö£º
FALB12´ÓEXCEL IMPORT DATAµ½DB£¬Ô¤¼ÆÊÂÎñ»áÔËÐÐ1¸ö¶àСʱ£¬ÔÚ¿ªÊ¼²Ù×÷ºó40·ÖÖÓ×óÓÒ£¬ORACLE¹ÒËÀ£¬ÈκÎÓû§¶¼²»¿ÉÒÔÔٵǽÁË¡£
2£® ·ÖÎö
£¨1£© ÏÂÃæÊǹÒËÀʱOSµÄ×ÊÔ´×´¿ö£º
09:37:54 up 73 ......
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 ......
exname stuname source
Íõº£ Êýѧ 86
ٮٮ Êýѧ 95
·¼¶ù Êýѧ 93
¹ø¯ Êýѧ 95
ÖÜѧ¾ü Êýѧ 93
Íõº£ ÓïÎÄ 86
ٮٮ ÓïÎÄ 95
·¼¶ù ÓïÎÄ 93
°´Ñ§¿ÆºÍ·ÖÊýÅÅÃû¡£ÅÅÃûÓÐ2ÖÖ·½Ê½,Ò»ÖÖÊÇÅÅÃûÖظ´Ôò²»ÏÔʾÏÂÒ»Ãû Ò»ÖÖÖظ´Ò²¼ÌÐøÏÔʾ¡£
ÅÅÃûÒ»£º
select t.exmename,
t.stuname ,
rank() over(partiti ......