ÓÐʲôÊéÊǽ²¹ØÓÚ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/¿´¿´,Õâ¸öÈËÊÇ´óʦ!
Ïà¹ØÎÊ´ð£º
ÊÖÍ·ÓÐÒ»¸öÀϵIJúÆ·£¬delphi 6Á¬½Óoracle,È¡sys.aud$ϵͳ±íÀïÃæµÄÊý¾Ý
ÓÃAdoconnection+adodataset,
ÓÃsystemÓû§£¬Adoconnection Á¬½Ó³É¹¦£¬µ«Èç¹ûÔÚadodatasetÀïÃæÐ´:
SELECT * from SYS.AUD ......
´úÂë
select * from ct_lsb where br_number like '0746 8[1-3]%'
ÇëÎÊ ÎªÊ²Ã´Õâ¸ö²é²»³öÊý¾Ý£¿
select * from ct_lsb where br_number like '0746 83%'Õâ¸ö²éµÄ³ö¶î£¡
select ......
create or replace function GetWorkBeginTime()
return date is
myDate date;
begin
myDate := trunc(sysdate-1)+8/24;
return myDate;
end;
......
ÓÐÒ»±íÈçÏ£º
ID ÐÕÃû ¿ÆÄ¿ ³É¼¨
1 ÕÅÈý ÓïÎÄ 80 ......
1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?
2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......