½âËø±í(oracle)
µ±Ê¹ÓÃ'for update' Ôì³É±íËøסÁË.¿ÉÒÔÓÃDBAµÇ½°´ÕÕÏÂÃæ²½Öè:
1.²é¿´Äĸö±í±»Ëø:
select b.owner,b.object_name,l.session_id,l.locked_mode
from v$locked_object l, dba_objects b
where b.object_id=l.object_id;
2.²é¿´±»Ëø±íµÄsid ºÍserial# :
select t2.username,t2.sid,t2.serial#,t2.logon_time
from v$locked_object t1,v$session t2
where t1.session_id=t2.sid order by t2.logon_time;
3.Ö´ÐÐÏÂÃæµÄÓï¾ä:
alter system kill session 'sid,serial#';
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
²»ÊÇORACLEµÄÎÊÌâ
2009-12-30 15:00
  ......
WINDOWSÏ ORACLE ÕìÌý³ÌÐòÒ쳣ֹͣ¹ÊÕÏ´¦Àí
WINDOWSÏ ORACLE ÕìÌý³ÌÐòÒ쳣ֹͣ¹ÊÕÏ´¦Àí
¼ÒÀïÓÃÀ´µĄ̈ʽ»úÉÏ×°Á˸öWINDOWSϵÄORACLE 10G,ºÃ¾ÃûÓÃÁË£¬½ñÌì´ò¿ª´òËãÓÃһϣ¬Æô¶¯Êý¾Ý¿â£¬Æô¶¯ÕìÌý£¬¿´×źÜÕý³££¬µ«ÊÇÔÚ¿Í»§¶ËµÄTNSPING
C:\>tnsping homedb
TNS Ping Utility for 32-bit Window ......
Èí¼þ»·¾³:
1¡¢Windows XP + Oracle 10g
2¡¢Oracle°²×°Â·¾¶Îª:d:\Oracle
ʵÏÖ·½·¨:
1¡¢¿ªÊ¼£>ÉèÖã>¿ØÖÆÃæ°å£>¹ÜÀí¹¤¾ß£>·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ;
2¡¢¿ªÊ¼£>³ÌÐò£>Oracle – OraDb10g_home1>Oracle Installation Products£> Universal Installer жװËùÓÐOracle²úÆ·,µ«Universal I ......
1.ÔÚORACLEÖÐʵÏÖ·Ö²¼Ê½¿ìËÙ´æÈ¡ºÍ³äʵÄÚ´æÊǺÜÖØÒªµÄ¡£
¡¡¡¡
¡¡¡¡Òª²»Ï§Èκδú¼Û±ÜÃâÒ³Ãæµ÷¶ÈºÍ½»»»﹐ÿ´Î¶¼±ØÐë°Ñϵͳȫ¾ÖÇø(SGA)·Åµ½ÄÚ´æ¡£
¡¡¡¡
¡¡¡¡½«SGA·Åµ½ÄÚ´æÖÐ﹐ÔÚINIT.ORAÖÐÉèÖòÎÊý PRE_PAGE_SGA
¡¡¡¡
¡¡¡¡PRE_PAGE_SGA=YES
¡¡¡¡
¡¡¡¡2.»Ø¾í¶ÎµÄ¾¹Õù»á½µµÍϵͳµÄÐÔÄÜ¡£
¡¡¡¡
¡¡¡¡SELECT¡ ......