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

ÈçºÎ²é¿´oracle¿ªÏú£¬»òÊÇsqlµÄÖ´ÐÐЧÂÊ

ÈçÌ⣺ÈçºÎ²é¿´oracle¿ªÏú£¬»òÊÇsqlµÄÖ´ÐÐЧÂÊ¡£
¡¾1¡¿Ôõô²é¿´Êý¾Ý¿âµ±Ç°ÔËÐжÔ×ÊÔ´µÄÕ¼ÓÃÇé¿ö£¬¾ßÌåÊÇÄǸöÈÎÎñÔÚÕ¼Óá£
¡¾2¡¿Ôõô²é¿´¾ßÌåsqlÓï¾äµÄÖ´ÐÐЧÂʺͶÔ×ÊÔ´µÄÕ¼Óã¬ÈçºÎµ¥¶À·ÖÎösqlµÄÓÅÂÔ¡£
Ï£Íû´ó¼Ò²ÎÓë½»Á÷£¡
¡¾1¡¿TOPÃüÁî
ÎÒÒ²²»ÊǺÜÇå³þ

ÒýÓÃ
ÈçÌ⣺ÈçºÎ²é¿´oracle¿ªÏú£¬»òÊÇsqlµÄÖ´ÐÐЧÂÊ¡£
¡¾1¡¿Ôõô²é¿´Êý¾Ý¿âµ±Ç°ÔËÐжÔ×ÊÔ´µÄÕ¼ÓÃÇé¿ö£¬¾ßÌåÊÇÄǸöÈÎÎñÔÚÕ¼Óá£
¡¾2¡¿Ôõô²é¿´¾ßÌåsqlÓï¾äµÄÖ´ÐÐЧÂʺͶÔ×ÊÔ´µÄÕ¼Óã¬ÈçºÎµ¥¶À·ÖÎösqlµÄÓÅÂÔ¡£
Ï£Íû´ó¼Ò²ÎÓë½»Á÷£¡


1. ¿´ÏÂÄÚ´æºÍCPUʹÓÃÂʾͿÉÒÔ¡£ Õâ¸ö¿ÉÒÔÖ±½ÓÊäÈëTOPÃüÁî¾Í¿ÉÒÔÁË. ²»Í¬µÄϵͳÃüÁͬ£¬sar Ò²¿ÉÒÔ
2. sqlÓï¾äµÄÖ´ÐÐЧÂÊ,ÓÃEXPLAIN PLAN¾Í¿ÉÒÔÁË£¬´ÓcostÀïÄÜ¿´³öÀ´SQLµÄЧÂÊÔõôÑù£¬ Ëü²»»áÕæÕýµÄÈ¥Ö´ÐÐSQLÓï¾ä¡£ ÓÃÔÚSQLµ÷ÓÅ»¹ÊǺܲ»´íµÄ¡£

SQL code:

SQLPLUS ÀïÖ´ÐÐ EXPLAIN PLAN

SQL>EXPLAIN PLAN FOR ÄãµÄsqlÓï¾ä;
Èç
SQL>EXPLAIN PLAN FOR SELECT * from EMP WHERE EMPNO=7369;
È»ºó
SELECT plan_table_output
from TABLE(DBMS_XPLAN.DISPLAY('PLAN_TABLE'));
²é¿´½á¹û¾ÍÊÇÇ°ÃæSQLÓï¾äµÄÖ´Ðмƻ®¡£


ÔÚPL/SQL£¬ toad ÀïÃæÒ²¿ÉÒÔ..


Oracle ¼ì²éÃüÖÐÂʵÄSQL
http://blog.csdn.net/tianlesoftware/archive/2009/10/15/4674153.aspx


×îÀË·ÑÄÚ´æµÄǰ10¸öÓï¾äÕ¼ËùÓÐÓï¾äµÄ±ÈÀý

ÔÚûÓе÷ÕûµÄÇé¿öÏ£¬´ó¶àÊýϵͳÖÐ10¸ö×ʹÓõ


Ïà¹ØÎÊ´ð£º

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿

¿ÉÒÔµÄ

10¸ö¶¼Ã»ÎÊÌâ

¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

ÓüÇʱ¾²é¿´Oracle¿ØÖÆÎļþ

ÎÒÓõÄÊÇNTϵͳ£¬µ±ÎÒÓüÇʱ¾²é¿´¿ØÖÆÎʼþʱ£¬×ÜÊÇÒ»´ó¶ÑÂÒÂ룬ÎÒ¸ÃÔõÑù²éѯ²¢¸Ä±ä¿ØÖÆÎļþÀïµÄÄÚÈÝÄØ£¿
2½øÖÆ ÓüÇʱ¾´ò¿ªµ±È»ÊÇÂÒÂë¿©

ÄÇÓÃʲô´ò¿ªÄØ£¿ÓÖÔõÑù´ò¿ªÄØ
£¿

¿ØÖÆÎļþÊǶþ½øÖÆÎļþ£¡

Ò»°ã ......

developer suiteÁ´½Óµ½oracle·þÎñÆ÷

Developer SuiteÁ¬½ÓÊý¾Ý¿âµÄÎÊÌ⣬ÀͼݸßÊÖÖ¸µã£¡
µçÄÔÀïÃæÍ¬Ê±×°ÁËOraHome92ºÍDevSuiteHome2£¬Ç°ÕßµÄsql*plusÄÜ·ÃÎÊ£¬ºóÕßµÄÔò²»ÐС£ÊäÈëscott/tigerµÇ½ºóÕßʱ£¬ÎÒÊäÈëÁË"Ö÷»ú×Ö·û´®"ºÅÒԺ󣬱¨´í£º&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ