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ÖÐÒ»¸öÊÂÎñÊÇÓÉÒ»¸ö¿ÉÖ´ÐеÄSQLÓï¾ä¿ªÊ¼£¬Ò»¸ö¿ÉÖ´ÐÐSQLÓï¾ä²úÉú¶ÔʵÀýµÄµ÷Óá£ÔÚÊÂÎñ¿ªÊ¼Ê±£¬±»¸³¸øÒ»¸ö¿ÉÓûعö¶Î£¬¼Ç¼¸ÃÊÂÎñµÄ»Ø¹öÏî¡£Ò»¸öÊÂÎñÒÔÏÂÁÐÈκÎÒ»¸ö³öÏÖ¶ø½áÊø¡£
¡ôµ±COMMIT»òROLLBACK£¨Ã»ÓÐSAVEPOINT×Ӿ䣩Óï¾ä·¢³ö¡£
¡ôÒ»¸öDDLÓï¾ä±»Ö´ÐС£ÔÚDDLÓï¾äÖ´ÐÐǰ¡¢ºó¶¼ÒþʽµØÌá½»¡£
¡ôÓû§³·Ïû¶ÔOra ......
OracleÈ«ÎÄË÷ÒýµÄ»ù±¾ÖªÊ¶
Ò»¡¢ÀúÊ·±³¾°
OracleÊý¾Ý¿âµÄÈ«ÎļìË÷¼¼ÊõÒѾ·Ç³£ÍêÃÀ£¬Oracle TextʹOracle9i¾ß±¸ÁËÇ¿´óµÄÎı¾¼ìË÷ÄÜÁ¦ºÍÖÇÄÜ»¯µÄÎı¾¹ÜÀíÄÜÁ¦¡£Oracle TextÊÇOracle9i²ÉÓõÄÐÂÃû³Æ£¬ÔÚOracle8/8iÖÐËü±»³Æ×÷Oracle interMedia Text£¬ÔÚOracle8ÒÔǰËüµÄÃû³ÆÊÇOracle ConText Cartridge¡£
¶þ¡¢Oracle Text Ë÷Ò ......
´´½¨Àý³Ì£º
-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 ......
½¨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 ±í½á¹¹µÄ´´½¨ºÍ×îºóÐÞ¸Äʱ¼ä
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 ......