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

oracleµÄ¶Áд±í²¢·¢²Ù×÷

 k Ëµ(14:52):
ÎʸöÎÊÌâ ²éѯÊý¾Ý¿â±íµÄʱºò ¸Ã±í»¹ÄÜдÊý¾ÝÂð  ÊÇ°´ÕÕÅŶӵÄ˳Ðò »¹ÊÇ°´ÕÕ²Ù×÷µÄʱ¼ä˳Ðò(²»ÖªµÀoracleÈçºÎ´¦ÀíÕâ¸öÎÊÌ⣩  ¼ÙÉèÒ»¸öÇé¿ö£ºÎÒÏÖÔÚÔÚ²éѯ¼Æ·Ñ±í£¨Õâ¸öʱ¼ä¿ÉÄÜÒª»¨10·ÖÖÓ£© 10·ÖÖÓÓкܶà¼Æ·ÑÊý¾ÝÒªÈë¼Æ·Ñ±í£¨ÄÇÕâ¸öдÊý¾ÝÊÇÒªµÈÎÒ²éѯÍêÁËÖ®ºó²ÅÄÜдÂ𣩠дÊý¾Ý¿â¿Ï¶¨ºÜ¿ì£¨0.1Ã루»¹ÊÇÀ´ÁËÊý¾Ý¾Íд£© ²éѯÒÀÈ»²éѯд֮ǰµÄÊý¾Ý
m˵(14:54):
ÄÜд
m1˵(14:54):
ÄãÓÃselect .... for update nowait ºÃÏñÊÇ ÎÒÍüÁ˾ßÌåÔõôдÁË£¬ÕâÑù¾Í¿ÉÒÔËø±íÁË£¬µÈÄã²éÍêÁËÌá½»ºó±ðÈ˲ÅÄܸüÐÂ
m˵(14:55):
¸úÊÂÎV±ðÓйØϵ
m˵(14:55):
²¢·¢¼¶±ðÉèÖÃ
m3 Ëµ(14:56):
²éѯʱºòǧÍò±ðËø±í
k Ëµ(14:59):
ÎÒÏÖÔÚÒ²¾õµÃÄÜд ÒòΪÎÒ²éѯ±¨±í¿â ¶©¹º±í Êý¾Ý³öÀ´µÄºÜ¿ì£¨597.797Ãë) ÏÖÔÚÎÒ²éÏÖÍø¿â »¨ÁË 1184.062Ãë  ÕâÖÐ;¿Ï¶¨Ð´Êý¾ÝÈ¥ÁË 
m ˵(14:59):
ÄÜд
m˵(14:59):
²éѯ£¬Ð´È붼ÊDz¢·¢µÄ
ÏÖÔÚÓÐеÄÎÊÌ⣬¼ÈÈ»²éѯÊý¾ÝµÄʱºòÒ²ÔÚдÊý¾Ý£¬ÄÇôÎҵIJéѯ³¡¾°Ó¦¸ÃÊÇд֮ǰµÄ³¡¾°£¬ÒòΪÈç¹ûдһ´ÎÊý¾Ý£¬ÎÒÓÖ´ÓÍ·¿ªÊ¼²éѯ£¬ÄÇÎҵIJéѯ¾ÍÍê³É²»ÁËÁË¡£ËùÒÔoracleÓ¦¸ÃÊÇÓÃÁË»º³åÊý¾ÝµÄ¹¦ÄÜ£¬²éѯµÄ¹ý³ÌÖУ¬ÏÈ°ÑдÈëµÄÊý¾Ý·Åµ½»º³åÇøÀµÈ²éѯÍê±ÏÁË£¬ÔÚдÈë±í¿Õ¼äÀï¡££¨²»ÖªµÀÊDz»ÊÇÕâÑù£¬¶ÔÊý¾Ý¿â²»ÊǺÜÁ˽⣬ÕâÊÇÎÒµÄÒ»¸öÏë·¨¶øÒÑ£¬×Ô¼º¾õµÃ»¹Óеã¶ùµÀÀí£©


Ïà¹ØÎĵµ£º

ÉèÖÃOracleÌáʾ·û

ÔÚ$ORACLE_HOME/sqlplus/admin/login.sql (»òÕßÊÇglogin.sql)ÖÐÌí¼Ó£º
set termout off   
  COLUMN prompter new_value m_prompt     
  select host_name || ':' || instance_name ||' >'  prompter       
  from sys.v_$insta ......

db2,oracle,mysql³£ÓÃÃüÁî±È½Ï


¡¶oracle,db2,mysqlÀà±È¡·×÷ΪÈýÖÖÊý¾Ý¿âÒ»¸öÀà±È£¬Ä¿µÄÔÚÓÚͨ¹ýÀà±È£¬Á˽âÏÖÔÚÊý¾Ý¿âÏàËƵãÓëÒìͬµã£¬Í¬Ê±¿ÉÒÔ°ïÖú´ó¼ÒÔÚÁ˽âÒ»ÖÖÊý¾Ý¿â£¬Äܹ»Ñ¸ËÙµØѧ»áÆäËûÊý¾Ý¿â¡£³õ²½¶¨ÒåΪoracle,db2,mysqlÈýÖÖÊý¾Ý¿â£¬ÒÔºó¿ÉÄÜ»¹ÊÇ×·¼Óinformix,sysbase,sql serverµÈÊý¾Ý¿â¡£
±¾Æª×÷ΪÊ×ƪ£¬Ä¿µÄÊÇÈôó¼Ò¶ÔÕâÈýÖÖÊý¾Ý¿â³£ÓõÄÖªÊ ......

OracleÖÐKill sessionµÄÑо¿

ÎÒÃÇÖªµÀ,ÔÚOracleÊý¾Ý¿âÖÐ,¿ÉÒÔͨ¹ýkill sessionµÄ·½Ê½À´ÖÕÖ¹Ò»¸ö½ø³Ì,Æä»ù±¾Óï·¨½á¹¹Îª:
alter system kill session 'sid,serial#' ;
±»killµôµÄsession,״̬»á±»±ê¼ÇΪkilled,Oracle»áÔÚ¸ÃÓû§ÏÂÒ»´ÎtouchʱÇå³ý¸Ã½ø³Ì.
ÎÒÃÇ·¢ÏÖµ±Ò»¸ösession±»killµôÒԺ󣬸ÃsessionµÄpaddr±»Ð޸ģ¬Èç¹ûÓжà¸ösession±»kill£¬ÄÇô¶ ......

oracle°´Ê±¼ä²éѯ·­Ò³Ê±³öÏÖÓëÇ°ÃæÒ»Ò³Öظ´Êý¾Ý

ÓÃhibernate²éѯ·Öҳʱ£¬·­Ò³ÏÔʾÖÐÓÐÉÙÁ¿¼Ç¼ÊÇÖظ´µÄ¡£ÒѾ­È·ÈÏsqlд·¨Ã»´íÎó¡£
select savebillin0_.*,entityacct2_.*
from save_bill_info savebillin0_,
CUST_INFO custinfo1_,
entity_acct_bill entityacct2_
where savebillin0_.cust_id = custinfo1_.ID
and entityacct2_.ACCOU ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ