ÈçºÎ²é¿´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¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿ ʲôÒâ˼£¿ ¿ÉÒ﵀ 10¸ö¶¼Ã»ÎÊÌâ ¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã ......
type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jas ......
ÎÒÓõÄÊÇNTϵͳ£¬µ±ÎÒÓüÇʱ¾²é¿´¿ØÖÆÎʼþʱ£¬×ÜÊÇÒ»´ó¶ÑÂÒÂ룬ÎÒ¸ÃÔõÑù²éѯ²¢¸Ä±ä¿ØÖÆÎļþÀïµÄÄÚÈÝÄØ£¿ 2½øÖÆ ÓüÇʱ¾´ò¿ªµ±È»ÊÇÂÒÂë¿© ÄÇÓÃʲô´ò¿ªÄØ£¿ÓÖÔõÑù´ò¿ªÄØ £¿ ¿ØÖÆÎļþÊǶþ½øÖÆÎļþ£¡ Ò»°ã ......
Developer SuiteÁ¬½ÓÊý¾Ý¿âµÄÎÊÌ⣬ÀͼݸßÊÖÖ¸µã£¡ µçÄÔÀïÃæÍ¬Ê±×°ÁËOraHome92ºÍDevSuiteHome2£¬Ç°ÕßµÄsql*plusÄÜ·ÃÎÊ£¬ºóÕßµÄÔò²»ÐС£ÊäÈëscott/tigerµÇ½ºóÕßʱ£¬ÎÒÊäÈëÁË"Ö÷»ú×Ö·û´®"ºÅÒԺ󣬱¨´í£º&n ......