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 RAC»·¾³ÖУ¬ÏµÍ³ÐÔÄÜ»áÊܵ½Ó°Ï죬Ö÷Òª¼¯ÖÐÔÚBlockÔÚinstanceÖ®¼äµÄ´«Ê䣬¾¡¹Üoracle 10g ÖвÉÓÃÁËCache FusionÀ´¸ÄÉÆÒÔÇ°ÖØdiskÖжÁÈ¡Êý¾Ý¡£ÆäÖеÄÒ»¸ö²¿·Ö¾ÍÊǹØÓÚoracle sequenceµÄÐÔÄÜÎÊÌâ
ÏÂÃæÊǹØÓÚsequence µÄcacheºÍorder¶Ôrac ÐÔÄܵÄÓ°Ï죬´Ó²âÊÔÖп´µ½Ôö´ócacheºÍ²ÉÓÃnon-orderedµÄsequenceÐÔÄÜÊܵ½µÄÓ° ......
½ñÌìдÓйØOracleÖк¯ÊýÓë´¥·¢Æ÷µÄÄÚÈÝ£¬ÔÚÊý¾Ý¿âÖж¨Ò岢ʹÓô洢¹ý³Ì¡¢º¯Êý¡¢´¥·¢Æ÷£¬¿ÉÒÔÌá¸ßÓû§·ÃÎÊÊý¾Ý¿âµÄЧÂÊ¡£
Êý¾Ý¿âÖк¯Êý°üº¬Ëĸö²¿·Ö£ºÉùÃ÷¡¢·µ»ØÖµ¡¢º¯ÊýÌåºÍÒì³£´¦Àí¡£
1 create or replace function getname(sno varchar2 )
2 &nbs ......
MS SQL ÖеÄIsNull()º¯Êý£º
IsNull ( check_expression , replacement_expression )
check_expression: ¿ÉÒÔÊÇÈκÎÀàÐÍ,½«Òª¼ì²éµÄ±í´ïʽ ²»Îª¿Õ£¬·µ»ØËü
replacement_expression: ÀàÐͱØÐëºÍcheck_expressionÏàͬ£¬check_expressionΪnull£¬·µ»ØËü
Õâ¸öº¯ÊýµÄ×÷ÓþÍÊÇ£ºÅжÏcheck_expressionÊÇ·ñΪ¿Õ£¬Îª¿Õ¾Í·µ» ......
ÏÔʾOracle²é¿´·ÖÇø±íÐÅÏ¢
ÏÔʾÊý¾Ý¿âËùÓзÖÇø±íµÄÐÅÏ¢£ºDBA_PART_TABLES
ÏÔʾµ±Ç°Óû§¿É·ÃÎʵÄËùÓзÖÇø±íÐÅÏ¢£ºALL_PART_TABLES
ÏÔʾµ±Ç°Óû§ËùÓзÖÇø±íµÄÐÅÏ¢£ºUSER_PART_TABLES
ÏÔʾOracle²é¿´·ÖÇø±íÐÅÏ¢ ÏÔʾÊý¾Ý¿âËùÓзÖÇø±íµÄÏêϸ·ÖÇøÐÅÏ¢£ºDBA_TAB_PARTITIONS
ÏÔʾµ±Ç°Óû§¿É·ÃÎʵÄËùÓзÖÇø±íµÄÏêϸ·ÖÇøÐÅÏ¢£ ......