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

oracle Ëø±í´¦Àí

--²é³öËùÓб»Ëø×¡µÄ±í
select b.owner TABLEOWNER, b.object_name TABLENAME, c.OSUSER LOCKBY, c.USERNAME LOGINID, c.sid SID, c.SERIAL# SERIAL
from v$locked_object a,dba_objects b, v$session c
where b.object_id = a.object_id AND a.SESSION_ID =c.sid;
--ͨ¹ýSID, SERIAL½âËø
--alter system kill session 'SID, SERIAL';


Ïà¹ØÎĵµ£º

Oracle¹ÜÀíÔ±µÄÁ½ÖÖÈÏÖ¤·½·¨

  Oracle¹ÜÀíÔ±µÄÁ½ÖÖÈÏÖ¤·½·¨
×¢Òâ£ºÖØÒª
parameter ÖÐremote_login_passwordfile
1¡¢alter system set remote_login_passwordfile= none scope =spfile£»
     º¬Ò壺·ÇÃÜÂëÈÏÖ¤£¨´Ëʱ½öosÈÏÖ¤ £©
 2¡¢alter system set remote_login_passwordfile= exclusive  ......

Ïòoracle±íÖвåÈë´óÁ¿Êý¾Ý

ÐèÒª´óÁ¿oracle²âÊÔÊý¾Ýʱ£¬¿ÉÒÔʹÓÃÒÔÏ·½·¨¡£
DECLARE
 i INT;
BEGIN
i := 0;
WHILE(i < 100000)
LOOP
 i := i + 1;
 INSERT INTO TEST_TABLE(ID, XM) VALUES(i, 'ÐÕÃû' || i);
END LOOP;
COMMIT;
 END; ......

OracleÊý¾Ý¿âÉè¼Æ

Êý¾ÝownerºÍÊý¾Ý²Ù×÷ÕßÒÔ¼°´úÂë·ÃÎÊʹÓò»Í¬µÄÓû§·ÃÎÊ£¬Ê¹ÓÃÊÚȨµÄ·½Ê½½øÐзÃÎÊ¡£
Êý¾Ý±í´´½¨Ê±Ê¹ÓÃͬÒå´Ê´´½¨
ÊÚȨʱ×îºÃ²»ÒªÊ¹ÓÃwith grant option
ÒÔǰ²»Ì«Ã÷°×ͬÒå´ÊµÄʹÓã¬ÏÖÔÚÖªµÀÁË¡£±È½ÏºÃµÄÓ¦ÓþÍÊÇ´´½¨±íµÄ±ðÃû
create public ͬÒå´Ê tableName for owner.tableName
 ¸øÊÓͼÊÚȨ¿ÉÒÔʹµÃÓû§·ÃÎʲ»¾ß ......

Oracle Listener ·þÎñ²»ÄÜÆô¶¯µÄÁíÒ»·¢ÏÖ

    ×î½üʱ¼ä£¬¸ü»»ÁËÏîÄ¿×飬×î½üͻȻ·¢ÏÖOracle Listener²»ÄÜÆô¶¯¡£ÒÔǰ·¢ÏÖ²»ÄÜÆô¶¯µÄÔ­ÒòÊÇ£¬ÖØ×°ÁËOracleºóûÓÐɾ³ýÒÔǰµÄ×¢²á±í£¬ÒÔÖÁÓÚĬÈÏÆô¶¯·þÎñµÄÃüÁîÎļþÖ¸ÏòµÄÒÀÈ»ÊÇÒÔǰµÄλÖã¬ËùÒÔ²»ÄÜÆô¶¯£¬µ«Õą̂µçÄÔµÄOracleÖ»×°ÁËÒ»´Î¡£
    ×òÌìͻȻ·¢ÏÖ£¬ÔÚlistener.oraÎļþÖеÄHostÅ ......

ÈçºÎÔÚoracleÖе¼Èëµ¼³ödmpÊý¾Ý¿âÎļþ

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
 
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ