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

oracle clob ºÍblobÎÊÌâµÄ½â¾ö

oracle clob ºÍblobÎÊÌâµÄ½â¾ö
 
ÕûÀíÁËoracle clob ºÍblobÎÊÌâµÄ½â¾ö°ì·¨£º
1£º½¨ÒéʹÓÃoracle 10µÄojdbc14.jar,·ñÔòµ±±£´æclobµÄʱºò¿ÉÄÜ»á³öÏÖÌ×½Ó×Ö´íÎó£» 
2£ºspringÅäÖÃÈçÏ£º 
java´úÂë: 
        <bean id="sessionFactory" > 
                <property name="hibernateProperties"> 
                        <props> 
                                <prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop> 
                        </props> 
                </property> 
                <property name="dataSource"> 
                        <ref bean="dataSource" /> 
                </property> 
                <property name="configLocation"> 
                        <value>classpath:hibernate.cfg


Ïà¹ØÎĵµ£º

oracle ÐÔÄÜÖ¸±êͼ


Ö¸±êÃû³Æ
 
Ö¸±êÃèÊö
 
Ö¸±ê·¶Î§
 
Ö¸±êµ¥Î»
1£®¹ØÓÚʵÀýЧÂÊ£¨Instance Efficiency Percentages£©µÄÐÔÄÜÖ¸±ê
 
»º³åÇøÎ´µÈ´ýÂÊ
 
(Buffer Nowait %)
Ö¸ÔÚ»º³åÇøÖлñÈ¡BufferµÄδµÈ´ý±ÈÂÊ¡£
¸ÃÖ¸±êµÄÖµÓ¦½Ó½ü100%£¬Èç¹û¸ÃÖµ½ÏµÍ£¬Ôò¿ÉÄÜÒªÔö´óbuffer cache¡£
%
Redo»º³åÇøÎ´µÈ´ý ......

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨2£©£º°²×°Oracle Database 10G

ÏëÔÚLinuxϵͳ°ÑOralce°²×°ºÃ£¬È·ÊµÊǸö²»Ð¡µÄÌôÕ½£¬×îÆðÂëµÄ£¬Ê×ÏÈÒª¶ÔLinuxϵͳÓÐËùÁ˽⣬²»Ëµ¶àµÄ£¬¼òµ¥µÄһЩÅäÖÃÎļþºÍ³£ÓÃÃüÁî×ÜÒªÖªµÀ£¬Òª²»Õæ²»ÖªµÀÈçºÎÏÂÊÖ¡£½ñÌì°´Êé±¾µÄÆôʾ£¬ºÍÍøÉϱðÈËдµÄÎÄÕ»¹ÓÐOralce¹Ù·½µÄ°ïÖú¸Ð¾õ¶¼¶ÔÎÒ°ïÖúÉõ΢°¡¡£¡£¡£²»¹ý¸Ð¾õ×îºó»¹ÊÇÔÚQQȺºÍ°Ù¶ÈµÄ°ïÖúÏ£¬µ±È»Êé±¾ºÍÄÇЩÎÄÕ¶¼Æðµ½ ......

ORACLEÈëÃÅÊé¼®ÍÆ¼ö


OracleÈëÃÅÊé¼®ÍÆ¼ö
ºÜ¶àÅóÓÑÒªÎÒ°ïÃ¦ÍÆ¼öÒ»ÏÂOracleµÄÈëÃÅÊé¼®£¬Äܹ»Á˽âOracleµÄ»ù±¾¸ÅÄî¡¢»ù±¾ÖªÊ¶µÄÄÇÖÖ¡£
ÎÒ¾ÍÃâΪÆäÄÑ£¬ÍƼö¼¸±¾¡£
Ê×ÏÈÎÒÏëÇ¿µ÷µÄÒ»µãÊÇ£¬ÈκÎÒ»±¾ÏµÍ³µÄOracleÊé¼®Ö»ÒªÈÏÕæ¶ÁÏÂÀ´£¬¶¼»áÓв»´íµÄÊÕ»ñ£¬¶ÁÊé×î¼É»äµÄÊÇ»¢Í·Éßβ£¬Ç³³¢ÔòÖ¹¡£
1.µÚÒ»±¾ÒªÍƼö¸ø´ó¼ÒµÄÊÇOracleµÄ¸ÅÄîÊֲᣬÕâ±¾ÊÖ²á ......

ÈçºÎÔÚOracleÖн¨±í¸ñʱ¾ÍÖ¸¶¨Ö÷¼üºÍÍâ¼ü


´´½¨±íµÄÓï·¨
-´´½¨±í¸ñÓï·¨:
create table ±íÃû(
   ×Ö¶ÎÃû1  ×Ö¶ÎÀàÐÍ(³¤¶È) ÊÇ·ñΪ¿Õ,
   ×Ö¶ÎÃû2  ×Ö¶ÎÀàÐÍ       ÊÇ·ñΪ¿Õ
);
-Ôö¼ÓÖ÷¼ü
alter table ±íÃû add constraint Ö÷¼üÃû primary key (×Ö¶ÎÃû1);
-Ôö¼ÓÍâ¼ü:
alter table ±íÃû
  ......

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨19£©£º±¸·ÝOracleÊý¾Ý¿â

1¡¢±¸·Ý¹¤¾ß
Ö±½ÓʹÓòÙ×÷ϵͳʵÓóÌÐòcopy¡¢cp¾Í¿ÉÒÔ½øÐб¸·Ý²Ù×÷¡£µ«£¬OracleÇ¿ÁÒ½¨ÒéʹÓÃRecovery Manager£¨»Ö¸´¹ÜÀíÆ÷£¬¼òдRMAN£©¡£
RMANÄܹ»±¸·ÝÊý¾ÝÎļþ¡¢¿ØÖÆÎļþ¡¢¹éµµÈÕÖ¾ÒÔ¼°·þÎñÆ÷²ÎÊýÎļþ£¨spfile£©¡£±¸·Ý¿ÉÒÔ±»Ð´Èë´ÅÅÌ»ò´Å´ø¡£
2¡¢¸ÅÄîÓëÊõÓï
2.1¡¢È«²¿±¸·ÝÓ벿·Ö±¸·Ý
È«²¿±¸·Ý£¨whole backup£©ÊÇËùÓÐÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ