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 DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
LOB´ó¶ÔÏó´¦Àí£º Ö÷ÒªÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾ÝµÄÊý¾Ý¿â×ֶΣ¬×î´ó¿ÉÒÔ´æ´¢4G×ֽڵķǽṹ»¯Êý¾Ý¡£ Ö÷Òª½éÉÜ×Ö·ûÀàÐͺͶþ½øÖÆÎļþÀàÐÍLOBÊý¾ÝµÄ´æ´¢£¬µ¥¶À½éÉܶþ½øÖÆÀàÐÍLOBÊý¾ÝµÄ´æ´¢¡£
Ò». OracleÖеÄLOBÊý¾ÝÀàÐÍ·ÖÀà
1£¬°´´æ´¢Êý¾ÝµÄÀàÐÍ·Ö£º
¢Ù×Ö·ûÀàÐÍ£º
  ......
oracle ¹éµµÓë²»¹éµµ
1. ²é¿´Êý¾Ý¿âµÄ¹éµµÄ£Ê½
£¨1£©Ê¹ÓÃÃüÁ
-------------------------------------------------
SQL> archive log list
Êý¾Ý¿âÈÕ־ģʽ ´æµµÄ£Ê½
×Ô¶¯´æµµ ÆôÓÃ
´æµµÖÕµã f:\oradata\dblearn\arch
×îÔçµÄ¸ÅÒªÈÕÖ¾ÐòÁÐ 14
ÏÂÒ»¸ö´æµµÈÕÖ¾ÐòÁÐ 16
µ±Ç°ÈÕÖ¾ÐòÁÐ 16
--- ......
ÔÚOracleÖдæÈ¡BLOB¶ÔÏóʵÏÖÎļþµÄÉÏ´«ºÍÏÂÔØ
×÷Õߣº[תÌù] ³ö´¦£º
×î
½ü×öÒ»¸öJ2EEÏîÄ¿£¬ÐèÒªÔÚJSPÒ³ÃæÊµÏÖ¶ÔÎļþµÄÉÏ´«ºÍÏÂÔØ¡£ºÜÔçÒÔǰ¾ÍÖªµÀJDBCÖ§³Ö´ó¶ÔÏó£¨LOB£©µÄ´æÈ¡£¬ÒÔΪºÜÈÝÒ×£¬×öÆðÀ´²Å·¢ÏÖÎÊÌâ¶à
¶à£¬¶ÁÁËÒ»´ó¶ÑÎÄÕ£¬·´¶øÃ»ÓÐʲôͷÐ÷ÁË¡£ÕýÈçÒ»Î»ÍøÓÑÎÄÕÂËù½²£º“&h ......
ǰÑÔ£º
sql_trace ÊÇÎÒÔÚ¹¤×÷Öо³£ÒªÓõ½µÄµ÷ÓŹ¤¾ß£¬Ïà±È½Ïstatspack ÎÒ¸üÔ¸ÒâÓÃÕâ¸ö¹¤¾ß¡£
ÒòΪÊý¾Ý¿âÂýÔÒòµÄ85%ÒÔÉÏÊÇÓÉÓÚsqlÎÊÌâÔì³ÉµÄ£¬statspackûÓÐsqlµÄÖ´Ðмƻ®¡£ÏÔʾûÓÐËüÖ±¹Û£¬·½±ã£¬¶ÔÏëÒªÕë¶ÔÐÔ²»Ç¿£¬
1£¬½éÉÜÊý¾Ý¿âµ÷ÓÅÐèÒª¾³£»áÓõ½µÄ¹¤¾ß ......