Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

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 DBAְλ


How to land your dream Oracle DBA job
By Don Burleson, Contributor
14 Jan 2010
If you look at the Help Wanted ads, some Oracle DBA jobs look very appealing, with salaries that rival those of engineers and other professionals. Some have starting salaries as high as $85,000, with senior Orac ......

oracleÁ½ÖÖÓû§ÈÏÖ¤·½Ê½


ORACLEÊý¾Ý¿âͨ¹ýsqlnet.oraÎļþÖеIJÎÊýsqlnet.authentication_services,²ÎÊýÎļþÖеÄremote_login_passwordfileºÍ¿ÚÁîÎļþpwdsid.oraÈýÕßЭͬ×÷ÓÃʵÏÖÉí·ÝÈÏÖ¤.
Sqlnet.authentication_services=(NTS)|(NONE)
NTS:²Ù×÷ϵͳÈÏÖ¤·½Ê½,²»Ê¹ÓÿÚÁîÎļþ;
NONE:¿ÚÁîÎļþÈÏÖ¤·½Ê½
Remote_login_passwordfile=(NONE)|(EXCLU ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ