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

oracle ¼ì²é±»ËøµÄ±í¼°½âËø

Ô­ÎĵØÖ·£ºhttp://tech.e800.com.cn/articles/2009/710/1247207067745_1.html
´¦Àí·½·¨Ò» £º

¼ì²éÄĸö±í±»Ëø
select sess.sid,sess.serial#,
lo.oracle_username,lo.os_user_name,ao.object_name,lo.locked_mode
from
v$locked_object lo,dba_objects ao,v$session sess
where ao.object_id =
lo.object_id
and lo.session_id = sess.sid;

½âËø
alter
system kill session 'xxx,yyy';
×¢£º'xxx,yyy'ÊÇÉÏÃæ¼ìË÷µÃµ½µÄsess.sid,sess.serial#
´¦Àí·½·¨¶þ £º
ÕÒµ½ÄãҪɱµôµÄÄǸöSESSION,
²¢¼ÇÏÂpaddr
SELECT sid, username, paddr, status from v$session WHERE
username = 'JCUSER' and sid=ÉÏÃæ²é³öÀ´µÄsid;

ÕÒµ½Õâ¸öSESSIONËù¶ÔÓ¦µÄspid
SELECT
ADDR,PID,SPID,USERNAME,SERIAL#,TERMINAL from v$process WHERE addr¡¡=
'ÉÏÃæµÄPADDR';

ɱµôspidËù±êʶµÄÄǸö½ø³Ì
orakill sid spid


Ïà¹ØÎĵµ£º

ORACLE³£Óýű¾ÃüÁî

Óû§µÄ¹ÜÀí
Ò»¡¢ORACLEµÄ°²È«Óò
1¡¢TABLESPACE QUOTAS£º±í¿Õ¼äµÄʹÓö¨¶î
2¡¢DEFAULT TABLESPACE£ºÄ¬Èϱí¿Õ¼ä
3¡¢TEMPORARY TABLESPACE£ºÖ¸¶¨ÁÙʱ±í¿Õ¼ä¡£
4¡¢ACCOUNT LOCKING£ºÓû§Ëø
5¡¢RESOURCE LIMITE£º×ÊÔ´ÏÞÖÆ
6¡¢DIRECT PRIVILEGES£ºÖ±½ÓÊÚȨ
7¡¢ROLE PRIVILEGES£º½ÇÉ«ÊÚȨÏȽ«Ó¦ÓÃÖеÄÓû§»®Îª²»Í¬µÄ½ÇÉ«£¬ ......

oracle ²é¿´ËøºÍɱµôËø

--ËøµÄ¸ÅÄî
  Ëø³öÏÖÔÚÊý¾Ý¹²ÏíµÄ³¡ºÏ£¬ÓÃÀ´±£Ö¤Êý¾ÝµÄÒ»ÖÂÐÔ¡£µ±¶à¸ö»á»°Í¬Ê±ÐÞ¸ÄÒ»¸ö±íʱ£¬ÐèÒª¶ÔÊý¾Ý½øÐÐÏàÓ¦µÄËø¶¨¡£ 
-- ËøµÄģʽ£¬ÓÐÒÔϼ¸ÖÖģʽ
0£ºnone
1£ºnull ¿Õ
2£ºRow-S Ðй²Ïí(RS)£º¹²Ïí±íËø£¬sub share 
3£ºRow-X ÐжÀÕ¼(RX)£ºÓÃÓÚÐеÄÐ޸ģ¬sub ex ......

ÔÚAIX»·¾³ÏÂΪOracle¡¢sybase ʹÓÃÂãÉ豸 ¼¯ÖÐÌÖÂÛ35

¡¶oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX/unixÉϵÄʵսÏê½â¡·¼¯ÖÐÌÖÂÛ35£ºÔÚAIX»·¾³ÏÂΪOracle¡¢sybase ʹÓÃÂãÉ豸   ÎÄÆ½    ÂãÉ豸ÊÂÒ»ÖÖÔÚUNIXϳ£ÓõÄÊý¾Ý¿âÊý¾Ý´æ´¢·½Ê½,ÔÚAIXÖÐÈç´Ë,ÔÚHP-UX\SCO UNIXµÈϵͳÖнÔÊÇÈç´Ë¡£Õâ¶ÎʱÆÚÒÔÀ´Ò»Ö±ÓÐͬ־ÃÇÓʼþѯÎÊÈçºÎʹÓÃÂãÉ豸¡£ÕâÀïÎÒ»ã×ÜһЩAIXÏÂÂãÉ豸µÄʹÓÃÎ ......

LinuxÏÂOracleÖØÆôºÍÐÞ¸ÄÁ¬½ÓÊý

Ò»¡¢Æô¶¯
 
1.#su - oracle              Çл»µ½oracleÓû§ÇÒÇл»µ½ËüµÄ»·¾³
2.$lsnrctl status           ²é¿´¼àÌý¼°Êý¾Ý¿â״̬
3.$lsnrctl start      &nb ......

SQLServerºÍOracleµÄ³£Óú¯Êý¶Ô±È

SQLServerºÍOracleµÄ³£Óú¯Êý¶Ô±È
 
1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
 
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
 
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ