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

ORACLEËÀËø²éѯ¼´´¦Àí

¹ØÓÚÊý¾Ý¿âËÀËøµÄ¼ì²é·½·¨
Ò»¡¢         Êý¾Ý¿âËÀËøµÄÏÖÏó
³ÌÐòÔÚÖ´ÐеĹý³ÌÖУ¬µã»÷È·¶¨»ò±£´æ°´Å¥£¬³ÌÐòûÓÐÏìÓ¦£¬Ò²Ã»ÓгöÏÖ±¨´í¡£
¶þ¡¢        
ËÀËøµÄÔ­Àí
µ±¶ÔÓÚÊý¾Ý¿âij¸ö±íµÄijһÁÐ×ö¸üлòɾ³ýµÈ²Ù×÷£¬Ö´ÐÐÍê±Ïºó¸ÃÌõÓï¾ä²»Ìá
½»£¬ÁíÒ»Ìõ¶ÔÓÚÕâÒ»ÁÐÊý¾Ý×ö¸üвÙ×÷µÄÓï¾äÔÚÖ´ÐеÄ
ʱºò¾Í»á´¦Óڵȴý״̬£¬
´ËʱµÄÏÖÏóÊÇÕâÌõÓï¾äÒ»Ö±ÔÚÖ´ÐУ¬µ«Ò»Ö±Ã»ÓÐÖ´Ðгɹ¦£¬Ò²Ã»Óб¨´í¡£
Èý¡¢         ËÀËøµÄ¶¨Î»·½·¨
ͨ
¹ý¼ì²éÊý¾Ý¿â±í£¬Äܹ»¼ì²é³öÊÇÄÄÒ»ÌõÓï¾ä±»ËÀËø£¬²úÉúËÀËøµÄ»úÆ÷ÊÇÄÄһ̨¡£
1£©ÓÃdbaÓû§Ö´ÐÐÒÔÏÂÓï¾ä
select
username,lockwait,status,machine,program from v$session where sid in
(select
session_id from v$locked_object)
Èç¹ûÓÐÊä³öµÄ½á¹û£¬Ôò˵Ã÷ÓÐËÀËø£¬ÇÒÄÜ¿´µ½ËÀËøµÄ»úÆ÷ÊÇÄÄһ̨¡£×Ö¶Î˵Ã÷£º
Username£º
ËÀËøÓï¾äËùÓõÄÊý¾Ý¿âÓû§£»
Lockwait£ºËÀËøµÄ״̬£¬Èç¹ûÓÐÄÚÈݱíʾ±»ËÀËø¡£
Status£º ״̬£¬active±íʾ±»ËÀËø
Machine£º
ËÀËøÓï¾äËùÔڵĻúÆ÷¡£
Program£º ²úÉúËÀËøµÄÓï¾äÖ÷ÒªÀ´×ÔÄĸöÓ¦ÓóÌÐò¡£
2£©ÓÃdbaÓû§Ö´ÐÐÒÔÏÂÓï¾ä£¬¿ÉÒԲ鿴µ½±»ËÀËøµÄÓï
¾ä¡£
select sql_text from v$sql where hash_value in
(select
sql_hash_value from v$session where sid in
(select session_id from
v$locked_object))
ËÄ¡¢         ËÀËøµÄ½â¾ö·½·¨
     Ò»°ãÇé¿öÏ£¬Ö»Òª½«²úÉúËÀËøµÄÓï¾äÌá½»¾Í¿ÉÒÔÁË£¬µ«ÊÇÔÚʵ¼ÊµÄÖ´Ðйý³ÌÖС£Óû§¿É
ÄÜ
²»ÖªµÀ²úÉúËÀËøµÄÓï¾äÊÇÄÄÒ»¾ä¡£¿ÉÒÔ½«³ÌÐò¹Ø±Õ²¢ÖØÐÂÆô¶¯¾Í¿ÉÒÔÁË¡£
¡¡¾­³£ÔÚOracle
µÄ
ʹÓùý³ÌÖÐÅöµ½Õâ¸öÎÊÌ⣬ËùÒÔÒ²×ܽáÁËÒ»µã½â¾ö·½·¨¡£
¡¡¡¡1£©²éÕÒËÀËøµÄ½ø³Ì£º
sqlplus "/as sysdba" (sys/change_on_install)
SELECT
s.username,l.OBJECT_ID,l.SESSION_ID,s.SERIAL#,
l.ORACLE_USERNAME,l.OS_USER_NAME,l.PROCESS

from V$LOCKED_OBJECT l,V$SESSION S WHERE l.SESSION_ID=S.SID;
¡¡¡¡2£©killµôÕâ¸öËÀËøµÄ½ø³Ì£º
¡¡¡¡alter system kill session ‘sid,serial#’; £¨ÆäÖÐsid=l.session_id£©
¡¡¡¡3£©Èç¹û»¹²»Äܽâ¾ö£º
select pro.spid from v$session ses,
v$process pro where ses.sid=XX
and
ses.


Ïà¹ØÎĵµ£º

OracleÖÐÊÂÎñ¹ÜÀíµÄ¸ÅÄî


ÔÚOracleÖÐÒ»¸öÊÂÎñÊÇÓÉÒ»¸ö¿ÉÖ´ÐеÄSQLÓï¾ä¿ªÊ¼£¬Ò»¸ö¿ÉÖ´ÐÐSQLÓï¾ä²úÉú¶ÔʵÀýµÄµ÷Óá£ÔÚÊÂÎñ¿ªÊ¼Ê±£¬±»¸³¸øÒ»¸ö¿ÉÓûعö¶Î£¬¼Ç¼¸ÃÊÂÎñµÄ»Ø¹öÏî¡£Ò»¸öÊÂÎñÒÔÏÂÁÐÈκÎÒ»¸ö³öÏÖ¶ø½áÊø¡£
¡ôµ±COMMIT»òROLLBACK£¨Ã»ÓÐSAVEPOINT×Ӿ䣩Óï¾ä·¢³ö¡£
¡ôÒ»¸öDDLÓï¾ä±»Ö´ÐС£ÔÚDDLÓï¾äÖ´ÐÐǰ¡¢ºó¶¼ÒþʽµØÌá½»¡£
¡ôÓû§³·Ïû¶ÔOra ......

OracleÖÐÎÄÈ«ÎÄË÷Òý

OracleÈ«ÎÄË÷ÒýµÄ»ù±¾ÖªÊ¶
Ò»¡¢ÀúÊ·±³¾°
OracleÊý¾Ý¿âµÄÈ«ÎļìË÷¼¼ÊõÒѾ­·Ç³£ÍêÃÀ£¬Oracle TextʹOracle9i¾ß±¸ÁËÇ¿´óµÄÎı¾¼ìË÷ÄÜÁ¦ºÍÖÇÄÜ»¯µÄÎı¾¹ÜÀíÄÜÁ¦¡£Oracle TextÊÇOracle9i²ÉÓõÄÐÂÃû³Æ£¬ÔÚOracle8/8iÖÐËü±»³Æ×÷Oracle interMedia Text£¬ÔÚOracle8ÒÔǰËüµÄÃû³ÆÊÇOracle ConText Cartridge¡£
¶þ¡¢Oracle Text Ë÷Ò ......

OracleÖÐOradim¹¤¾ßµÄÓ÷¨

´´½¨Àý³Ì£º
-NEW -SID sid | -SRVC ·þÎñ [-INTPWD ¿ÚÁî] [-MAXUSERS ÊýÁ¿] [-STARTMODE a|m] [-PFILE Îļþ] [-TIMEOUT Ãë]
±à¼­Àý³Ì£º
-EDIT -SID sid [-NEWSID sid] [-INTPWD ¿ÚÁî] [-STARTMODE auto|manual] [-PFILE ÎļþÃû]      [-SHUTMODE a|i|n]     [-SHUTTYPE srv ......

Oracle ×ÔÔö³¤×Ö¶Î

½¨SEQUENCEÐòÁР
CREATE SEQUENCE  ÐòÁÐÃû×Ö£¨ÀýÈ磺"URLIMAGE_SEQ"£©  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 101 CACHE 10 NOORDER  NOCYCLE ;
 
½¨trigger ´¥·¢Æ÷
create or replace trigger ´¥·¢Æ÷Ãû×Ö£¨ÀýÈ磺URLIMAGE_TRI £©
  before ins ......

oracle×Ö·û¼¯


²é¿´Oracle ±í½á¹¹µÄ´´½¨ºÍ×îºóÐÞ¸Äʱ¼ä
SELECT a.owner, a.table_name, created, last_ddl_time
  from dba_tables a, SYS.dba_objects b
WHERE a.tablespace_name = 'USERS'
   AND a.owner = b.owner
   AND a.table_name = b.object_name
   AND object_type = 'TABL ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ