Oracle ¾Û¼¯
http://blog.csdn.net/junmail/archive/2009/07/29/4392264.aspx
¾Û¼¯(cluster)ÊÇ´æ´¢±íÊý¾ÝµÄ¿ÉÑ¡ÔñµÄ·½·¨¡£Ò»¸ö¾Û¼¯ÊÇÒ»×é±í£¬½«¾ßÓÐͬһ¹«¹²ÁÐÖµµÄÐд洢ÔÚÒ»Æ𣬲¢ÇÒËüÃǾ³£Ò»ÆðʹÓá£ÕâЩ¹«¹²Áй¹³É¾Û¼¯Âë¡£
¾³£±»Í¬Ê±·ÃÎʵıíÔÚÎïÀíλÖÃÉÏ¿ÉÒÔ´æ´¢ÔÚÒ»Æð¡£ÎªÁ˽«ËüÃÇ´æ´¢ÔÚÒ»Æ𣬾ÍÒª´´½¨Ò»¸ö´Ø( c l u s t e r )À´¹ÜÀíÕâЩ±í¡£±íÖеÄÊý¾ÝÒ»Æð´æ´¢ÔÚ´ØÖУ¬´Ó¶ø×îС»¯±ØÐëÖ´ÐеÄI / O´ÎÊý£¬¸ÄÉÆϵͳÐÔÄÜ¡£
±íÖÐÏà¹ØµÄÁгÆΪ´Ø¼ü(cluster key)¡£´Ø¼üÓÃÒ»¸ö´ØË÷Òý(cluster index)À´½øÐÐË÷Òý£»¶ÔÓÚ´ØÖеĶà¸ö±í£¬´Ø¼üÖµÖ»´æ´¢Ò»´Î¡£ÔÚ°ÑÈκÎÐвåÈë´ØµÄ±íÖÐ֮ǰ£¬¶¼±ØÐëÏÈ´´½¨Ò»¸ö´ØË÷Òý¡£¶ÔÓÚ¾³£Æµ·±Ò»Æð²éѯµÄ±í˵£¬Ê¹ÓôرȽϷ½±ã¡£ÔÚ´ØÖУ¬À´×Ô²»Í¬±íµÄÐд洢ÔÚͬһ¸ö¿éÖУ»Òò´Ëͬ½«±í·Ö¿ª´æ´¢Ïà±È£¬Á¬½ÓÕâЩ±íµÄ²éѯ¾Í¿ÉÄÜÖ´ÐиüÉÙµÄI / O¡£²»¹ý£¬Óë¶Ô·Ç¡£´Ø±íµÄÏàͬ²Ù×÷±È½Ï£¬´Ø±íµÄ²åÈë¡¢¸üкÍɾ³ýÐÔÄÜÒª²îºÜ¶à¡£Ôھ۴رí֮ǰ£¬ÒªÅжϹ²Í¬²éѯÕâЩ±íµÄƵÂÊ¡£Èç¹ûÕâЩ±í×ÜÊÇÒ»Æð²éѯ£¬¾ÍÒª¿¼ÂÇ°ÑËüÃǺϲ¢³ÉÒ»¸ö±í¶ø²»ÊǾ۴ØÁ½¸ö±í¡£
Examples
1¡¢Creating a Cluster: Example
The following statement creates a cluster named personnel with the cluster key column department, a cluster size of 512 bytes, and storage parameter values:
CREATE CLUSTER personnel
(department NUMBER(4))
;
2¡¢Cluster Keys: Example
The following statement creates the cluster index on the cluster key of personnel:
CREATE INDEX idx_personnel ON CLUSTER personnel;
After creating the cluster index, you can add tables to the index and perform DML operations on those tables.
3¡¢Adding Tables to a Cluster: Example
The following statements create some departmental tables from the sample hr.employees table and add them to the personnel cluster created in the earlier example:
CREATE TABLE dept_10
CLUSTER personnel (department_id)
AS SELECT * from employees WHERE department_id = 10;
CREATE TABLE dept_20
CLUSTER personnel (department_id)
AS SELECT * from employees WHERE department_id = 20;
ÊÔÑ飺´´½¨±ítesta¡¢testb¡¢²¢ÉèÖÃa01¡¢b01¹²Óþۼ¯testclu
&nb
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
½â¾ö°ì·¨£º
1.ʹÓÃOracleÓû§µÇ¼ϵͳ£¬ÔÚCMDÖÐÆôÓÃSQLPLUS
2.sqlplus /nolog
3.SQL> connect /as sysdba
¡¡¡¡¡¡ Connected.
4.SQL> alter user system account unlock;
¡¡¡¡¡¡ User altered.
Ëø¶¨Õ˺ŷ½·¨£º
1.SQL> alter user system account lock;
¡¡¡¡¡¡ & ......
ÔĶÁoracleÎĵµµÄb10743£¬¡¶conceps¡·¡£Õâ±¾±»oracle¹«Ë¾µÄ´óʦ¼¶µÄÈËÎïMichele CyranµÈÅ£ÈËËùд£¬ÕæÊÇÒ»±¾²»´íµÄÊé¼®¡£¿É̾ӢÎIJ»Ì«ºÃ£¬µ«Å¬Á¦£¬×Ü»áÓÐÊÕ»ñµÄ¡£»¹ÊÇ´ÓËûµÄÊý¾Ý¼Ü¹¹À´Ëµ°É£¡
£¨Ò»£©Data blocks £¬Extents£¬Segment
Õâ¾ÍÊÇËûÃÇÖ®¼äµÄÂß¼½á¹¹¡£
ÏÈ¿´Data blo ......
Êý¾Ý¿âϵͳºÍ²Ù×÷ϵͳһÑù£¬ÔÚ¼ÆËã»úÉÏ°²×°³É¹¦ºó£¬»¹ÐèÒª½øÒ»²½ÅäÖúÍÓÅ»¯£¬´Ó¶øʹÆä¾ßÓиüÇ¿´óµÄ¹¦ÄܺÍÔËÐÐÔÚ×î¼Ñ״̬¡£Èç¹ûÔÚÉè¼Æ½×¶ÎÒòΪ¸÷ÖÖÒòËØûÓнøÐнÏΪºÏÀíµÄÅäÖúͼƻ®£¬ÄÇô¾ÍÐèÒªÔÚºóÆÚ¶ÔÊý¾Ý¿âϵͳ½øÐÐÓÅ»¯¡£
Êý¾Ý¿âϵͳÐÔÄܵÄÓÅ»¯£¬³ýÁËÔÚÉè¼Æ½×¶Î¶ÔÆäÂß¼´æ´¢½á¹¹ºÍÎïÀí´æ´¢½á¹¹Éè¼Æ½øÐÐÓÅ»¯£¬Ê¹Ö®ÔÚÂú×ã ......
============================Question================================
SQL> select * from emp;
EMPID EMPNAME SALARY DEPTID
---------- ----------- ......