OracleÊý¾Ý¿âÖмǼ±»ÁíÒ»¸öÓû§Ëøס
oracleÊý¾Ý¿âÖÐÐÞ¸ÄÊý¾ÝʱÌáʾ“¼Ç¼±»ÁíÒ»¸öÓû§Ëøס” ½â¾ö·½·¨£º
1>²é¿´Êý¾Ý¿âËø,Õï¶ÏËøµÄÀ´Ô´¼°ÀàÐÍ£º
¡¡¡¡select object_id,session_id,locked_mode from v$locked_object;
»òÕßÓÃÒÔÏÂÃüÁ
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>ÕÒ³öÊý¾Ý¿âµÄ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>ɱËÀ¸Ãsession
¡¡¡¡alter system kill session 'sid,serial#'
Ïà¹ØÎĵµ£º
oracle´æ´¢¹ý³ÌÒì³£ÐÅÏ¢µÄÏÔʾ
֮ǰд´æ´¢¹ý³Ìʱ£¬Òì³£´¦Àíд·¨ÊÇ£º
...
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
END ...
ÕâÖÖд·¨µ±´æ´¢¹ý³ÌÅ׳öÒ쳣ʱ£¬ÎÒÃDz»ÖªµÀÆäµ½µ×Å׳öÁËÄÄÖÖÒì³££¨±ÈÈçÁпí¶È²»¹»´ó¶øÔÚ²åÈëÊý¾ÝʱÅ×Òì³££©£¬¿ÉÒÔ°´ÈçÏ·½Ê½ÏÔʾÒì³£ÐÅÏ¢
EXCEPTION
  ......
Oracle½âËøÓë¼ÓËø£¨hrÓû§ÎªÀý£©
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jul 14 18:12:38 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn sys/sys as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> desc dba_users
Name &nbs ......
SQL> DESC TEST ²âÊÔ±í: Name Type Nullable Default Comments
---- ------------ ......
ÔÚArcGISÖÐͨ¹ýSDE´æ´¢¿Õ¼äÊý¾Ýµ½OracleÖÐÓжàÖÖ´æ´¢·½Ê½£¬·Ö±ðÓУº¶þ½øÖÆLong Raw ¡¢ESRIµÄST_GeometryÒÔ¼°»ùÓÚOracle SpatialµÄSDO_GeometryµÈµÈ¡£
¹ØÓÚÕ⼸ÖÖ·½Ê½µÄ¸÷×ÔµÄÓÅȱµã²»ÊÇÖ÷ÒªµÄ̽Ìֵķ½Ïò£¬ÕâЩÎÒÃÇ¿ÉÒÔͨ¹ýArcGISÖеÄArcGIS Server HelpµÃµ½Ïà¹ØµÄ°ïÖú¡£ÕâÀïÖ÷Ò ......
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;
mso-font-charset:2;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:0 268435456 0 0 -2147483648 0;}
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 ......