´óÐÍORACLEÊý¾Ý¿âÓÅ»¯Éè¼Æ·½°¸
±¾ÎÄÖ÷Òª´Ó´óÐÍÊý¾Ý¿âORACLE»·¾³Ëĸö²»Í¬¼¶±ðµÄµ÷Õû·ÖÎöÈëÊÖ£¬·ÖÎöORACLEµÄϵͳ½á¹¹ºÍ¹¤×÷»úÀí£¬´Ó¾Å¸ö²»Í¬·½Ãæ½ÏÈ«ÃæµØ×ܽáÁËORACLEÊý¾Ý¿âµÄÓÅ»¯µ÷Õû·½°¸¡£
¹Ø¼ü´Ê ORACLEÊý¾Ý¿â»·¾³µ÷ÕûÓÅ»¯Éè¼Æ·½°¸
¶ÔÓÚORACLEÊý¾Ý¿âµÄÊý¾Ý´æÈ¡£¬Ö÷ÒªÓÐËĸö²»Í¬µÄµ÷Õû¼¶±ð£¬µÚÒ»¼¶µ÷ÕûÊDzÙ×÷ϵͳ¼¶°üÀ¨Ó²¼þƽ̨,
µÚ¶þ¼¶µ÷ÕûÊÇORACLE RDBMS¼¶µÄµ÷Õû, µÚÈý¼¶ÊÇÊý¾Ý¿âÉè¼Æ¼¶µÄµ÷Õû, ×îºóÒ»¸öµ÷Õû¼¶ÊÇSQL¼¶¡£Í¨³£ÒÀ´ËËļ¶µ÷Õû¼¶±ð¶ÔÊý¾Ý¿â½øÐе÷Õû¡¢ÓÅ»¯£¬Êý¾Ý¿âµÄÕûÌåÐÔÄÜ»áµÃµ½ºÜ´óµÄ¸ÄÉÆ¡£ÏÂÃæ´Ó¾Å¸ö²»Í¬·½Ãæ½éÉÜORACLEÊý¾Ý¿âÓÅ»¯Éè¼Æ·½°¸¡£
Ò»¡¢Êý¾Ý¿âÓÅ»¯×ÔÓɽṹOFA(Optimal flexible Architecture)
Êý¾Ý¿âµÄÂß¼ÅäÖöÔÊý¾Ý¿âÐÔÄÜÓкܴóµÄÓ°Ïì,Ϊ´Ë,ORACLE¹«Ë¾¶Ô±í¿Õ¼äÉè¼ÆÌá³öÁËÒ»ÖÖÓÅ»¯½á¹¹OFA¡£Ê¹ÓÃÕâÖֽṹ½øÐÐÉè¼Æ»á´ó´ó¼ò»¯ÎïÀíÉè¼ÆÖеÄÊý¾Ý¹ÜÀí¡£ÓÅ»¯×ÔÓɽṹOFA,¼òµ¥µØ½²¾ÍÊÇÔÚÊý¾Ý¿âÖпÉÒÔ¸ßЧ×ÔÓɵطֲ¼Âß¼Êý¾Ý¶ÔÏó,Òò´ËÊ×ÏÈÒª¶ÔÊý¾Ý¿âÖеÄÂß¼¶ÔÏó¸ù¾ÝËûÃǵÄʹÓ÷½Ê½ºÍÎïÀí½á¹¹¶ÔÊý¾Ý¿âµÄÓ°ÏìÀ´½øÐзÖÀà,ÕâÖÖ·ÖÀà°üÀ¨½«ÏµÍ³Êý¾ÝºÍÓû§Êý¾Ý·Ö¿ª¡¢Ò»°ãÊý¾ÝºÍË÷ÒýÊý¾Ý·Ö¿ª¡¢µÍ»î¶¯±íºÍ¸ß»î¶¯±í·Ö¿ªµÈµÈ¡£
Êý¾Ý¿âÂß¼Éè¼ÆµÄ½á¹ûÓ¦µ±·ûºÏÏÂÃæµÄ×¼Ôò£º£¨1£©°ÑÒÔͬÑù·½Ê½Ê¹ÓõĶÎÀàÐÍ´æ´¢ÔÚÒ»Æ𣻣¨2£©°´ÕÕ±ê׼ʹÓÃÀ´Éè¼Æϵͳ£»£¨3£©´æÔÚÓÃÓÚÀýÍâµÄ·ÖÀëÇøÓò£»£¨4£©×îС»¯±í¿Õ¼ä³åÍ»£»£¨5£©½«Êý¾Ý×Öµä·ÖÀë¡£
¶þ¡¢³ä·ÖÀûÓÃϵͳȫ¾ÖÇøÓòSGA£¨SYSTEM GLOBAL AREA)
SGAÊÇoracleÊý¾Ý¿âµÄÐÄÔà¡£Óû§µÄ½ø³Ì¶ÔÕâ¸öÄÚ´æÇø·¢ËÍÊÂÎñ£¬²¢ÇÒÒÔÕâÀï×÷Ϊ¸ßËÙ»º´æ¶ÁÈ¡ÃüÖеÄÊý¾Ý£¬ÒÔʵÏÖ¼ÓËÙµÄÄ¿µÄ¡£ÕýÈ·µÄSGA´óС¶ÔÊý¾Ý¿âµÄÐÔÄÜÖÁ¹ØÖØÒª¡£SGA°üÀ¨ÒÔϼ¸¸ö²¿·Ö£º
1¡¢Êý¾Ý¿é»º³åÇø£¨data block buffer cache£©ÊÇSGAÖеÄÒ»¿é¸ßËÙ»º´æ£¬Õ¼Õû¸öÊý¾Ý¿â´óСµÄ1%-2%£¬ÓÃÀ´´æ´¢´ÓÊý¾Ý¿âÖضÁÈ¡µÄÊý¾Ý¿é£¨±í¡¢Ë÷Òý¡¢´ØµÈ£©£¬Òò´Ë²ÉÓÃleast recently used (LRU,×î½ü×îÉÙʹÓÃ)µÄ·½·¨½øÐпռä¹ÜÀí¡£
2¡¢×ֵ仺³åÇø¡£¸Ã»º³åÇøÄÚµÄÐÅÏ¢°üÀ¨Óû§Õ˺ÅÊý¾Ý¡¢Êý¾ÝÎļþÃû¡¢¶ÎÃû¡¢ÅÌÇøλÖᢱí˵Ã÷ºÍȨÏÞ£¬ËüÒ²²ÉÓÃLRU·½Ê½¹ÜÀí¡£
3¡¢ÖØ×öÈÕÖ¾»º³åÇø¡£¸Ã»º³åÇø±£´æΪÊý¾Ý¿â»Ö¸´¹ý³ÌÖÐÓÃÓÚÇ°¹ö²Ù×÷¡£
4¡¢SQL¹²Ïí³Ø¡£±£´æÖ´Ðмƻ®ºÍÔËÐÐÊý¾Ý¿âµÄSQLÓï¾äµÄÓï·¨·ÖÎöÊ÷¡£Ò²²ÉÓÃLRUËã·¨¹ÜÀí¡£Èç¹ûÉèÖùýС£¬Óï¾ä½«±»Á¬Ðø²»¶ÏµØÔÙ×°È
Ïà¹ØÎĵµ£º
»¹ÊǽèÖúoracle sql developerÀ´²Ù×÷oracle£¬sql plus»¹ÊÇÂé·³Ò»µã¡£
¼òµ¥¿´ÁËһϣ¬Óï¾ä»ù±¾É϶¼ºÍÆäËûÊý¾Ý¿âµÄsql²î²»¶à£¬¼Ç¼һϲ»Í¬µÄµØ·½¡£
ÈÕÆÚÀàÐͱà¼
update student set stu_birthday = to_date('2010-03-06 13:14:20','yyyy-MM-dd HH24:mi:ss');
ÐèҪʹÓÃto_date()º¯Êý£¬SQLÖв»Çø·Ö´óСд£¬MMºÍmm± ......
ÀûÓÃoracle×Ô´øµÄutl_file°ü¿ÉÒÔ·ÃÎÊ´ÅÅÌÎļþ£¬µ«ÓиöÏÞÖÆ--ÎÞ·¨·ÃÎÊÎļþ¼Ð£¿Ê²Ã´Òâ˼ÄØ£¿¾ÍÊÇ˵oracleÖ»ÄÜ·ÃÎÊÖ¸¶¨µÄÎļþ£¬¶ø²»ÄÜ·ÃÎÊÎļþ¼ÐϵÄδ֪Îļþ¡£ËùÒÔ£¬Èç¹ûҪͨ¹ýoracleÈ¥±éÀúijָ¶¨Â·¾¶ÏµÄËùÓÐÎļþ£¬sorry, impossible! µ«ÊÇ£¬ÓÐÒ»ÖÖÌæ´ú·½°¸¿ÉÒÔÖúÄãÒ»±ÛÖ®Á¦£¡
ÖÚËùÖÜÖªjavaÖ®FileÀàÖ¸ÏòµÄ¿ÉÒÔÊÇĿ¼Ҳ¿ÉÒÔÊ ......
±í·ÖÇøά»¤£º
Ìí¼Ó·ÖÇø£º
Alter table student add partition ·ÖÇøÃû values less than(100);
ɾ³ý·ÖÇø£º
Alter table student drop partition ·ÖÇøÃû;
½Ø¶Ì·ÖÇø£º
Alter table student truncate partition ·ÖÇøÃû;
ºÏ²¢·ÖÇø£º
Alter table student merge partitions ·ÖÇøÃû,...,·ÖÇøÃû into partition зÖÇøÃû; ......
1 - / , . ; :
"text" ʱ¼ä·Ö¸ô·ûºÅ£¬³ýÁ˱ê×¼µÄ¼¸¸ö£¬»¹ÔÊÐíÓÃÎÄ×Ö×÷Ϊ·Ö¸î·ûºÅ¡£
ÀýÈç to_char(sysdate,'YYYY"Äê"mm"ÔÂ"dd"ÈÕ"')=2008Äê04ÔÂ24ÈÕ
2 AD
A.D. ¼´À¶¡ÎÄAnno DominiµÄ¼òд£¬±íʾ¹«Ôª.»á¸ù¾ÝnlsµÄ²»Í¬×ª»»Îª¹«Ôª»òÕßadµÈ
ÎÞÌØÊâ×¢ÒâÊÂÏî
3 AM
A.M. ÉÏ ......
Ë÷Òý
ΨһË÷Òý£º
ÁÐÖÐÎÞÖظ´Öµ£¬Î¨Ò»Ô¼Êø¡£
oracle×Ô¶¯ÎªÖ÷¼üºÍΪһ¼üÁд´½¨Î¨Ò»Ë÷Òý
Óï·¨£ºcreate unique index Ë÷ÒýÃû on ±íÃû(ÁÐÃû);
×éºÏË÷Òý£º
ÔÚ±íÖжà¸ö×Ö¶ÎÉÏ´´½¨µÄË÷Òý
Áа´ÈÎÒâ˳ÐòÅÅÁÐ
where×Ó¾äÖаüº¬¶à¸öÁеIJéѯ£¬¿ÉÌá¸ß·ÃÎÊËٶȡ£
Óï·¨£ºcreate index Ë÷ÒýÃû on ±íÃû(ÁÐÃû1,ÁÐÃû2,...,ÁÐÃûn)£º
·´ ......