OracleÌṩÁË·ÖÇø¼¼Êõ(»ã×ÜÌû)
OracleÌṩÁË·ÖÇø¼¼ÊõÒÔÖ§³ÖVLDB(Very Large DataBase)¡£·ÖÇø±íͨ¹ý¶Ô·ÖÇøÁеÄÅжϣ¬°Ñ·ÖÇøÁв»Í¬µÄ¼Ç¼£¬·Åµ½²»Í¬µÄ·ÖÇøÖС£·ÖÇøÍêÈ«¶ÔÓ¦ÓÃ͸Ã÷¡£
OracleµÄ·ÖÇø±í¿ÉÒÔ°üÀ¨¶à¸ö·ÖÇø£¬Ã¿¸ö·ÖÇø¶¼ÊÇÒ»¸ö¶ÀÁ¢µÄ¶Î£¨SEGMENT£©£¬¿ÉÒÔ´æ·Åµ½²»Í¬µÄ±í¿Õ¼äÖС£²éѯʱ¿ÉÒÔͨ¹ý²éѯ±íÀ´·ÃÎʸ÷¸ö·ÖÇøÖеÄÊý¾Ý£¬Ò²¿ÉÒÔͨ¹ýÔÚ²éѯʱֱ½ÓÖ¸¶¨·ÖÇøµÄ·½·¨À´½øÐвéѯ¡£
·ÖÇøÌṩÒÔÏÂÓŵ㣺
ÓÉÓÚ½«Êý¾Ý·ÖÉ¢µ½¸÷¸ö·ÖÇøÖУ¬¼õÉÙÁËÊý¾ÝË𻵵ĿÉÄÜÐÔ£»
¿ÉÒÔ¶Ôµ¥¶ÀµÄ·ÖÇø½øÐб¸·ÝºÍ»Ö¸´£»
¿ÉÒÔ½«·ÖÇøÓ³Éäµ½²»Í¬µÄÎïÀí´ÅÅÌÉÏ£¬À´·ÖÉ¢IO£»
Ìá¸ß¿É¹ÜÀíÐÔ¡¢¿ÉÓÃÐÔºÍÐÔÄÜ¡£
OracleÌṩÁËÒÔϼ¸ÖÖ·ÖÇøÀàÐÍ£º
·¶Î§·ÖÇø£¨range£©£»
¹þÏ£·ÖÇø£¨hash£©£»
Áбí·ÖÇø£¨list£©£»
·¶Î§£¹þÏ£¸´ºÏ·ÖÇø£¨range-hash£©£»
·¶Î§£ÁÐ±í¸´ºÏ·ÖÇø£¨range-list£©¡£
OracleµÄÆÕͨ±íûÓа취ͨ¹ýÐÞ¸ÄÊôÐԵķ½Ê½Ö±½Óת»¯Îª·ÖÇø±í£¬±ØÐëͨ¹ýÖؽ¨µÄ·½Ê½½øÐÐת±ä£¬ÏÂÃæ½éÉÜÈýÖÖЧÂʱȽϸߵķ½·¨£¬²¢ËµÃ÷ËüÃǸ÷×ÔµÄÌص㡣
·½·¨Ò»£ºÀûÓÃÔ±íÖؽ¨·ÖÇø±í¡£
²½Ö裺
SQL> CREATE TABLE T (ID NUMBER PRIMARY KEY, TIME DATE);
±íÒÑ´´½¨¡£
SQL> INSERT INTO T SELECT ROWNUM, CREATED from DBA_OBJECTS;
ÒÑ´´½¨6264ÐС£
SQL> COMMIT;
Ìá½»Íê³É¡£
SQL> CREATE TABLE T_NEW (ID, TIME) PARTITION BY RANGE (TIME)
2 (PARTITION P1 VALUES LESS THAN (TO_DATE('2004-7-1', 'YYYY-MM-DD')),
3 PARTITION P2 VALUES LESS THAN (TO_DATE('2005-1-1', 'YYYY-MM-DD')),
4 PARTITION P3 VALUES LESS THAN (TO_DATE('2005-7-1', 'YYYY-MM-DD')),
5 PARTITION P4 VALUES LESS THAN (MAXVALUE))
6 AS SELECT ID, TIME from T;
±íÒÑ´´½¨¡£
SQL> RENAME T TO T_OLD;
±íÒÑÖØÃüÃû¡£
SQL> RENAME T_NEW TO T;
±íÒÑÖØÃüÃû¡£
SQL> SELECT COUNT(*) from T;
COUNT(*)
----------
6264
SQL> SELECT COUNT(*) from T PARTITION (P1);
COUNT(*)
----------
0
SQL> S
Ïà¹ØÎĵµ£º
Ó¦¸¶Ä£¿éµÄ¶àÊýÒµÎñ»ùÓڲɹººÍ¿â´æµÄ²Ù×÷£¬Òò´ËÓ¦¸¶Ä£¿éµÄÔ½áÓ¦¸ÃÔڲɹºÄ£¿éºÍ¿â´æÄ£¿éÔ½áºó²ÅÄܹرջá¼ÆÆÚ¡£
Ô½ᲽÖè
ÔÚÿ¸ö»á¼ÆÆÚÄ©£¬Ó¦¸¶Ä£¿éµÄÔ½áÓ¦×ñÑÒÔÏÂÁ÷³Ì£º
1.¼ì²éÒµÎñÊÇ·ñÈ«²¿Â¼Èë;
2.¼ì²éÊÇ·ñÓÐδÑéÖ¤¡¢Ôݹҷ¢Æ±;
3.¸üе½ÆÚµÄÔ¶ÆÚ¸¶¿î״̬;
4.¼ì²éÓ¦¸¶ÒµÎñÊÇ·ñÉú³É·Ö¼;
5.Ó¦¸¶ÒµÎñ´«Ë͵½×ÜÕÊ;
6 ......
²éѯijÁÐֵΪnullµÄ¼Ç¼£º
select *
from tablename
where col is null;
²éѯijÁÐÖµ²»ÎªnullµÄ¼Ç¼£º
select *
from tablename
where col is not null;
Õë¶ÔnullµÄ+-*/=!=µÈ²Ù×÷¶¼ÊÇnull£º
null±íʾ²»È·¶¨µÄÖµ£¬Á½¸önull±íʾÁ½¸ö²»È·¶¨µÄÖµ¡¢Î´ÖªµÄÖµ£¬Òò´Ë²»´æÔÚÁ½¸önullµÄÏàµÈ£¬Í ......
ʹÓÃsdeupgradeora9iÓ¦ÓóÌÐòÉý¼¶ºó£¬ÔÙ°´ÕÕÒ»°ãµÄpost·½·¨post,ÔÚÌîдnet service nameʱ£¬Ê¹ÓÃoracle¿Í»§¶ËµÄ net manager ÅäÖÃÒ»¸öÁíһ̨oracleÊý¾Ý¿âµÄservice name;ÆäÓà°´ÕÕ Ò»°ã·½·¨½øÐУ¬PostÍê³Éºó£¬ÐÞ¸Ä$sdehome/dbinit.sde
set ORACLE_SID = ORCL;Ϊ
set LOCLA=service name;
Æô¶¯·þÎñ¼´¿É¡£ ......
analyze table tablename compute statistics;
analyze index indexname compute statistics;
¶ÔÓÚʹÓÃCBOºÜÓкô¦£¬¿ÉÒÔʹÓøü¿É¿¿µÄtableÐÅÏ¢£¬´Ó¶øÖ´Ðмƻ®Ò²¿ÉÒÔ¸ü׼ȷһЩ£¬ÔÚ10g»á×Ô¶¯analyze£¬Ö®Ç°µÄ°æ±¾ÐèÒªÊÖ¶¯¶¨ÆÚ
Éú³Éͳ¼ÆÐÅÏ¢,,Ñ¡ÔñºÏÀíµÄÖ´Ðмƻ®..
OracleµÄonline documentÕâÑùÃèÊöanalyzeµÄ×÷Óãº
Use ......