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

´óÐÍ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ѧϰ±Ê¼Ç3


»¹ÊǽèÖú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µ÷ÓÃjavaÀà±éÀú´ÅÅÌÎļþ

ÀûÓÃoracle×Ô´øµÄutl_file°ü¿ÉÒÔ·ÃÎÊ´ÅÅÌÎļþ£¬µ«ÓиöÏÞÖÆ--ÎÞ·¨·ÃÎÊÎļþ¼Ð£¿Ê²Ã´Òâ˼ÄØ£¿¾ÍÊÇ˵oracleÖ»ÄÜ·ÃÎÊÖ¸¶¨µÄÎļþ£¬¶ø²»ÄÜ·ÃÎÊÎļþ¼ÐϵÄδ֪Îļþ¡£ËùÒÔ£¬Èç¹ûҪͨ¹ýoracleÈ¥±éÀúijָ¶¨Â·¾¶ÏµÄËùÓÐÎļþ£¬sorry, impossible! µ«ÊÇ£¬ÓÐÒ»ÖÖÌæ´ú·½°¸¿ÉÒÔÖúÄãÒ»±ÛÖ®Á¦£¡
ÖÚËùÖÜÖªjavaÖ®FileÀàÖ¸ÏòµÄ¿ÉÒÔÊÇĿ¼Ҳ¿ÉÒÔÊ ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç8 9


±í·ÖÇøά»¤£º
Ìí¼Ó·ÖÇø£º
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 зÖÇøÃû; ......

OracleÖÐto_char()²ÎÊýÏê½â

 1 -  /  ,  . ; :
"text" ʱ¼ä·Ö¸ô·ûºÅ£¬³ýÁ˱ê×¼µÄ¼¸¸ö£¬»¹ÔÊÐíÓÃÎÄ×Ö×÷Ϊ·Ö¸î·ûºÅ¡£
ÀýÈç to_char(sysdate,'YYYY"Äê"mm"ÔÂ"dd"ÈÕ"')=2008Äê04ÔÂ24ÈÕ
 2 AD
A.D.  ¼´À­¶¡ÎÄAnno DominiµÄ¼òд£¬±íʾ¹«Ôª.»á¸ù¾ÝnlsµÄ²»Í¬×ª»»Îª¹«Ôª»òÕßadµÈ
ÎÞÌØÊâ×¢ÒâÊÂÏî
 3 AM
A.M.  ÉÏ ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç10

Ë÷Òý
ΨһË÷Òý£º
ÁÐÖÐÎÞÖظ´Öµ£¬Î¨Ò»Ô¼Êø¡£
oracle×Ô¶¯ÎªÖ÷¼üºÍΪһ¼üÁд´½¨Î¨Ò»Ë÷Òý
Óï·¨£ºcreate unique index Ë÷ÒýÃû on ±íÃû(ÁÐÃû);
×éºÏË÷Òý£º
ÔÚ±íÖжà¸ö×Ö¶ÎÉÏ´´½¨µÄË÷Òý
Áа´ÈÎÒâ˳ÐòÅÅÁÐ
where×Ó¾äÖаüº¬¶à¸öÁеIJéѯ£¬¿ÉÌá¸ß·ÃÎÊËٶȡ£
Óï·¨£ºcreate index Ë÷ÒýÃû on ±íÃû(ÁÐÃû1,ÁÐÃû2,...,ÁÐÃûn)£º
·´ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ