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

oracleµÄËæ»úÅÅÐò

ÏîÄ¿ÀïÒ»¸ö¹¦ÄÜÒªÓõ½Ëæ»úÅÅÐò£¬µ«ÊǺóÀ´ÓÖÒòΪÊý¾ÝÁ¿´óµÄÔ­Òò£¬Òª·Öҳȥ²éѯÊý¾Ý£¬½á¹ûµ¼Ö²éѯ³öÀ´µÄÊý¾Ý³öÏÖÖØ¸´¡£
Ô­sqlÈçÏÂselect * from ( select row_.*, rownum rownum_ from
(select * from tble order by dbms_random.random) row_ where rownum <= 12) where rownum_ > 10;
 
ºóÀ´½â¾ö°ì·¨£¬²åÈëÒ»ÕÅÁÙʱ±í¼ÇÂ¼Ëæ»ú³öÀ´µÄÊý¾Ý£¬È»ºó°´ÁÙʱ±í·Öҳȥ²é£¬Ïë²»µ½ºÃ°ì·¨£¬Ö»Äܵ±ÈÎÎñÀ´Íê³ÉÁË¡£
¹ýÂ˵ôorder by µÄÅÅÐòÕýÔò
sql = sql.replaceAll("order by [^\\)]+", "");



Ïà¹ØÎĵµ£º

oracle ÎïÀí½á¹¹¹¹Êö

Êý¾ÝÎļþ
¡¡¡¡Ã¿Ò»¸öOracleÊý¾Ý¿â¶¼ÓÐÒ»¸ö»ò¶à¸öÎïÀíµÄÊý¾ÝÎļþ,Êý¾Ý¿âÐÅÏ¢(½á¹¹,Êý¾Ý)¶¼±£´æÔÚÕâЩÊý¾ÝÎļþÖÐ,²¢ÇÒÕâЩÎļþÒ²Ö»Oracle²ÅÄܹ»½âÊÍÓë¹ÜÀíÕâЩ´æ´¢.OracleÊý¾ÝÎļþ¾ßÓÐÒÔÏÂÒ»Ð©ÌØÐÔ:
¡¡¡¡1.Ò»¸öÊý¾ÝÎļþ½ö½ö¹ØÁªÒ»¸öÊý¾Ý¿â,Êý¾ÝÎļþÓëÊý¾Ý¿âÖ®¼ä¶ÔÓ¦¹ØÏµÊÇÒ»¶ÔÒ»¹ØÏµ,µ±È»·´¹ýÊý¾Ý¿âÓëÊý¾ÝÎļþÊÇÒ»¶Ô¶à¹ØÏµ. ......

¡¾×ª¡¿ OracleÐÔÄÜÓÅ»¯¼¼ÇÉ

OracleÐÔÄÜÓÅ»¯¼¼ÇÉ
http://tech.it168.com/db/o/2006-06-15/200606151715426.shtml
1.Ñ¡ÓÃÊʺϵÄORACLEÓÅ»¯Æ÷
    ORACLEµÄÓÅ»¯Æ÷¹²ÓÐ3ÖÖ:
    1.RULE(»ùÓÚ¹æÔò) 2.COST(»ùÓڳɱ¾) 3.CHOOSE(Ñ¡ÔñÐÔ)
    ÉèÖÃȱʡµÄÓÅ»¯Æ÷,¿ÉÒÔͨ¹ý¶Ôinit.oraÎļþÖÐOPTIMIZER_MODE²ÎÊ ......

Oracle 10G ÖеĻØÊÕÕ¾

»ØÊÕÕ¾,´ÓÔ­ÀíÉÏÀ´Ëµ¾ÍÊÇÒ»¸öÊý¾Ý×Öµä±í,·ÅÖÃÓû§DropµôµÄÊý¾Ý¿â¶ÔÏóÐÅÏ¢.Óû§½øÐÐDrop²Ù×÷µÄ¶ÔÏó²¢Ã»Óб»Êý¾Ý¿âɾ³ý,ÈÔÈ»»áÕ¼Óÿռä.³ý·ÇÊÇÓÉÓÚÓû§ÊÖ¹¤½øÐÐPurge»òÕßÒòΪ´æ´¢¿Õ¼ä²»¹»¶ø±»Êý¾Ý¿âÇåµô.Êý¾Ý¿âÓÐÁËÕâÑùµÄ¹¦ÄÜ,Äܹ»¼õÉٺܶ಻±ØÒªµÄÂé·³.¾­³£¿´µ½¿ª·¢ÈËÔ±Îó°Ñ±íɾ³ý,¼±¼±Ã¦Ã¦ÕÒDBAÀ´Ïë°ì·¨µÄÇé¿ö,ÏàÐÅ,Ëæ×Å10G ......

OracleÓÅ»¯Æ÷µÄÓÅ»¯·½Ê½ºÍÓÅ»¯Ä£Ê½

OracleÔÚÖ´ÐÐÒ»¸öSQL֮ǰ,Ê×ÏÈÒª·ÖÎöÒ»ÏÂÓï¾äµÄÖ´Ðмƻ®,È»ºóÔÙ°´Ö´Ðмƻ®È¥Ö´ÐС£·ÖÎöÓï¾äµÄÖ´Ðмƻ®µÄ¹¤×÷ÊÇÓÉÓÅ»¯Æ÷(Optimizer)À´Íê³ÉµÄ¡£²»Í¬µÄÇé¿ö,Ò»ÌõSQL¿ÉÄÜÓжàÖÖÖ´Ðмƻ®,µ«ÔÚijһʱµã,Ò»¶¨Ö»ÓÐÒ»ÖÖÖ´Ðмƻ®ÊÇ×îÓŵÄ,»¨·Ñʱ¼äÊÇ×îÉٵġ£ÏàÐÅÄãÒ»¶¨»áÓÃPl/sql Developer¡¢ToadµÈ¹¤¾ßÈ¥¿´Ò»¸öÓï¾äµÄÖ´Ðмƻ®,²»¹ýÄã ......

OracleÕï¶Ï°¸Àý Spfile°¸ÀýÒ»Ôò

Çé¿ö˵Ã÷:
ϵͳ£ºSUN Solaris8
Êý¾Ý¿â°æ±¾:9203
ÎÊÌâÃèÊö£º¹¤³ÌÈËÔ±±¨¸æ£¬Êý¾Ý¿âÔÚÖØÐÂÆô¶¯Ê±ÎÞ·¨Õý³£Æô¶¯.¼ì²é·¢ÏÖUNDO±í¿Õ¼ä¶ªÊ§.
ÎÊÌâÕï¶Ï¼°½â¾ö¹ý³ÌÈçÏÂ:
 1. µÇ½ϵͳ¼ì²éalert.logÎļþ
¼ì²éalert.logÎļþÊÇͨ³£ÊÇÎÒÃÇÕï¶ÏÊý¾Ý¿âÎÊÌâµÄµÚÒ»²½
SunOS 5.8
login: root
Password:
Last login: Thu Apr 1 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ