oracle »ØÍ˶Îά»¤
»Ø¹ö¶ÎÓÃÓÚ¶ÔÊý¾Ý¿âÐÞ¸Äʱ, ±£´æÔÓеÄÊý¾Ý, ÒÔ±ãÉÔºó¿ÉÒÔͨ¹ýʹÓÃROLLBACKÀ´»Ö¸´µ½ÐÞ¸ÄǰµÄÊý¾Ý; ÁíÍâ, »Ø¹ö¶Î¿ÉÒÔΪÊý¾Ý¿âÖеÄËùÓнø³ÌÌṩ¶ÁÒ»ÖÂÐÔ. Òò´Ë, »Ø¹ö¶ÎÉèÖõĺÏÀíÓë·ñ, Ö±½ÓÓ°Ïìµ½Êý¾Ý¿âµÄÐÔÄÜ.
»Ø¹ö¶ÎµÄά»¤¼°²éѯ
(1) ´´½¨»Ø¹ö¶Î
__CREATE ROLLBACK SEGMENT RB01
__TABLESPACE RBS1
__STORAGE (
____INITIAL 100K
____NEXT 100K
____MINEXTENTS 20
____MAXEXTENTS 100
____OPTIMAL 2000K );
2) ¸ü¸ÄONLINE/OFFLINE״̬
__ALTER ROLLBACK SEGMENT RB01 ONLINE;
__ALTER ROLLBACK SEGMENT RB01 OFFLINE;
(3) ¸ü¸ÄOPTIMAL²ÎÊý
__ALTER ROLLBACK SEGMENT RB01
__STORAGE ( MAXEXTENTS 200
____OPTIMAL 2048K );
(4) ËõС»Ø¹ö¶Î
__ALTER ROLLBACK SEGMENT RB01 SHRINK;
(ÓÐOPTIMAL²ÎÊýʱ, ËõСµ½OPTIMALÖµ; ûÓÐOPTIMAL²ÎÊýʱ, ËõСµ½MINEXTENTSËù¶ÔÓ¦µÄ³ß´ç)
__ALTER ROLLBACK SEGMENT RB01 SHRINK TO 2048K;
(5) ÐÞ¸ÄINITIAL/NEXT²ÎÊý
*** ½¨Òé5: ¸ù¾ÝÔÔò3, ÐÞ¸ÄNEXTʱ, ×ÜÓ¦¸ÃͬʱÐÞ¸ÄINITIAL.
INITIAL²ÎÊýÎÞ·¨Ö±½ÓÐÞ¸Ä, Ö»ÄÜÏÈDROP, È»ºóÔÙCREATE.
__DROP ROLLBACK SEGMENT RB01;
__CREATE ROLLBACK SEGMENT RB01
__TABLESPACE RBS1
__STORAGE ( INITIAL 100K
____NEXT 100K
____MINEXTENTS 20
____MAXEXTENTS 121
____OPTIMAL 2000K )
(6) ÔÚÊÂÎñÖÐʹÓÃÌØ¶¨µÄ»Ø¹ö¶Î
__SET TRANSACTION USE ROLLBACK SEGMENT RB_LARGE1;
(7) ³£ÓõÄÓйػعö¶ÎµÄϵͳÊý¾Ý×Öµä
DBA_ROLLBACK_SEGS (Ïà¹Ø±í:DBA_SEGMENTS)
V$ROLLNAME
V$ROLLSTAT
V$TRANSACTION (Ïà¹Ø±í: V$SESSION)
Óйػعö¶ÎµÄ³£¼û´íÎó¼°½â¾ö·½·¨
(1) »Ø¹ö¶Î¿Õ¼ä²»¹»
ORA-01562 - failed to extend rollback segment number string
»Ø¹ö¶Î¿Õ¼ä²»¹»µÄÔÒòÒ»°ãÓÐÒÔϼ¸ÖÖÇé¿ö:
A. »Ø¹ö¶ÎËùÔÚ±í¿Õ¼äÊ£ÓàµÄ¿ÕÏпռä̫С, ÎÞ·¨·ÖÅäÏÂÒ»¸öEXTENT.
B. »Ø¹ö¶ÎÀ©Õ¹´ÎÊýÒѾ´ïµ½MAXEXTENTSÏÞÖÆ
½â¾ö·½·¨:
A. À©´ó»Ø¹ö¶ÎËùÔÚ±í¿Õ¼ä
B. ÉèÖýϴóµÄMAXEXTENTS²ÎÊý
C. Ϊ»Ø¹ö¶ÎÉèÖÃOPTIMAL²ÎÊý
D. ÓýϴóµÄEXTENT²ÎÊýÖØÐ´´½¨»Ø¹ö¶Î
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/tianzhichengzhr/archive/2009/11/06/4776380.aspx
Ïà¹ØÎĵµ£º
ÔÚ°²×°ÍêOracle 10gÖ®ºó£¬Ïë´ò¿ªsql*plusÀ´Ñ§Ï°£¬È»ºó°´ÕÕÊéÉϵIJ½ÖèÓÃscottÓû§À´Á¬½ÓÊý¾Ý¿â£¬¿ÉÊäÁ˺ü¸´Î¶¼Ìáʾһ¸ö´íÎó¡£
¡¡¡¡error£º the account is locked
¡¡¡¡È»ºóÉÏÍø²éÁËÒ»ÏÂÖ®ºó·¢ÏÖÕâ¸öÓû§±»Ëø¶¨ÁË£¬ÖÁÓÚËüΪʲô±»Ëø¶¨£¬¿ÉÄÜÊÇÏÂÃæ¼¸¸öÔÒò¡£
¡¡¡¡1.³¢ÊÔ¶à´ÎµÇ¼δ³É¹¦.(¿ÉÄÜÃÜÂë²»ÕýÈ·)
¡¡¡¡2.´ËÓû§±»¹ ......
oracle ÖÁ½ñûÓÐÍÆ³öÕë¶Ôwin7µÄ°æ±¾£¬ÎÞÄÎ֮ϲéÑ¯ÍøÂç£¬ÍøÉÏ´óϺ±íʾÐÞ¸Ärefhost.xmlÎļþ¼´¿É¡£
½øÈë×Ô¼ºÊµÕ½½×¶Î£¬´Óoracle¹Ù·½ÏÂÔØoracle 10g for vista and windows2K8 x86°æ(for windowsÊÇÖ§³ÖvistaÄں˵ģ¬win7µÄÄÚºËÓë2008ÒÔ¼°vistaµÄÄÚºËÊÇÒ»Ñù)¡£
Ïȵã»÷°²×°£¬ÔÚ°²×°µÄ°æ±¾¼ì²âʱÌáʾĿǰoracle²»Ö§³ÖversionΪ6 ......
רÓÐģʽ£º
ÔÚרÓзþÎñÆ÷ÅäÖÃÖУ¬OracleΪÿ¸öÁ¬½Óµ½·þÎñÆ÷µÃ¿Í»§»úÆô¶¯Ò»¸öרÓ÷þÎñÆ÷½ø³Ì¡£Ò»¸ö¿Í»§»úµÄרÓ÷þÎñÆ÷½ø³ÌֻΪ´Ë¿Í»§»ú¹¤×÷¡£¸÷רÓ÷þÎñÆ÷½ø³ÌÍêÈ«¶ÀÁ¢£¬ÎÞÐè¹²ÏíÊý¾Ý¡£ÔÚÓû§»á»°´æÔÚµÄÕû¸ö¹ý³ÌÖУ¬ÏàÓ¦µÄרÓ÷þÎñÆ÷½ø³ÌÒ»Ö±´æÔÚ£¬²»ÂÛÓû§ÊÇ·ñ»î¶¯¡£Ö±µ½Óû§»á»°ÖÕÖ¹ºó£¬¸ÃÓ¦ÓõÄרÓ÷þÎñÆ÷½ø³Ì²ÅÖÕÖ¹¡£ÔÚ ......
·½Ê½Ò».
Ö´ÐÐÒÔÏÂsqlÓï¾ä´´½¨database link
create database link test_link --Á´½ÓÃû
connect to Óû§Ãû identified by ÃÜÂë
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Êý¾Ý¿â·þÎ ......