¡¾×ª¡¿ ORACLE±í·ÖÇøÒÔ¼°ÐÅÏ¢²éÕÒ
ORACLE±í·ÖÇøÒÔ¼°ÐÅÏ¢²éÕÒ
http://www.sysab.cn/a/db/oracle/2009/1020/2433.html
·ÖÇø¸ÅÊö ΪÁ˼ò»¯Êý¾Ý¿â´ó±íµÄ¹ÜÀí,ÀýÈçÔÚÊý¾Ý²Ö¿âÖÐÒ»°ã¶¼ÊÇTB¼¶µÄÊýÁ¿¼¶.ORACLE8ÒÔºóÍÆ³öÁË·ÖÇøÑ¡Ïî.·ÖÇø½«±í·ÖÀëÔÚÈôÓÚ²»Í¬µÄ±í¿Õ¼äÉÏ,Ó÷ֶøÖÎÖ®µÄ·½·¨À´Ö§³ÅÔªÏÞÅòÕ͵Ĵó±í,×é´ó±íÔÚÎïÀíÒ»¼¶µÄ¿É¹ÜÀíÐÔ.½«´ó±í·Ö¸î³É½ÏСµÄ·ÖÇø¿ÉÒÔ¸ÄÉÆ±íµÄά»¤¡¢±¸·Ý
·ÖÇø¸ÅÊö
ΪÁ˼ò»¯Êý¾Ý¿â´ó±íµÄ¹ÜÀí,ÀýÈçÔÚÊý¾Ý²Ö¿âÖÐÒ»°ã¶¼ÊÇTB¼¶µÄÊýÁ¿¼¶.ORACLE8ÒÔºóÍÆ³öÁË·ÖÇøÑ¡Ïî.·ÖÇø½«±í·ÖÀëÔÚÈôÓÚ²»Í¬µÄ±í¿Õ¼äÉÏ,Ó÷ֶøÖÎÖ®µÄ·½·¨À´Ö§³ÅÔªÏÞÅòÕ͵Ĵó±í,×é´ó±íÔÚÎïÀíÒ»¼¶µÄ¿É¹ÜÀíÐÔ.½«´ó±í·Ö¸î³É½ÏСµÄ·ÖÇø¿ÉÒÔ¸ÄÉÆ±íµÄά»¤¡¢±¸·Ý¡¢»Ö¸´¡¢ÊÂÎñ¼°²éѯÐÔÄÜ¡£
·ÖÇøµÄÓŵ㣺
1¡¢ ÔöÇ¿¿ÉÓÃÐÔ£ºÈç¹û±íµÄÒ»¸ö·ÖÇøÓÉÓÚϵͳ¹ÊÕ϶ø²»ÄÜʹÓ㬱íµÄÆäÓàºÃµÄ·ÖÇøÈÔ¿ÉÒÔʹÓã»
2¡¢ ¼õÉٹرÕʱ¼ä£ºÈç¹ûϵͳ¹ÊÕÏÖ»Ó°Ïì±íµÄÒ»²¿·Ý·ÖÇø£¬ÄÇôֻÓÐÕⲿ·Ý·ÖÇøÐèÒªÐÞ¸´£¬¿óÄܱÈÕû¸ö´ó±íÐÞ¸´»¨µÄʱ¼ä¸üÉÙ£»
3¡¢ ά»¤ÇáËÉ£ºÈç¹ûÐèÒªµÃ½¨±í£¬¶À²ú¹ÜÀíÿ¸ö¹«Çø±È¹ÜÀíµ¥¸ö´ó±íÒªÇáËɵöࣻ
4¡¢ ¾ùºâI/O£º¿ÉÒ԰ѱíµÄ²»Í¬·ÖÇø·ÖÅäµ½²»Í¬µÄ´ÅÅÌÀ´Æ½ºâI/O¸ÄÉÆÐÔÄÜ£»
5¡¢ ¸ÄÉÆÐÔÄÜ£º¶Ô´ó±íµÄ²éѯ¡¢Ôö¼Ó¡¢Ð޸ĵȲÙ×÷¿ÉÒԷֽ⵽±íµÄ²»Í¬·ÖÇøÀ´²¢ÐÐÖ´ÐУ¬¿ÉʹÔËÐÐËٶȸü¿ì£¬ÔÚÊý¾Ý²Ö¿âµÄTP²éÑ¯ÌØ±ðÓÐÓá£
6¡¢ ·ÖÇø¶ÔÓû§Í¸Ã÷£¬×îÖÕÓû§¸Ð¾õ²»µ½·ÖÇøµÄ´æÔÚ¡£
create tablespace dw1
datafile 'D:\oracle\oradata\ora9\dw11.ora' size 50M
create tablespace dw2
datafile 'D:\oracle\oradata\ora9\dw21.ora' size 50M
Ò»¡¢°´·¶Î§·ÖÇø£º¹ÌÃû˼Òå¾ÍÊǰ´Ò»¶¨rangeÀ´·ÖÇø£¬¿´ÏÂÃæµÄÀý×Ó:
SQL> set linesize 1000
SQL> create table niegc_part
2 (
3 part_id integer primary key,
4 part_date date,
5 part_dec varchar2(100)
6 )
7 partition by range(part_date)
8 (
9 partition part_01 values less than(to_date('2006-01-01','yyyy-mm-dd')) tablespace dw1,
10 partition part_02 values less than(to_date('2007-01-01','yyyy-mm-dd')) tablespace dw2,
11 partition part_03 values less than(maxvalue) tablespace dw1
12 );
±íÒÑ´´½¨¡£
SQL>
SQL> insert into niegc_part values(1,to_date('2005-12-30','yyyy-mm-dd'),'less 20
06-01-01');
ÒÑ´´½¨ 1 ÐС£
SQL> commit;
Ìá½»Íê³É¡£
SQL> insert into niegc_part values(2,to_date('2
Ïà¹ØÎĵµ£º
1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.È ......
oracle³£ÓÃÊý¾ÝÀàÐÍ
½ñÌìͬÊÂÎÊЩÊý¾ÝÀàÐ͵ÄÎÊÌ⣬ÓеϹտÓеã¼Ç²»ÇåÁË£¬ÓÚÊǾͼòµ¥×ܽáϳ£ÓõÄÊý¾ÝÀàÐÍÒÔ±¸ÈÕºó²éÓÃ
1¡¢Char
¶¨³¤¸ñʽ×Ö·û´®£¬ÔÚÊý¾Ý¿âÖд洢ʱ²»×ãλÊýÌî²¹¿Õ¸ñ£¬ËüµÄÉùÃ÷·½Ê½ÈçÏÂCHAR(L)£¬LΪ×Ö·û´®³¤¶È£¬
ȱʡΪ1£¬×÷Ϊ±äÁ¿×î´ó32767¸ö×Ö·û£¬×÷ΪÊý¾Ý´æ´¢ÔÚORACLE8ÖÐ×î´óΪ2000¡£²»½¨ÒéʹÓ㬻ᴠ......
±³¾°£ºÔÚwindows2003serverÉϰ²×°ÁËOracle9.2.0.1.0£¬ÏÖ´òË㽫ÆäÉý¼¶µ½9.2.0.8°æ±¾£¬²¢´òÉÏ×îÐµİ²È«²¹¶¡April2008°æ¡£
1.Éý¼¶oracle£¨administratorÓû§È¨ÏÞ£©
(1)µ½metalinkÏÂÔØÉý¼¶Ñ¹Ëõ°ü£¬patchºÅΪ4547809£¬Ñ¹Ëõ°üÃû³ÆÎª p4547809_92080_WINNT.zip£¬for windows 32bit¡£
(2)½âѹËõzip£¬Ï±߰üº¬Ò»¸ö ......
Author: Rainny
Date: 2010-3-5
Ò»£¬Ö¢×´ÃèÊö
2¸ö½ÚµãµÄORACLE 10G RAC£¬¸ôÒ»¶Îʱ¼äÆäÖеÄÒ»¸öNODE¾Í»áDOWN»ú¡£½Úµã´ÓCLUSTERÖб»ÇýÖð¡£
¶þ£¬Õï¶Ï¹ý³Ì
Rac1±»Öð³ö£¬RAC2´æ»î£¬RAC2½Ó¹ÜÁËRAC1µÄVIP£¬ÎÒÃÇÀ´²é¿´RAC2µÄÏà¹ØLOG¡£
Ê×ÏȲ鿴RAC2µÄ¸æ¾¯ÈÕÖ¾£º..\log\rac2\alertrac2.log:
2010-03-05 14:39:50.750
[cssd(7 ......
Á©Ì¨²»Í¬µÄÊý¾Ý¿â·þÎñÆ÷£¬´Óһ̨Êý¾Ý¿â·þÎñÆ÷µÄÒ»¸öÓû§¶ÁÈ¡Áíһ̨Êý¾Ý¿â·þÎñÆ÷ϵÄij¸öÓû§µÄÊý¾Ý£¬Õâ¸öʱºò¿ÉÒÔʹÓÃdblink¡£
ÆäʵdblinkºÍÊý¾Ý¿âÖеÄview²î²»¶à£¬½¨dblinkµÄʱºòÐèÒªÖªµÀ´ý¶ÁÈ¡Êý¾Ý¿âµÄipµØÖ·£¬ssidÒÔ¼°Êý¾Ý¿âÓû§ÃûºÍÃÜÂë¡£
´´½¨¿ÉÒÔ ......