ÓÐʲôÊéÊǽ²¹ØÓÚOracleµÄЧÂʵÄ
´ó¼ÒÍÆ¼öÒ»ÏÂ
Oracle Database 10g Performance Tuning Tips & Techniques
ÎÒÂòµÄ£¬¸Õ¿ªÊ¼¿´
Database Performance Tuning Guide and Reference
oracle¹«Ë¾×Ô¼ºµÄdocument£¬Ã¿¸ö´ó°æ±¾¶¼ÓÐ×Ô¼ºÒ»Ì×
http://www.oracle.com/pls/db112/portal.portal_db?selected=17&frame=
ÓÐûÓÐÖÐÎĵİ¡
..ÖÐÎÄÒëÃûÊÇ Oracle Database 10g ÐÔÄܵ÷ÕûÓëÓÅ»¯
ÄÚÈÝÊÇÖÐÎĵÄ
......
ÄÖÁ˰ëÌìÊÇoracle¹«Ë¾µÄ......ÎÒ˵¿´×ÅÔõôÕâô·Ñ¾¢ÄØ......¹«Ë¾ÅªÁËÁ©±¾ÖÐÎĵÄ,ÎÒ¿´ÁËÁ©ÔÂû¿´Íê......Ò»±¾ÊÇ < <Oracle Database 10g ÍêÈ«²Î¿¼ÊÖ²á>>,Ò»±¾ÊÇ < <Oracle Database 10g ÐÔÄܵ÷ÕûÓëÓÅ»¯>>.
¿´¸Ç¹úÇ¿µÄ < <ÉîÈë½âÎöOracle>>ËٶȾÍÌØ±ð¿ì.
Â¥Ö÷¿ÉÒÔÈ¥http://www.eygle.com/¿´¿´,Õâ¸öÈËÊÇ´óʦ!
Ïà¹ØÎÊ´ð£º
ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
ÓÐÒ»±íÈçÏ£º
ID ÐÕÃû ¿ÆÄ¿ ³É¼¨
1 ÕÅÈý ÓïÎÄ 80 ......
ÂÒÂë²úÉúÊÇÓÉÓÚ¼¸¸ö×Ö·û¼¯Ö®¼äת»»²»Æ¥ÅäÔì³É£¬·ÖÒÔϼ¸ÖÖÇé¿ö£º£¨×¢£º×Ö·û¼¯Ö®¼äÈç¹û²»´æÔÚ×Ó¼¯¡¢³¬¼¯¶ÔÓ¦¹ØÏµÊ±µÄÇé¿ö²»Ó迼ÂÇ£¬ÒòΪÕâÖÖÇé¿öÏÂ×Ö·û¼¯Ö®¼äת»»±Ø²úÉúÂÒÂ룩
1£©·þÎñÆ÷¶ËÊý¾Ý¿ ......
ÓÐÁ½Õűí
1.µÚÒ»ÕÅ,ÊýÁ¿°ÙÍò¼¶
id number Ö÷¼ü
name varchar(50)
2.µÚ¶þÕÅ,ÊýÁ¿1Íò¼¶
id number Ö÷¼ü
deletename varchar(50)
ÏÖÔÚµÄÎÊÌâÊÇҪдһ¸ö´æ´¢¹ý³Ì,ɾ³ýµÚÒ»ÕűíÖеÄn ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......