oracle ¹ØÓÚID×ÔÔöºÍÔÚÔÓÐIDµÄ»ù´¡ÉÏ×ÔÔö
ÎÒÊǸöÐÂÊÖ,ËùÒÔÓÐЩ˵µÄ¿ÉÄܻ᲻ºÃ,Ï£ÍûÔĶÁÕâÎÄÕµÄÈ˼ûÁ°¡.
Ò»°ã¹ØÓÚID×ÔÔöµÄÍøÉ϶¼ÓÐÁ˺ܶàÁË,ºÇºÇ^ÄÇÎҾͼòµ¥µÄ˵һÏÂ: ÏÈ´´½¨±í£¬ÔÙ´´½¨ÐòÁÐ:
create sequence ÐòÁÐÃû
minvalue 1(ÉèÖÃ1Ϊ×îСֵ)
maxvalues 1.0E28(orcale ĬÈÏ×î´óֵΪ1.0E28)
start with 1 ( ³õʼֵΪ1)
increment by 1 (²½³¤Îª1 ,Ò²¾ÍÊÇÿ´ÎÔö¼Ó1)
noorder (Õâ¸öÊÇÉèÖÃΪ ²»ÅÅÐò)
nocycle (Õâ¸öÊÇÉèÖÃΪ ²»Ñ»·)
nocache(Õâ¸öÊÇÉèÖÃΪ ûÓлº³å)
È»ºóÊÇ´´½¨Ò»¸ö´¥·¢Æ÷£º
create trigger ´¥·¢Æ÷Ãû before insert on ±íÃû for each row
as
begin
select ÐòÁÐÃû.nextval into :new.id from dual;
end;
ÕâÑùÒ»¸öID×ÔÔö±í¾Í´´½¨ÁË.
Ïà¹ØÎĵµ£º
±¾Îijö×Ô “inthirties£¨ÄÐÈËÈýÊ®£©”²©¿Í£¬×ªÔØÇëÎñ±Ø×¢Ã÷×÷Õߺͱ£Áô³ö´¦£¬Î´¾×÷ÕßÐí¿ÉתÔØ£¬±Ø×·¾¿·¨ÂÉÔðÈΡ£
ÔÚIBM AIXÉÏ°²×°Oracle RAC (RS/6000)
Ä¿µÄ
´ËÎĵµÏò¶ÁÕßÌṩÈçºÎ°²×°Ò»¸öȺ¼¯£¬°²×°RAC£¬²¢ÔÚIBM AIX HACMP/ES (CRM) 4.4.xÉÏÆô¶¯Ò»¸öȺ¼¯Êý¾Ý¿âµÄÊÖ°ÑÊÖÖ¸µ¼Êֲᣬ¶ÔÓÚ¹ØÓÚÈκÎÕâЩ²½ÖèµÄÆäËü½ ......
Êʵ±µÄʹÓÃË÷Òý¿ÉÒÔÌá¸ßÊý¾Ý¼ìË÷Ëٶȣ¬¿ÉÒÔ¸ø¾³£ÐèÒª½øÐвéѯµÄ×ֶδ´½¨Ë÷Òý
oracleµÄË÷Òý·ÖΪ5ÖÖ:ΨһË÷Òý£¬×éºÏË÷Òý£¬·´Ïò¼üË÷Òý£¬Î»Í¼Ë÷Òý£¬»ùÓÚº¯ÊýµÄË÷Òý
´´½¨Ë÷ÒýµÄ±ê×¼Óï·¨:
CREATE INDEX Ë÷ÒýÃû ON ±íÃû (ÁÐÃû)
TABLESPACE ±í¿Õ¼äÃû;
´´½¨Î¨Ò»Ë÷Òý:
CREATE unique INDEX Ë÷ÒýÃû ......
Îҵݲװ¹ý³Ì
1¡¢±à¼ /etc/apt/sources.list £º
sudo cp /etc/apt/sources.list /etc/apt/sources.list.bak #±¸·Ý
sudo gedit /etc/apt/sources.list
¼ÓÈëÏÂÃæÕâ¸öÔ´£º
deb http://oss.oracle.com/debian unst ......
oracle±í·ÖÇø
oracleÔÊÐíÓû§¶Ô±í½øÐнøÒ»²½¹æ»®£¬¼´¶Ô±í½øÐнøÒ»²½²ð·Ö£¬½«±í·Ö³ÉÈô¸É¸öÂß¼²¿·Ö£¬Ãð¸ö²»·Á³ÆÆäΪ±í·ÖÇø
·¶Î§·ÖÇø£º
¸ù¾Ý±íÖÐÁÐÖµµÄ·¶Î§½øÐзÖÇø
Óï·¨£ºPartition by range(×Ö¶ÎÃû)(
Partition ·ÖÇøÃû values less than (60), --60ÒÔÏÂ
Partition ·ÖÇøÃû values less than (75), --60¡«75
......
1 ¡¢°²×°Ç°µÄ×¼±¸
1.1 ¼ì²éÓ²¼þ
ÎïÀíÄڴ棺 # grep MemTotal /proc/meminfo
½»»»¿Õ¼ä£º # grep SwapTotal /proc/meminfo
½»»»¿Õ¼äµÄ´óСÊǸù¾ÝÎïÀíÄÚ´æµÄ´óСÀ´ÉèÖõģ¬ÎïÀíÄÚ´æÉÙÓÚ 2G µÄÔò½»»»¿Õ¼äÉèΪÎïÀíÄÚ´æµÄÁ½±¶£¬ÎïÀíÄÚ´æ´óÓÚ 2G µÄÔò½»»»¿Õ¼äºÍÎïÀíÄÚ´æ´óСһÑù¡£Èç¹û²»·ûºÏÉÏÊö¹æ¶¨£¬ÄÇô¾ÍÐèÒªÖØÐÂÉèÖý ......