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

Oracle»¹Ô­Êý¾Ý¶Î³£ÓùÜÀí²Ù×÷

²ÎÊý
UNDO_MANAGEMENT = AUTO      --¹ÜÀíģʽ,¿ÉΪAUTO»òMANUAL.Ö»ÄÜÔÚÆôʼ²ÎÊýÎļþÀïÃæÐÞ¸Ä
UNDO_TABLESPACE = undo             --ÖÆ¶¨´æ´¢»¹Ô­Êý¾ÝµÄ±í¿Õ¼ä,Òà¿ÉÓÃALTER SYSTEM SET undo_tablespace = 'abc'À´¸ü¸Ä
UNDO_RETENTION = 1800               --Ö¸¶¨Êý¾ÝÌá½»ºó»¹Ô­¶Î¼ÌÐø±£´æ¶à¾ÃµÄʱ¼ä,ÃëÖÓ. Òà¿ÉÓÃALTER SYSTEM SET undo_retention = 900À´¸ü¸Ä
UNDO_SUPRESS_ERRORS = true      --ÔÚ×Ô¶¯Ä£Ê½ÏÂÊÖ¶¯¹ÜÀí»¹Ô­¶ÎÊÇÊÇ·ñ±¨´í,TRUEΪºöÂÔ´íÎó.²»»áÓиºÃæÓ°Ïì. Òà¿ÉÓÃALTER SESSION SET UNDO_SUPRESS_ERRORS = flaseÀ´±ä¸ü ´´½¨»¹Ô­±í¿Õ¼ä
CREATE UNDO TABLESPACE abc_undo DATAFILE 'c:\abc_undo.dbf' SIZE 20M; ÆäËû±í¿Õ¼ä²Ù×÷ÓëÆäËû±í¿Õ¼äÏàͬ,ΪÁ˿ռ乻ÓÃ×îºÃ½«»¹Ô­±í¿Õ¼äÉèΪ×Ô¶¯ÍØÕ¹. Çл»»¹Ô­±í¿Õ¼ä
ALTER SYSTEM SET UNDO_TABLESPACE = 'abc_undo' ɾ³ý»¹Ô­±í¿Õ¼ä,×¢Òâ²»ÄÜɾ³ýµ±Ç°»¹Ô­±í¿Õ¼ä
DROP TABLESPACE abc_undo; ²é¿´µ±Ç°»¹Ô­¶Î×´¿ö
SELECT name, value from v$parameter WHERE name LIKE '%undo%'; »ñÈ¡»¹Ô­Êý¾ÝÐÅÏ¢
a.) »ñÈ¡»¹Ô­Êý¾Ýͳ¼ÆÐÅÏ¢
SELECT TO_CHAR(begin_time, 'HH:MM:SS') begin_time, TO_CHAR(end_time, 'HH:MM:SS') end_time, undoblks, txncount, maxquerylen from v$undostat;
     ÆäÖÐundoblksΪ¸Ãʱ¼ä¶ÎÄÚÏûºÄµÄ»¹Ô­Êý¾Ý¿éÊýÁ¿,txncountΪ¸Ãʱ¼ä¶ÎÖÐÊÂÎñµÄ×ÜÊý, maxquerylenΪ¸Ãʱ¼ä¶ÎÖÐÖ´ÐÐ×µÄ²éѯ(ÃëÊý).
b.)»¹¿ÉÒÔʹÓÃÒÔϸ÷ÊÓͼ»ñÈ¡ÓÐÓÃÐÅÏ¢
     dba_tablespaces, dba_data_files, dba_rollback_segs, v$rollname, v$rollstat, v$session, v$transaction


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

Oracle Êý¾Ý¿â¹ÜÀí½Å±¾ ÃüÃû¹æ·¶


    
      Oracle ÖеÄÊý¾Ý×ÖµäÊÇÊý¾Ý¿âÖеķdz£ÖØÒªµÄÒ»²¿·Ö£¬ÌṩÁËÏà¹ØÊý¾Ý¿âµÄÐÅÏ¢£¬ËüÊÇËùÓРOracle Óû§£¨´ÓÓ¦ÓõÄ×îÖÕÓû§¡¢Ó¦ÓõÄÉè¼Æ¿ª·¢Õßµ½Êý¾Ý¿â¹ÜÀíÔ±£©µÄ·Ç³£ÖØÒªµÄÐÅÏ¢À´Ô´¡£Êý¾Ý×ÖµäµÄ´´½¨£¬ÊÇÔÚ Oracle Êý¾Ý¿â´´½¨Íê±Ïºó£¬ÔË ......

ORACLEÖ´Ðмƻ®µÄһЩ»ù±¾¸ÅÄî

 
Ò»£®Ïà¹ØµÄ¸ÅÄî
RowidµÄ¸ÅÄrowidÊÇÒ»¸öαÁУ¬¼ÈÈ»ÊÇαÁУ¬ÄÇôÕâ¸öÁоͲ»ÊÇÓû§¶¨Ò壬¶øÊÇϵͳ×Ô¼º¸ø¼ÓÉϵġ£¶Ôÿ¸ö±í¶¼ÓÐÒ»¸örowidµÄαÁУ¬µ«ÊÇ
±íÖв¢²»ÎïÀí´æ´¢ROWIDÁеÄÖµ¡£²»¹ýÄã¿ÉÒÔÏñʹÓÃÆäËüÁÐÄÇÑùʹÓÃËü£¬µ«ÊDz»ÄÜɾ³ý¸ÄÁУ¬Ò²²»ÄܶԸÃÁеÄÖµ½øÐÐÐ޸ġ¢²åÈë¡£Ò»µ©Ò»ÐÐÊý¾Ý²åÈëÊý¾Ý¿â£¬Ôò
rowidÔÚ¸ÃÐ ......

Oracle¿ìÕÕ

 --Ãû´Ê˵Ã÷£ºÔ´——±»Í¬²½µÄÊý¾Ý¿â
            Ä¿µÄ——Ҫͬ²½µ½µÄÊý¾Ý¿â
ǰ6²½±ØÐëÖ´ÐÐ,µÚ6ÒÔºóÊÇһЩ¸¨ÖúÐÅÏ¢.
--1¡¢ÔÚÄ¿µÄÊý¾Ý¿âÉÏ£¬´´½¨dblink
drop public database link dblink_orc92_182;
Create public DATABASE LINK dbl ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ