¹ØÓÚOracleÊý¾Ý¿âÁ¬½Ó³¬Ê±ÎÊÌâ
ÎҵijÌÐòÐèÒªÁ¬½ÓÁíһ̨µçÄÔÉϵÄoracle·þÎñÆ÷£¬Èç¹û·þÎñÆ÷¿ªÆô£¬Á¬½Ó²Ù×÷Ò»ÇÐÕý³£¡£
µ«ÊÇÈç¹ûoracle·þÎñÆ÷ûÓпªÆô£¬³ÌÐòÒª½«½ü20²Å·µ»ØÎÞ·¨Á¬½ÓÊý¾Ý·¡£
VC³ÌÐòͨ¹ýADO·½Ê½·ÃÎÊoracleÊý¾Ý¿â
m_pConnection->ConnectionTimeout = 10; //10Ã볬ʱ
hr = m_pConnection->Open((_bstr_t)strConnection, "", "", adConnectUnspecified);
ÉÏÃæµÄ³¬Ê±Ê±¼äÉèÖúÃÏñ²»Æð×÷Óã¬ÎÞÂ۸ijɶàÉÙ£¬³ÌÐò¶¼Òª½«½ü20²Å·µ»Ø³¬Ê±¡£
´ò¸ö¶Ïµã£¬¿´¿´Ö´ÐÐÕâ¶Î³ÌÐòû£¿
¿Ï¶¨Ö´ÐÐÁË£¬¾ÍÔÚopenÕâ¸öº¯Êý×èÈûÁ˺ܾ㬴ó¸Å15Ãë
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
ÓÐÒ»±íÈçÏ£º
ID ÐÕÃû ¿ÆÄ¿ ³É¼¨
1 ÕÅÈý ÓïÎÄ 80 ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
±í×Ö¶Î
ID NAME TIME AMOUNT
14502 1111 0201 1
14502 1111 0201 5
14 ......
´ó¼ÒÍƼöÒ»ÏÂ
Oracle Database 10g Performance Tuning Tips & Techniques
ÎÒÂòµÄ£¬¸Õ¿ªÊ¼¿´
Database Performance Tuning Guide and Reference
oracle¹«Ë¾×Ô¼ºµÄdocument£¬Ã¿¸ö´ó°æ±¾¶¼ÓÐ×Ô¼ºÒ»Ì ......