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

PostgreSQLаæÌá¸ßOracle¼æÈÝÐÔ ÓûÓë¼×¹ÇÎÄÊԱȸߣ¿

ÉÌÒµ¿ªÔ´Êý¾Ý¿â³§¼ÒEnterpriseDBÓë6ÔÂ17ÈÕ·¢²¼ÁË×îеÄPostgres Plus¸ß¼¶·þÎñÆ÷°æ£¬ÆäÄ¿±êÊÇÌá¸ßÓëOracleÊý¾Ý¿âµÄ¼æÈÝÐÔ£¬EnterpriseDBÊÇ¿ªÔ´Êý¾Ý¿âPostgreSQL£¨Ò²½Ð×öPostgres£©±³ºóµÄÖ÷ÒªÉÌÒµÖ§³Ö¹«Ë¾¡£
ÆäʵPostgres Plus¸ß¼¶·þÎñÆ÷°æ²¢·ÇÍêÈ«¿ªÔ´£¬ËüÊÇÔÚ¿ªÔ´µÄPostgreSQLÊý¾Ý¿â»ù´¡Ö®ÉÏÌí¼ÓÁËÐí¶à¸½¼ÓÌØÐÔ£¬ÒÔÌá¸ßºÍOracleÊý¾Ý¿âµÄ¼æÈÝÐÔ¡£
ÔÚ8.3 R2·¢ÐаæÖУ¬EnterpriseDBÌí¼ÓÁËÐí¶àÐÔÄܺͿÉÉìËõÐÔÑ¡ÏÓÐÒâ˼µÄÊÇÏÖÔÚOracle¹ºÂòÁËSunµÄ¿ªÔ´Êý¾Ý¿âMySQL£¬¶øEnterpriseDBÏÖÔÚÒ²»ñµÃÁËIBMµÄͶ×Ê¡£
EnterpriseDB CEO Ed Boyajian͸¶£¬Õâ¸ö°æ±¾¶ÔÆóÒµ¸üÓÐÎüÒýÁ¦ºÍ¿ÉÐÐÐÔ£¬Êܾ­¼ÃΣ»úµÄÓ°Ï죬ºÜ¶àÒѾ­²¿ÊðÁËOracleµÄÆóÒµÕýÔÚ¿¼Âǽ«ËüÃǵķǹؼüÒµÎñ×ªÒÆµ½Postgres¡£
½ØÖÁĿǰOracle»¹Î´¶ÔÆä¾ºÕù¶ÔÊÖEnterpriseDB·¢²¼Ð°æÊý¾Ý¿âÕâһʼþ×ö³öÈÎºÎÆÀÂÛ¡£
Boyajian˵Postgres Plus¸ß¼¶·þÎñÆ÷°æÖеÄеÄOracle¼æÈÝÌØÐÔ¹Ø×¢µÄÊǽµµÍ³É±¾£¬·çÏպʹÓOracleÊý¾ÝÇ¨ÒÆÓ¦ÓóÌÐòµÄʱ¼ä¡£
EnterpriseDBÊ×ϯ¼Ü¹¹Ê¦Jim Mlodgenski˵ʵ¼ÊÉÏÕâÒ»´Î·¢²¼ÊǸù«Ë¾µÚÎå´úOracle¼æÈÝÐÔ²úÆ·ÁË£¬ÔÚÒÔǰµÄ°æ±¾Öнö½ö×öÁËÄÇЩ±È½ÏÈÝÒ×ʵÏÖµÄÊÂÇ飬ÔÚÕâ¸ö°æ±¾ÖÐÎÒÃÇÉîÈëµ½OracleÐÐΪÖÐÈ¥ÁË£¬Ò»¸ö×îÃ÷ÏÔµÄÀý×Ó¾ÍÊÇÊÂÎñ¿ØÖÆ¡£
Mlodgenski˵ʵ¼ÊÉÏÊÂÎñ¿ØÖƵÄÁé¸ÐÊÇÀ´×ÔEnterpriseDBµÄ¿Í»§Âåɼí¶Ê±±¨£¬ËüÃÇ×¢Òâµ½ÊÂÎñÊÇ·¢ÉúÔÚOracleÊý¾Ý¿âÍùÊý¾Ý¿âдÈëÊý¾ÝÐÐʱµÄ¡£
³ýÁËÌṩOracle¼æÈÝÐÔÌØÕ÷Í⣬EnterpriseDB»¹¸øÊý¾Ý¿âÌí¼ÓÁËеĿÉÉìËõÐÔÌØÐÔ£¬ÆäÖÐÒ»¸öÀý×Ó¾ÍÊÇ“ÎÞÏÞ»º´æ£¬Infinite Cache”£¬Ëü»ùÓÚ¿ªÔ´µÄmemcachedÓ¦ÓóÌÐò¡££¨51CTO±à¼­ÍƼö£º´Ómemcached¿´MySQLºÍ¹ØÏµÊý¾Ý¿âµÄδÀ´£©
Mlodgenski˵·Ö²¼Ê½Äڴ滺´æÒѾ­ºÜ³£¼ûÁË£¬µ«´Óϵͳ¹ÜÀíºÍÊý¾Ý¿âÊÓ½ÇÀ´¿´»¹ÊǷdz£À§Äѵġ£ÎÒÃǵÄ×ö·¨Êǽ«·Ö²¼Ê½Äڴ滺´æ·ÅÔÚÊý¾Ý¿âÇ°Ãæ£¬È»ºó½«ÆäÍÆË͵½Êý¾Ý¿â£¬ÕâÑù¾ÍÔÊÐí¿ª·¢ÈËԱʹÓüòµ¥µÄSQL½Ó¿Ú·ÃÎÊ·Ö²¼Ê½Äڴ滺´æ£¬²¢ÇÒϵͳ¹ÜÀí¿ªÏúÏÖÔÚÊÇÓÉÊý¾Ý¿â×ÔÉí¿ØÖÆµÄÁË¡£Mlodgenski˵ÎÞÏÞ»º´æ¶ÔÓÚ¶Á²Ù×÷ÐÔÄÜÓÐ10µ½20±¶µÄÌáÉý¡£Óû¸ü¶àµÄÁ˽â·Ö²¼Ê½Êý¾Ý¿â£¬¿É²Î¿¼51CTO֮ǰ·¢²¼µÄ·Ö²¼Ê½Êý¾Ý¿âµÄǰÊÀ½ñÉúÒ»ÎÄ¡£
Ò²¿ÉÒÔͨ¹ýһЩ½Ð×öÒ첽Ԥȡ£¨Asynchronous Pre-Fetch£©µÄ¼¼ÊõÌáÉýÐÔÄÜ£¬Ò첽ԤȡÊÇÒ»¸ö¸ßÐÔÄܲéѯ½â¾ö·½°¸£¬ËüʹÄãµÄ´ÅÅÌ×ÊÔ´µÃµ½¸ü¸ßЧµØÀûÓã¬ËüÌáǰ¸æËßÄÚºËÄãÐèÒªµÄÊÇÄÇÒ»¿éÊý¾Ý£¬¶ÔÓÚÄÇЩ±¨±íÐÍÓ¦ÓóÌÐòÕâ¸öÌØÐԷdz£µÄºÃ£¬Äã¿ÉÒÔ´Ó´ÅÅÌÉÏ¿ìËÙ»ñµÃ´ó¿éµÄÊý¾Ý¡£
Ó


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

oracle 10g ÔÚ RED HAT ENTERPRISE LINUX 5ϵݲװ

ORACLE 10GÔÚLINUXµÄ°²×°:
ÏÈÉÏÀ´Á½ÕÅͼ:
DBAÊÇŬÁ¦µÄ·½Ïò,ORACLE DBA°üÂÞÍòÏó,Á¬LINUX/UNIX¶¼¸ã²»¶¨,»¹ÅªP¸öORACLE°¡.
Á½²¿·Ö:
1.RED HAT ENTERPRISE LINUX 5µÄ°²×°
  Äѵã(¶ÔÓÚÏÖÔÚµÄÎÒÀ´Ëµ):1.1YUM±¾µØÔ´µÄÅäÖÃ;ÍøÂçÓÐÏà¹Ø×ÊÁÏ,²»¶à˵ÁË.ÓÉÓÚÊDZ¾»úʹÓÃ,²Î¿¼ÁËFTPÔ´ºó,ÎÒʹÓÃÁËFILEÔ´;
   &nb ......

oracle constraints(3)

oracle constraints Ó¦ÓÃ
oracle constraints¿ÉÒÔÉèÖÃΪÁ¢¼´¼ì²é»òÕßµ±Ê±ÊÂÎñÌύʱ¼ì²é¡£
    ¿ÉÒÔÔÚ´´½¨Ô¼ÊøµÄʱºòÖ¸¶¨ÊÇdeferrable¡£È»ºóͨ¹ýset constraints xxx set deferred»òÕßimmediate,Ò²¿ÉÒÔÔÚseesion¼¶±ðÉ趨ËùÓÐÔ¼ÊøÎªdeferred»òÕßimmediate(alter seesion set constraints deferred/immediat ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ