Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle£ºCLUSTER

±í´Ø£¨table   cluster)ÊÇÒ»¸öÊý¾Ý¿â¶ÔÏó£¬Ëü¿ÉÒÔ½«ÄÇЩ¾­³£ÔÚÏàͬÊý¾Ý¿éÖÐÒ»ÆðʹÓÃµÄ±í½øÐÐÎïÀí·Ö×é¡£µ±Äã´¦ÀíÄÇЩ¾­³£Á¬½ÓÔÚÒ»Æð½øÐвéѯµÄ±íʱ£¬±í´ØÊÇÌØ±ðÓÐЧµÄ¡£Ò»¸ö±í´Ø´æ´¢´Ø¼ü£¨ÓÃÓÚ½«±íÁ¬½Óµ½Ò»ÆðµÄÁУ©£¬ÒÔ¼°´Ø±íÖеÄÁÐÖµ¡£ÒòΪ´ØÖÐµÄ±í¶¼±»´¢´æÔÚÏàͬµÄÊý¾Ý¿â¿éÖУ¬ËùÒÔʹÓôع¤×÷ʱ£¬I/O²Ù×÷¾Í¼õÉÙÁË¡£
ʹÓõäÐÍÊý¾Ý´ØµÄÄ¿µÄÊÇΪÁËÔÚÓ²ÅÌÉϽ«Ó¦ÓóÌÐò¾­³£Ò»ÆðʹÓõÄÐд洢ÔÚÒ»¿é£¬µ±Ó¦ÓóÌÐòÇëÇóÕâ×éÐÐʱ£¬oracleÖ»ÓÃÒ»¸ö»ò¼¸¸öÓ²ÅÌI/O¾ÍÄÜÕÒµ½ËùÓб»ÇëÇóµÄÐС£
1.cluster ¿ÉÒÔ½«Á½¸ö»ò¶à¸ö±íÀ¦°óÔÚÒ»Æð,,clusterÊÇÒ»ÖÖÊý¾Ý¿â½á¹¹,ÔÚÕâ¸ö½á¹¹ÖÐ,¿ÉÒÔ½«Á½¸ö»òÕß¶à¸ö±í´¢´æÔÚÏàͬµÄÊý¾Ý¿é»ò¶ÎÖÐ,¼ÓÈëµ½clusterÖеÄÿ¸ö±íÐн«ÎïÀíµØ´æ´¢ÔÚÏàͬµÄ¿éÖÐ,ºÃÏñÕâЩ±íÔÚcluster key ´¦Á¬½ÓÆðÀ´ÁËÒ»Ñù.ͨ¹ýÏÂÃæµÄÀý×Ó,Ä㽫Àí½âclusterÈçºÎµÄ¹¤×÷.
aa ±í
SQL> select * from aa;
ID NAME SE AGE
---- ---- -- ----------
01 cc m 20
02 dd f 18
03 ee m 22
04 ff f 21
05 gg f 19
06 hh m 20
ÒÑÑ¡Ôñ6ÐС£
bb±í
SQL> select * from bb;
SE LIVING
-- ------
m 11-01
f 11-02
2.
ÔÚʹÓÃaa,bb±íµÄʱºò,Èç¹ûÏëÒª½«ÕâÁ½¸ö±í·Åµ½Ò»¸öclusterÖÐ,Ôò¿ÉÒÔ½«ÕâÁ½¸ö
±íÔÚsexÁÐÉÏÁ¬½ÓÆðÀ´,ÔÚÕâÖÖÇé¿öÏÂ,°ÉsexÁгÆÎªcluster key ,µ±Íê³ÉclusterµÄ

´´½¨ºó,Á½¸ö±íÖеÄÊý¾Ý½«»áÔÚclusterÖÐÎïÀíµØÁ¬½ÓÆðÀ´.ÔÚ´´½¨clusterµÄʱºòÓÐÁ½ÖÖÑ¡Ôñ
:
* index cluster(
ĬÈÏ,ÐèÒªÔÚÆäÖд´½¨cluster index)
* hash cluster
3.´´½¨clusterµÄ²½Öè:
1). SQL> create cluster ab_cluster (sex char(2) ) tablespace users;
´ØÒÑ´´½¨¡£
ÉÏÃæµÄÓï¾ä´´½¨ÁËÒ»¸öÃûΪab_clusterµÄcluster,ÇÒ½«ËüÖÃÓÚ±í¿Õ¼äusrsÖÐ.ÒòΪÉÏÃæ´´½¨µÄÊÇindex cluster ,ËùÒÔµ±cluster´´½¨Íêºó,»¹±ØÐëÔÚcluster key ÉÏ´´½¨Ë÷Òý.
2). SQL> create index ab_cluster_idx on cluster ab_cluster tablespace users;
Ë÷ÒýÒÑ´´½¨¡£
{ µ±´´½¨hash clusterµÄʱºò,Àý×ÓÈçÏÂ:
Create cluster ab_cluster (sex char(2) size 8k hashkeys 1000 tablespace users;
²ÎÊýhashkeysÓÃÀ´¶¨Òå·ÖÅ䏸±íµÄhash]ÖµµÄÊýÄ¿.Ö¸³öÁËÔÚclusterÖÐΨһÐÔcluster keyµÄ×î´óÖµ.}
3).´´½¨²ÎÓëclusterµÄ±í.£¨aa bb£©
SQL> create table aa(id varchar2(4) ,name varchar2(4),sex char(2),age number(2))
cluster ab_cluster (sex);
±íÒÑ´´½¨.
SQL> create table bb( sex


Ïà¹ØÎĵµ£º

OracleÊý¾Ý¿â10gÀ¬»ø±íÇå³ý×îз½·¨

¾­³£Ê¹ÓÃoracle10g£¬ÎÒÃÇ¿ÉÒÔ·¢ÏÖÒÔǰɾ³ýµÄ±íÔÚÊý¾Ý¿âÖгöÏÖÁËÌØ±ð¶àµÄÀ¬»ø±í£¬ÈçÏÂÀý£º
¡¡¡¡BINjR8PK5HhrrgMK8KmgQ9nw==
¡¡¡¡ÕâÒ»ÀàµÄ±íͨ³£ÎÞ·¨É¾³ý£¬²¢ÇÒÎÞ·¨ÓÃ"delete"ɾ³ý,ÕâÖÖÇé¿öµÄ³öÏÖ£¬
¡¡¡¡Ò»°ã²»»áÓ°ÏìÕý³£µÄʹÓ㬵«ÊÇÓÐÓöµ½ÒÔϼ¸ÖÖÇé¿öʱÔò±ØÐëɾµôËü¡£
¡¡¡¡¡ô1.ÕâЩ±íÕ¼Óÿռä
¡¡¡¡¡ô2.Èç¹ûʹÓÃMiddle ......

Oracle PL\SQL²Ù×÷£¨Ò»£©

1.OracleÔõÑù´æ´¢Îı¾
CHARºÍVARCHAR2µÄÇø±ð
•CHAR¶¨³¤×Ö·û´®£¬VARCHAR2±ä³¤×Ö·û´®¡£
•CHAR(n) ¶¨³¤×Ö·û´®£¬n×Ö½Ú£¬nµÄȡֵ·¶Î§£º1~2000×Ö½Ú¡£
•VARCHAR2(n) ¿É±ä³¤µÄ×Ö·û´®£¬¶¨ÒåʱӦָÃ÷×î´ó³¤¶È£¬È¡Öµ·¶Î§£º1~ 4000×Ö½Ú¡£
2. OracleÔõÑù´æ´¢ÊýÖµ
ÊýÖµÀàÐÍ˵Ã÷£º NUMBER£¨m , n£©
Êý×Ö ......

Oracle PL\SQL²Ù×÷£¨Áù£©Óû§ºÍ½ÇÉ«

1.Óû§¹ÜÀí
£¨1£©½¨Á¢Óû§£¨Êý¾Ý¿âÑéÖ¤£©

CREATE USER smith
IDENTIFIED BY smith_pwd
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
QUOTA 5m ON users;
£¨2£©ÐÞ¸ÄÓû§
ALTER USER smith
QUOTA 0 ON SYSTEM;
£¨3£©É¾³ýÓû§
DROP USER smith;
DROP USER ......

php Á´½Óoracle phpµ÷ÓÃoracle´æ´¢¹ý³Ì


phpµ÷ÓÃoracleÐд洢¹ý³Ì############################################################
PHP³ÌÐò·ÃÎÊÊý¾Ý¿â£¬ÍêÈ«¿ÉÒÔʹÓô洢¹ý³Ì£¬ÓÐÈËÈÏΪʹÓô洢¹ý³Ì±ãÓÚά»¤
²»¹ýÈÊÕß¼ûÈÊ£¬ÖÇÕß¼ûÖÇ¡£
ÔÚÕâ¸öÎÊÌâÉÏ£¬Å¼ÈÏΪʹÓô洢¹ý³ÌÒâζ×űØÐëÒªDBAºÍ¿ª·¢ÈËÔ±¸ü½ôÃÜÅäºÏ,Èç¹ûÆäÖÐÒ»·½¸ü±ä£¬ÔòÏÔÈ»ÄÑÒÔά»¤¡£
µ«ÊÇʹÓô洢 ......

¹ØÓÚoracle·þÎñ

OracleOraHome92Agent
OracleOraHome92ClientCache
OracleOraHome92HTTPServer
OracleOraHome92PagingServer
OracleOraHome92SNMPPeerEncapsulator
OracleOraHome92SNMPPeerMasterAgent
·Ö±ðÊÇ:
Agent´úÀí, OEMÈý²ã¹ÜÀíʱÓëOMS½øÐеǼǴ¦¹µÍ¨;
¿Í»§¶ËÐÅÏ¢Cache;
ÌṩWeb·þÎñ;
BP»ú֪ͨ·þÎñ,±ÈÈçÊý¾Ý¿âÓ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ