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

oracleËÀËøµÄ¼ì²â¼°´¦Àí

Ò». ËÀËøµÄ¼ì²â
   --²éËÀËøµÄ»á»°¡£
select  A.sid, b.serial#,
 decode(A.type,
    'MR', 'Media Recovery',
    'RT','Redo Thread',
    'UN','User Name',
    'TX', 'Transaction',
    'TM', 'DML',
    'UL', 'PL/SQL User Lock',
    'DX', 'Distributed Xaction',
    'CF', 'Control File',
    'IS', 'Instance State',
    'FS', 'File Set',
    'IR', 'Instance Recovery',
    'ST', 'Disk Space Transaction',
    'TS', 'Temp Segment',
    'IV', 'Library Cache Invalida-tion',
    'LS', 'Log Start or Switch',
    'RW', 'Row Wait',
    'SQ', 'Sequence Number',
    'TE', 'Extend Table',
    'TT', 'Temp Table',
    'Unknown') LockType,
 c.object_name,
 b.username,
 b.osuser,
 decode(a.lmode,   0, 'None',
            1, 'Null',
            2, 'Row-S',
            3, 'Row-X',
            4, 'Share',
            5, 'S/Row-X',
            6, 'Exclusive', 'Unknown') LockMode,
 B.MACHINE,D.SPID ,b.PROGRAM
 from v$lock a,v$session b,all_objects c,V$PROCESS D
 where a.sid=b.sid and a.type in ('TM','TX')
 and c.object_id=a.id1
 AND B.PADDR=D.ADDR
¶þ. ·¢ÉúËÀËøºóµÄ´¦Àí·½·¨
1. 9iÒÔºóµÄ°æ±¾,oracle»á×Ô¶¯¼ì²âËÀËø,¼ì²âµ½ÓÐËÀËøºó»á»Ø¹ö»òÌá½»ÆäÖÐÒ»¸öÊÂÎñ,ʹËÀËøÏû³ý.
2. ALTER SYSTEM KILL 'SID,SIEREL#' ×¢Òâ:ÓпÉÄܲúÉúÁ½¸ö»á»°SIDΪһÑù


Ïà¹ØÎĵµ£º

.netÔÚweb.configÖÐÁ¬½ÓoracleÊý¾Ý¿â

1.asp.netÁ¬½Óoracle·þÎñÆ÷ÐèÒªÌí¼ÓSytem.Data.OracleClientÃüÃû¿Õ¼ä£¬½«System.Data.OracleClient.dll¼ÓÈëµ½ÏîÄ¿ÖС£
2.Á¬½ÓʱÐèÒªConnectionString×Ö·û´®£¬³öÏÖÔÚweb.configÎļþÖУ¬ÈçÏÂËùʾ£º
<connectionStrings>
   <add name="ConnectionString" connectionString="Data Source=(DESCRIPTION=( ......

oracleµÄ´æ´¢¹ý³ÌºÍÓαê


OracleÖеĴ洢¹ý³ÌºÍÓαê:
select myFunc(²ÎÊý1,²ÎÊý2..) to dual; --¿ÉÒÔÖ´ÐÐһЩҵÎñÂß¼­
Ò»:OracleÖеĺ¯ÊýÓë´æ´¢¹ý³ÌµÄÇø±ð:
A:º¯Êý±ØÐëÓзµ»ØÖµ,¶ø¹ý³ÌûÓÐ.
B:º¯Êý¿ÉÒÔµ¥¶ÀÖ´ÐÐ.¶ø¹ý³Ì±ØÐëͨ¹ýexecuteÖ´ÐÐ.
C:º¯Êý¿ÉÒÔǶÈëµ½SQLÓï¾äÖÐÖ´ÐÐ.¶ø¹ý³Ì²»ÐÐ.
ÆäʵÎÒÃÇ¿ÉÒÔ½«±È½Ï¸´ÔӵIJéѯд³Éº¯Êý.È»ºóµ½´æ´¢¹ý³Ì ......

¸ü»»ORACLE±í¶ÔÏóËùÊôÓû§

 ÒÔǰÓиöÏîÄ¿½«Óû§±í½¨Á¢ÔÚÁËsystemÓû§ËùÊôÏ£¬ºóÀ´·¢¾õΣº¦Ï൱´ó£¬×¼±¸½«±í¶ÔÏó×ªÒÆµ½Ð½¨Á¢µÄLANDÓû§Ï£¬Ã»ÕÒµ½Ö±½ÓµÄ°ì·¨£¬ÓÃÒÔϰ취µÃÒÔʵÏÖ£º
1¡¢½¨Á¢ÐµÄLANDÓû§£¬ÔÚ·þÎñÆ÷µÄOracle Enterprise ManagerÀï·ÖÅä ¶ÔÏóȨÏÞ £¬Ìí¼Ó¶ÔsystemÖÐÊý¾Ý±í¶ÔÏóµÄ select  È¨ÏÞ¡£
2¡¢ÒÔ LAND Óû§µÇ¼£¬Ê¹ÓÃÃüÁ ......

[ת]Oracle Ëæ»ú»ñÈ¡NÌõÊý¾Ý


µ±ÎÒÃÇ»ñÈ¡Êý¾Ýʱ,¿ÉÄÜ»áÓÐÕâÑùµÄÐèÇó,¼´Ã¿´Î´Ó±íÖлñÈ¡Êý¾Ýʱ,ÊÇËæ»ú»ñȡһ¶¨µÄ¼Ç¼,¶ø²»ÊÇÿ´Î¶¼»ñȡһÑùµÄÊý¾Ý,ÕâʱÎÒÃÇ¿ÉÒÔ²ÉÈ¡OracleÄÚ²¿Ò»Ð©º¯Êý,À´´ïµ½ÕâÑùµÄÄ¿µÄ.   
  
   1) select * from (select * from tablename order  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ