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_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 ......
¡¶oracle,db2,mysqlÀà±È¡·×÷ΪÈýÖÖÊý¾Ý¿âÒ»¸öÀà±È£¬Ä¿µÄÔÚÓÚͨ¹ýÀà±È£¬Á˽âÏÖÔÚÊý¾Ý¿âÏàËƵãÓëÒìͬµã£¬Í¬Ê±¿ÉÒÔ°ïÖú´ó¼ÒÔÚÁ˽âÒ»ÖÖÊý¾Ý¿â£¬Äܹ»Ñ¸ËÙµØѧ»áÆäËûÊý¾Ý¿â¡£³õ²½¶¨ÒåΪoracle,db2,mysqlÈýÖÖÊý¾Ý¿â£¬ÒÔºó¿ÉÄÜ»¹ÊÇ×·¼Óinformix,sysbase,sql serverµÈÊý¾Ý¿â¡£
±¾Æª×÷ΪÊ×ƪ£¬Ä¿µÄÊÇÈôó¼Ò¶ÔÕâÈýÖÖÊý¾Ý¿â³£ÓõÄÖªÊ ......
ÎÒÃÇÖªµÀ,ÔÚOracleÊý¾Ý¿âÖÐ,¿ÉÒÔͨ¹ýkill sessionµÄ·½Ê½À´ÖÕÖ¹Ò»¸ö½ø³Ì,Æä»ù±¾Óï·¨½á¹¹Îª:
alter system kill session 'sid,serial#' ;
±»killµôµÄsession,״̬»á±»±ê¼ÇΪkilled,Oracle»áÔÚ¸ÃÓû§ÏÂÒ»´ÎtouchʱÇå³ý¸Ã½ø³Ì.
ÎÒÃÇ·¢ÏÖµ±Ò»¸ösession±»killµôÒԺ󣬸ÃsessionµÄpaddr±»Ð޸ģ¬Èç¹ûÓжà¸ösession±»kill£¬ÄÇô¶ ......
ÓÃ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 ......