ORACLE È¥³ýÖØ¸´¼Ç¼
delete from tbl_talbe
where (col1,col2,col3) in
(select col1,col2,col3
from tbl_table
group by col1,col2,col3
having count(*)>1)
and rowid not in
(
select max(rowid)
from tbl_table
group by col1,col2,col3
having count(*) >1
)
Ïà¹ØÎĵµ£º
֮ǰÔÚÏîÄ¿ÖÐÓõ½µÄ·ÖÒ³¶¼ÊǼٷÖÒ³£¬Ò²¾ÍÊÇÏÈ´ÓÊý¾Ý¿âÖаÑËùÓеÄÊý¾Ý¶¼²éѯ³öÀ´È»ºóÔÚ°ó¶¨Ê±½øÐзÖÒ³¡£ÕâÊÇÒ»ÖÖ¼Ù·ÖÒ³£¬Ð§Âʽϵͣ¬Ç°¼¸ÌìÌýÆäËûÏîÄ¿×é˵ËûÃÇҪʹÓÃÊý¾Ý¿âµÄ´æ´¢¹ý³ÌÀ´ÊµÏÖ·ÖÒ³£¬¸Ð¾õºÜÒÉ»ó£¬ÄѵÀʹÓÃÊý¾Ý¿â»¹¿ÉÒÔʵÏÖ·ÖÒ³¹¦ÄÜ£¿ÏÐÀ´ÎÞÊ£¬¾Í´ÓÍøÉÏËÑÁËËÑ×ÊÁÏ£¬¹ûÈ»£¬ÔÚoracl ......
Oracleѧϰ:·ÖÇø±íºÍË÷Òý
http://tech.it168.com/a2009/0609/585/000000585998.shtml
ʲôʱºòʹÓ÷ÖÇø£º
¡¡¡¡1¡¢ ´óÊý¾ÝÁ¿µÄ±í£¬±ÈÈç´óÓÚ2GB¡£Ò»·½Ãæ2GBÎļþ¶ÔÓÚ32λosÊÇÒ»¸öÉÏÏÞ£¬ÁíÍⱸ·Ýʱ¼ä³¤¡£
¡¡¡¡2¡¢ °üÀ¨ÀúÊ·Êý¾ÝµÄ±í£¬±ÈÈç×îеÄÊý¾Ý·ÅÈëµ½×îеķÖÇøÖС£µäÐ͵ÄÀý×Ó£ºÀúÊ·±í£¬Ö»Óе±Ç°Ô·ݵÄÊý¾Ý¿ÉÒÔ±»Ð޸ģ¬ ......
¡¶Oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX/UNIXÉϵÄʵսÏê½â¡·¼¯ÖÐÌÖÂ۵ļÌÐø¡£ ×öÁËÒ»ÖܹØÓÚOracleÔÚ32λwindowsÉÏʵʩµÄÅàѵ£¬Ç¡ºÃÆÚ¼äÓм¸Î»OracleÓû§ÓʼþѯÎʹØÓÚWindowsϵͳµ÷ÕûÎÊÌâ¡£ÕýºÃ°É£¬°Ñ×¼±¸µÄһЩÄÚÈݹ²Ïí³öÀ´¡£ Èç¹ûOracleʹÓôóÓÚ1.7µÄÄڴ棬ÐèÒªÒ»Ð©ÌØÐ´µÄÉèÖᣲμûÏÂÃæÀ´×ÔmetalinkµÄÂ۵㣺 Large page support ......
¼×¹ÇÎÄÒѾÍê³ÉÁ˶ÔSUN¹«Ë¾µÄÊÕ¹º£¬ÓÚ1ÔÂ27ÈÕ·¢²¼Á˶ÔSun¸÷ÏîÒµÎñµÄÕûºÏ¹æ»®¡£×ÜÌåÉÏ˵£¬OracleÒª³ÉΪÈíÓ²¼þÒ»Ì廯µÄÕûÌå½â¾ö·½°¸µÄ³§ÉÌ¡£ ÒÔÏÂ¾ÍÆä¶Ô±¸ÊܹØ×¢µÄJava·½ÃæµÄ²ßÂÔ×ö¸ö½éÉÜ¡£
Java SE:
1£©ÍƳöJDK SE 7£¬ Ëü½«°üÀ¨¶à¸öÐµĹ¦ÄÜ£¬ÈçÌá¸ß¿ª·¢ÈËÔ±µÄЧÂÊ£¬Ìṩ¸ßÐÔÄÜ£¬¶Ô¶àºËоƬµÄÖ§³ÖµÈ¡£
2£©SunµÄHotSpot ......
´Ó8iµ½10g£¬Oracle²»¶Ï½ø»¯×Ô¼ºµÄSQL TuningÖÇÄÜ£¬Ò»Ð©Ãؼ®¼¶µÄÓÅ»¯¿Ú¾÷ÒѾʧЧ¡£
µ«ÎÒϲ»¶Ê§Ð§£¬²»Óüǿھ÷£¬²Ù¸öToad for Oracle Xpert
£¬°´ÕÕ´ó·½ÏòÊæÊæ·þ·þµÄ
µ÷ÓŲÅÊǰ®×öµÄÊÂÇé¡£
1.Excution Plan
Excution
PlanÊÇ×î»ù±¾µÄµ÷ÓŸÅÄ²»¹ÜÄãµÄµ÷ÓÅ´µµÃÈçºÎÌ ......