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
Ïà¹ØÎĵµ£º
ÔËÐÐÁËOracleµÄLinux·þÎñÆ÷¸ü¸ÄÖ÷»úÃû
¼ÙÈçÒª°ÑÖ÷»úÃû¸ÄΪoratest¡£
$±íʾoracleÓû§²Ù×÷£»
#±íʾrootÓû§²Ù×÷¡£
DB£ºoracle10.2
OS£ºRHEL4.5
µÚÒ»²½£¬¹Ø±ÕÊý¾Ý¿âºÍ¼àÌý£¬dbconsole£º
$ dbshut
$ lsnrctl stop
µÚ¶þ²¿£º
# hostname oratest
µÚÈý²½£º
# vi /etc/sysconfig/network
¸ü¸Ähostname²ÎÊý¡£
µÚËIJ½ ......
1¡¢²é¿´±í¿Õ¼äµÄÃû³Æ¼°´óС
¡¡¡¡select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size
¡¡¡¡from dba_tablespaces t, dba_data_files d
¡¡¡¡where t.tablespace_name = d.tablespace_name
¡¡¡¡group by t.tablespace_name;
¡¡¡¡
¡¡¡¡2¡¢²é¿´±í¿Õ¼äÎïÀíÎļþµÄÃû³Æ¼°´óС
¡¡¡¡select tablespace_ ......
ÏÂÃæ°´Àà±ðÁгöһЩORACLEÓû§³£ÓÃÊý¾Ý×ÖµäµÄ²éѯʹÓ÷½·¨¡£
Ò»¡¢Óû§
²é¿´µ±Ç°Óû§µÄȱʡ±í¿Õ¼ä
SQL>select username,default_tablespace from user_users;
²é¿´µ±Ç°Óû§µÄ½ÇÉ«
SQL ......
Checkpoint
ºÜ¶àÈ˶¼°ÑcheckpointµÄ¸ÅÄî¸ø¸´ÔÓ»¯ÁË£¬ÆäʵcheckpointÕâ¸öÊý¾Ý¿â¸ÅÄîÒýÈëµÄÕæÕýÒâÒå¾ÍÊÇÓÃÀ´¼õÉÙÔÚÊý¾Ý¿â
»Ö¸´¹ý³ÌÖÐËù»¨µÄʱ¼ä(instance recovery),ÄÇôcheckpointÊÇÓÉËÀ´×öµÄÄØ?ÎÒÃǶ¼ÖªµÀÊý¾Ý¿âÖÐÓиöCKPT½ø³Ì£¬ÕâÊǸö
¿ÉÑ¡½ø³Ì£¬µ«ÊÇÕæÕýÖ´Ðмì²éµãµÄÈÎÎ ......
-- Create the user
create user SMCQUERY
identified by SMCQUERY;
-- Grant/Revoke role privileges
grant connect to SMCQUERY;
-- Grant/Revoke system privileges
grant select any table to SMCQUERY;
grant debug any procedure to SMCQUERY;
grant debug connect session to SMCQUERY;
grant cr ......