Oracle 8i.9i.10g.11g ²»Í¬°æ±¾µÄÐÂÌØÐԱȽÏ
Oracle 9i±È8i¶àÁËÄÄЩÐÂÌØÐÔ£¿
¼òҪ˵£º
9i¸üÒ×ÓÚ¹ÜÀí¡£
Ïêϸ˵£º
²¢·¢¼¯Èº£¬8i OPSÉý¼¶Îª9i RAC£¬8i½áµã¼äÓÃÓ²Å̽»»»ÐÅÏ¢£¬9i½áµã¼ä²ÉÓøßËÙÍøÏߵĻº´æÈÛºÏ(Cache Fusion)¼¼Êõ½»»»ÐÅÏ¢£¬½»»»ËÙ¶ÈÌá¸ß100±¶ÒÔÉÏ¡£
9i¿ÉÒÔÔÚÏßÐÞ¸ÄÄں˲ÎÊýºÍÄÚ´æ·ÖÅ䣬8i²»ÐС£
Êý¾ÝÎļþºÍ±í¿Õ¼ä¹ÜÀí£¬8iÊÖ¹¤¹ÜÀí£¬9i×Ô¶¯¹ÜÀí¡£
9i±È8iÔöÇ¿Á˶ÔANSI SQL99µÄÖ§³Ö¡£
9i±È8iÔöÇ¿Á˹ÊÕϺóµÄ¿ìËÙ»Ö¸´(Fast-start)¡£
8iÖ»Ö§³ÖÎïÀí±¸·Ý(physical backup)Êý¾Ý¿â£¬9i»¹Ôö¼ÓÁËÖ§³ÖÂß¼±¸·Ý(logical backup)Êý¾Ý¿â£¬Ê¹±¸·ÝÊý¾Ý¿â³ýÁË×÷ΪÖ÷Êý¾Ý¿âµÄ¾µÏñÍ⣬»¹¿ÉÒÔÌṩÆäËûÊý¾Ý·þÎñ.
Oracle 10g±È9i¶àÁËÄÄЩÐÂÌØÐÔ£¿
¼òҪ˵£º
10gÖ§³ÖÍø¸ñ(Grid)£¬Ö§³Ö×Ô¶¯¹ÜÀí(Automatic Management)¡£
Ïêϸ˵£º
10gµÄgÊÇ"Grid"Ëõд£¬Ö§³ÖÍø¸ñ¼ÆË㣬¼´£¬¶ą̀½áµã·þÎñÆ÷ÀûÓøßËÙÍøÂç×é³ÉÒ»¸öÐéÄâµÄ¸ßÐÔÄÜ·þÎñÆ÷£¬¸ºÔØÔÚÕû¸öÍø¸ñÖоùºâ(Load Balance)£¬°´ÐèÔöɾ½áµã£¬±ÜÃâµ¥µã¹ÊÕÏ(Single Point of Faliure)¡£
°²×°ÈÝÒ×£¬°²×°¹¤×÷Á¿±È9i¼õÉÙÁËÒ»°ë¡£
ÐÂÔö»ùÓÚä¯ÀÀÆ÷µÄÆóÒµ¹ÜÀíÆ÷(Enterprise Manager)¡£
×Ô¶¯´æ´¢¹ÜÀí(ASM)£¬ÔöɾӲÅ̲»ÔÙÐèÒª²Ù×÷ϵͳ¹ÜÀíÔ±ÉèÖõľµÏñ¡¢¸ºÔؾùºâ¡¢ÎïÀí¾í¡¢Âß¼¾í¡¢·ÖÇø¡¢Îļþϵͳ£¬Ö»Òª´òÒ»ÌõOracleÃüÁASM»á×Ô¶¯¹ÜÀíÔö¼Ó»òɾ³ýµÄÓ²ÅÌ¡£
ÄÚ´æ×Ô¶¯»¯£¬¸ù¾ÝÐèÒª×Ô¶¯·ÖÅäºÍÊÍ·ÅϵͳÄÚ´æ¡£
SQLÐÔÄܵ÷Õû×Ô¶¯»¯¡£
Ãâ·ÑÌṩ»ùÓÚä¯ÀÀÆ÷µÄСӦÓÿª·¢¹¤¾ßOracle Application Express(ÔÃûHTML DB)£¬Ö§³Ö10gºÍ9i R2¡£
¿ìËÙ¾ÀÕýÈËΪ´íÎóµÄÉÁ»Ø(Flashback)²éѯºÍ»Ö¸´£¬¿ÉÒÔ»Ö¸´Êý¾Ý¿â¡¢±íÉõÖÁ¼Ç¼¡£
Êý¾Ý±Ã(Data Pump)¸ßËÙµ¼Èë¡¢µ¼³öÊý¾Ý£¬±È´«Í³·½·¨µ¼³öËٶȿìÁ½±¶ÒÔÉÏ£¬µ¼ÈëËٶȿì15--45±¶¡£
¾«Ï¸Éó¼Æ(Fine-Grained Auditing)£¬¼Ç¼һÇжÔÃô¸ÐÊý¾ÝµÄ²Ù×÷¡£
´æ´¢Êý¾ÝµÄ±í¿Õ¼ä(Tablespace)¿çƽ̨¸´ÖÆ£¬¼«´óµÄÌá¸ßÊý¾Ý²Ö¿â¼ÓÔØËٶȡ£
Á÷(Streams)¸´ÖÆ£¬ÊµÏÖµÍϵͳÏûºÄ¡¢Ë«Ïò(double-direction)¡¢¶ÏµãÐø´«(resume from break point)¡¢¿çÆ
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
(1)PfileÎļþ
Pfile£¨Parameter File£©ÎļþÊÇ»ùÓÚÎı¾¸ñʽµÄ²ÎÊýÎļþ£¬º¬ÓÐÊý¾Ý¿âµÄÅäÖòÎÊý¡£
Oracle 9iÔÚ°²×°Ê±ÎªÃ¿¸öÊý¾Ý¿â½¨Á¢ÁËÒ»¸öPfile£¬Ä¬ÈϵÄÃû³ÆΪ“init+Àý³ÌÃû.ora”£¬ÕâÊÇÒ»¸öÎı¾Îļþ£¬¿ÉÒÔÓÃÈκÎÎı¾±à¼¹¤¾ß´ò¿ª¡£
ϱíΪÊý¾Ý¿âµÄ³õʼ»¯²Î ......
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02 13:45:25ΪÀý)
Year:
yy two digits Á½Î»Äê ÏÔʾֵ:07
yyy three digits ÈýλÄê &nbs ......
½ñÌìÔÚÒ»±¾ÊéÉÏ¿´µ½µÄ£¬¸Ð¾õͦȫµÄ¡£Ó¡ÏóÖÐ×Ô¼ºÒѾ²»ÖªµÀ°Ù¶ÈÁ˶àÉÙ´ÎÕâ¸öÎÊÌ⣬½ñÌì¾Í¼ÇÏÂÀ´°É£¬·½±ãÒÔºó²éѯ¡£
Êý¾Ý¿âд½ø³ÌÔÚÒÔÏÂʼþÖ®Ò»·¢Éúʱ°ÑÊý¾Ý¿â¸ßËÙ»º³åÇøµÄÊý¾Ýдµ½Êý¾ÝÎļþÉÏ:
µ±Ô໺³åÇøµÄÊýÁ¿³¬¹ýÁËËùÉ趨µÄÏÞ¶î
µ±ËùÉ趨µÄʱ¼ä¼ä¸ôÒѵ½
µ±Óнø³ÌÐèÒªÊý¾Ý¿â¸ßËÙ»º³åÇøÈ´ÕÒ²»µ½¿ÕÏеĻº³åÇøʱ
µ±¼ì²éµ ......