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

windows7 °²×°Oracle 10g¿Í»§¶Ë

ÕâÁ½ÌìÔÚwindows7Éϰ²×°OracleÅöµ½Á˵ãÎÊÌâ,Ê×ÏÈÄÃOracle 10g32λµÄ°²×°°üÈ¥×°£¬½á¹ûÒ»Çж¼Õý³££¬PL/SQLÁ¬½Ó·þÎñÆ÷Êý¾Ý¿âÕý³££¬
µ«ÊÇÖ´ÐÐÎҵijÌÐòʱ×ÜÊDZ¨ÎÞ·¨½âÎöÁ¬½Ó±êʶ·û¡£¡£ºóÀ´ÓÐͬÊÂ˵¿ÉÄÜÊÇwindows7 ÊÇ64λµÄϵͳµÄÔ­Òò¡£½ÓמÍÏÂÔØÁË64λµÄOracle
10g °æ±¾µÄ¡£¡£µ«ÔÚ°²×°Ê±£¬Ìáʾϵͳ²Ù×÷°æ±¾¹ý¸ß£ºÖ»Ö§³Ö4.1£¬5.1²Ù×÷ϵͳ£¬windows7²Ù×÷ϵͳΪ6.1¡£½á¹ûÓÖ°²×°²»ÁË¡£½Ó×ÅÔÚÍøÉÏ
²éÁËЩ×ÊÁÏ¡£°²ÕÕ×ÊÁϰ²×°³É¹¦¡£
°²×°·½·¨£ºÊ×ÏÈÏÂÔØOracle 10g Vista°æ±¾µÄ°²×°°ü¡£
Æä´ÎÔÚ½âѹºÃµÄÎļþ¼ÐÖÐÕÒµ½refhost.xmlÎļþ£¨¿ÉÄÜ´æÔÚ¶à¸ö¸ÃÎļþ£©£¬ÔÚÎļþÖÐÌí¼ÓÒÔÏÂÄÚÈÝ
<!--Microsoft Windows 7-->
<operating_system>
<version value="6.1"></version>
</operating_system>
×¢£ºÕâ¿ÉÒÔʹÔÚ¼ì²éÏȾöÌõ¼þµÄʱºò¾Í¿ÉÒÔÈÆ¹ý²Ù×÷ϵͳµÄ¼ì²é¡£
±£´æ¡£¡£½Ó×ÅÆô¶¯°²×°³ÌÐò¡£³É¹¦
OracleµÄ¹ÙÍøÏÂÔØOracle Database 10g Client Release 2 (10.2.0.3)


Ïà¹ØÎĵµ£º

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

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

ORACLE LOB ´ó¶ÔÏó´¦Àí

 
LOB´ó¶ÔÏó´¦Àí£º Ö÷ÒªÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾ÝµÄÊý¾Ý¿â×ֶΣ¬×î´ó¿ÉÒÔ´æ´¢4G×ֽڵķǽṹ»¯Êý¾Ý¡£ Ö÷Òª½éÉÜ×Ö·ûÀàÐͺͶþ½øÖÆÎļþÀàÐÍLOBÊý¾ÝµÄ´æ´¢£¬µ¥¶À½éÉܶþ½øÖÆÀàÐÍLOBÊý¾ÝµÄ´æ´¢¡£
 
Ò».  OracleÖеÄLOBÊý¾ÝÀàÐÍ·ÖÀà
 1£¬°´´æ´¢Êý¾ÝµÄÀàÐÍ·Ö£º
  ¢Ù×Ö·ûÀàÐÍ£º
   ......

oracle ¹éµµÓë²»¹éµµ

oracle ¹éµµÓë²»¹éµµ
1. ²é¿´Êý¾Ý¿âµÄ¹éµµÄ£Ê½
£¨1£©Ê¹ÓÃÃüÁ
-------------------------------------------------
    SQL> archive log list
Êý¾Ý¿âÈÕ־ģʽ ´æµµÄ£Ê½
×Ô¶¯´æµµ ÆôÓÃ
´æµµÖÕµã f:\oradata\dblearn\arch
×îÔçµÄ¸ÅÒªÈÕÖ¾ÐòÁÐ 14
ÏÂÒ»¸ö´æµµÈÕÖ¾ÐòÁÐ 16
µ±Ç°ÈÕÖ¾ÐòÁÐ 16
--- ......

ÔÚOracleÖдæÈ¡BLOB¶ÔÏóʵÏÖÎļþµÄÉÏ´«ºÍÏÂÔØ ¡¾×ª¡¿


ÔÚOracleÖдæÈ¡BLOB¶ÔÏóʵÏÖÎļþµÄÉÏ´«ºÍÏÂÔØ

×÷Õߣº[תÌù] ³ö´¦£º  

 
×î
½ü×öÒ»¸öJ2EEÏîÄ¿£¬ÐèÒªÔÚJSPÒ³ÃæÊµÏÖ¶ÔÎļþµÄÉÏ´«ºÍÏÂÔØ¡£ºÜÔçÒÔǰ¾ÍÖªµÀJDBCÖ§³Ö´ó¶ÔÏó£¨LOB£©µÄ´æÈ¡£¬ÒÔΪºÜÈÝÒ×£¬×öÆðÀ´²Å·¢ÏÖÎÊÌâ¶à
¶à£¬¶ÁÁËÒ»´ó¶ÑÎÄÕ£¬·´¶øÃ»ÓÐʲôͷÐ÷ÁË¡£ÕýÈçÒ»Î»ÍøÓÑÎÄÕÂËù½²£º“&h ......

ʹÓÃOracle sql_trace ¹¤¾ß

ǰÑÔ£º
    sql_trace ÊÇÎÒÔÚ¹¤×÷Öо­³£ÒªÓõ½µÄµ÷ÓŹ¤¾ß£¬Ïà±È½Ïstatspack ÎÒ¸üÔ¸ÒâÓÃÕâ¸ö¹¤¾ß¡£
    ÒòΪÊý¾Ý¿âÂýÔ­ÒòµÄ85%ÒÔÉÏÊÇÓÉÓÚsqlÎÊÌâÔì³ÉµÄ£¬statspackûÓÐsqlµÄÖ´Ðмƻ®¡£ÏÔʾûÓÐËüÖ±¹Û£¬·½±ã£¬¶ÔÏëÒªÕë¶ÔÐÔ²»Ç¿£¬
    1£¬½éÉÜÊý¾Ý¿âµ÷ÓÅÐèÒª¾­³£»áÓõ½µÄ¹¤¾ß ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ