oracleÊý¾Ý²Ö¿âÖÐÈýÖÖÓÅ»¯
¶ÔÓÚÎÒÃÇÕâ¸öÏîÄ¿À´Ëµ£¬Êý¾Ý¿âµÄ´æÈ¡µÄÐÔÄܾö¶¨ÁËÊý¾ÝÌṩµÄÐÔÄÜ¡£ÓÅ»¯µÄ´óÖµÄÔÀíÖ»ÓÐÁ½¸ö£ºÒ»ÊÇÊý¾Ý·Ö¿é´æ·Å£¬±ãÓÚÊý¾ÝµÄת´¢ºÍ¹ÜÀí£»¶þÊÇÖм䴦Àí£¬Ìá¸ßÊý¾ÝÌṩµÄËÙ¶È¡£
»ùÓÚÉÏÃæÁ½¸ö¸ù±¾µÄÔÀí£¬½èÖúÓÚÊý¾Ý²Ö¿âµÄ¸ÅÄÁоÙÊý¾Ý¿âµÄÓÅ»¯·½Ê½£º
1£® ·ÖÇø
ÔÚÊý¾Ý²Ö¿âÖУ¬ÊÂʵ±í£¬Ë÷Òý±í£¬Î¬¶È±í·Ö´¦ÓÚÈý¸ö²»Í¬µÄ±í¿Õ¼äµ±ÖУ¨ÔÚ²¿ÊðµÄʱºò£¬×îºÃÊDz¿Êðµ½²»Í¬µÄ´ÅÅÌÉÏ£©¡£ÕâÑù×Ó×öµÄÔÒò¾ÍÊDZãÓÚ²¢·¢²Ù×÷£¬ÆäʵÊý¾Ý²Ö¿âºÍÆÕͨµÄÊý¾Ý¿âÖ®¼äûÓÐÑϸñµÄ½çÏÞ£¬Ö÷Òª»¹ÊDz¿ÊðÉÏ£¬µ±È»oracle±¾Éí»áΪÊý¾Ý²Ö¿âÖеēÊÂʵ±í”Éú³É“֪ʶ¿â”µÈ²Ù×÷£¬±£Ö¤¸ü¿ìµÄÊý¾ÝÌṩЧÂÊ£¬Æäʵ¿ÉÒÔ½èÖúÓÚjobºÍÍⲿ³ÌÐòÀ´µ÷¶È´æ´¢¹ý³ÌʵÏÖ¡£»ùÓÚÕâ¸ö˼·£¬±¾ÏîÄ¿Êý¾Ý¿âÖеÄË÷Òý½«ºÍÊÂʵ±í·Ö¿ªÎ¬»¤£¬µ±È»Õâ³Æ²»ÉÏ·ÖÇø£¨£©¡£ÕæÕýµÄ·ÖÇøÊÇÖ¸ÏÂÃæµÄÄÚÈÝ¡£
·ÖÇø¾ÍÊÇpartition/subpartition£¬¶ÔÓÚÊÂʵ±í±¾ÉíÀ´Ëµ£¬ÒÔÔÂΪµ¥Î»×÷partition¹ÒÔØµ½²»Í¬±í¿Õ¼äÉÏ¡£¾ßÌåµÄʾÀýÈçÏ£º
create table T_LOGNODE_RECORD
(
……
CALLIN_HH NUMBER(2) not null,
CALLIN_DD NUMBER(2) not null,
CALLIN_MONTH NUMBER(2) not null,
CALLIN_YEAR NUMBER(4) not null,
MONTH_MOD NUMBER(1) not null
)
PARTITION BY LIST (MONTH_MOD)
(
PARTITION P0 VALUES (0) TABLESPACE TS0,
PARTITION P1 VALUES (1) TABLESPACE TS1,
PARTITION P2 VALUES (DEFAULT) TABLESPACE TS2
);
ÉÏÊöµÄ´úÂëÖÐÒÔMONTH_MOD×Ö¶Î×÷Ϊ·ÖÇø±ê×¼£¬½«T_LOGNODE_RECORD·Öµ½Èý¸ö²»Í¬µÄ±í¿Õ¼ä£¨TS0£¬TS1£¬TS2£©ÖУ¬ÕâÀïÓÐÒ»¸ö¼¼ÇÉ£¬MONTH_MOD = Ô·Ýmod3,ÕâÑù×Ó¿ÉÒÔ²»ÐèÒªÈ˹¤µÄά»¤ÄĸöÔ·ÖÈëÄĸö·ÖÇø¡£µ±È»¼òµ¥µÄÒÔÔÂ×÷Ϊ·ÖÇøÖ®ºó£¬¶ÔÓÚÎÒÃǵ±Ç°µÄÊý¾Ý¿âÀ´Ëµ»¹ÊÇÔ¶Ô¶²»¹»µÄ£¬ÒòΪ¼´Ê¹ÊÇÒ»¸öÔµÄÊý¾ÝÒÀÈ»ÊǺܾ޴óµÄ£¬ÄÇôÐèÒªÎÒÃÇ×öSUBPARTITION£¬×ö·¨µÄʾÀýΪ£º
create table T_LOGNODE_RECORD
(
……
CALLIN_DD NUMBER(2) not null,
MONTH_MOD NUMBER(1) not null
)
PARTITION BY RANGE(MONTH_MOD)
SUBPARTITION BY LIST(CALLIN_DD)
SUBPARTITION TEMPLATE
(
SUBPARTITION SUBP1 values (1),
SUBPARTITION SUBP2 values (2),
SUBPA
Ïà¹ØÎĵµ£º
ÏîÄ¿ÖÐÓÐһЩ±¨±í£¬±¾ÉíËٶȾͲ»Ì«¿ì£¬Óöµ½Êý¾ÝÁ¿´óµÄÇé¿ö£¬¸üÊÇÈÃÈË×¥¿ñ£¬Óû§Ò²Ìá³öÁ˱¨±íËÙ¶ÈÂýµÄÎÊÌ⣬ÓÚÊÇÏë×ÅÈçºÎʵÏÖ±¨±íµÄÊý¾ÝÒÀÀµ»º´æ£¬¼´½«±¨±íÊý¾Ý»º´æ£¬µ±Êý¾Ý·¢Éú¸Ä±äʱ£¬ÔÙÖØÐ»ñÈ¡Êý¾Ý¡£
×î¼òµ¥µÄ·½·¨£¬ÊÇÔÚÏÔʾ±¨±íµÄaspxÒ³ÃæµÚÒ»ÐмÓÉÏÐÎÈç<%@ OutputCache Duration="600" VaryByParam="some_par ......
http://www.anysql.net/oracle/oracle_olap_dimension.html
ÔÚOracleµÄÊý¾Ý²Ö¿â(OLAP)ÖÐ, ʵÌ廯ÊÓͼ(MVIEW), ²éÑ¯ÖØÐ´(Query Rewrite)ºÍά(Dimension)ÊǷdz£ÖØÒªµÄÓÅ»¯ÊÖ¶Î, ¶ÔÓÚǰÁ½ÕßÎÒ²»ÏëÔÚÕâ¶ùÖØ¸´½²ÁË, Ö÷ÒªÀ´ÌåÑéÒ»ÏÂάµÄ×÷ÓÃ. Òª·¢»ÓάµÄ×÷ÓÃ, »¹ÊÇÐèÒªÓõ½Ç°ÃæÁ½Õß, ÏÂÃæÊÇÎÒÉè¼ÆµÄÖ»ÓÐÒ»¸öά±íµÄ×î¼òµ¥µÄÀý×Ó ......
ת×Ô£ºhttp://www.cnblogs.com/houxm/archive/2009/08/26/1554481.html
Ïê½â£ºhttp://sunwayle.blog.51cto.com/114995/102516
Oracle »ØÊÕÕ¾¹¦ÄÜ,³¹µ×ɾ³ý±í
Oracle 10g
ÖгöÏÖ±íÃû£ºBIN$2cMp4FjwQ2Cw3Lj+BxLYTw==$0
×î½ü·¢ÏÖOracleÖгöÏÖÁËÕâÐ©Ææ¹ÖµÄ±íÃû£¬ÉÏÍø²éÕÒºó·¢ÏÖÊÇoracle10gµÄ»ØÊÕÕ¾¹¦ÄÜ£¬²¢Ã»Óг¹µ×µÄɾ³ ......
Checkpoint
ºÜ¶àÈ˶¼°ÑcheckpointµÄ¸ÅÄî¸ø¸´ÔÓ»¯ÁË£¬ÆäʵcheckpointÕâ¸öÊý¾Ý¿â¸ÅÄîÒýÈëµÄÕæÕýÒâÒå¾ÍÊÇÓÃÀ´¼õÉÙÔÚÊý¾Ý¿â
»Ö¸´¹ý³ÌÖÐËù»¨µÄʱ¼ä(instance recovery),ÄÇôcheckpointÊÇÓÉËÀ´×öµÄÄØ?ÎÒÃǶ¼ÖªµÀÊý¾Ý¿âÖÐÓиöCKPT½ø³Ì£¬ÕâÊǸö
¿ÉÑ¡½ø³Ì£¬µ«ÊÇÕæÕýÖ´Ðмì²éµãµÄÈÎÎ ......