OracleÔÚWindowsÉϵÄÔËÐÐÎÊÌâ·ÖÎöºÍ½â¾ö
	
    
    
	¡¶Oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX/UNIXÉϵÄʵսÏê½â¡·¼¯ÖÐÌÖÂ۵ļÌÐø¡£  ×öÁËÒ»ÖܹØÓÚOracleÔÚ32λwindowsÉÏʵʩµÄÅàѵ£¬Ç¡ºÃÆÚ¼äÓм¸Î»OracleÓû§ÓʼþѯÎʹØÓÚWindowsϵͳµ÷ÕûÎÊÌâ¡£ÕýºÃ°É£¬°Ñ×¼±¸µÄһЩÄÚÈݹ²Ïí³öÀ´¡£  Èç¹ûOracleʹÓôóÓÚ1.7µÄÄڴ棬ÐèÒªÒ»Ð©ÌØÐ´µÄÉèÖᣲμûÏÂÃæÀ´×ÔmetalinkµÄÂ۵㣺  Large page support is a feature of Oracle Database 10g Release 1 (10.1) or later. It   provides a performance boost for memory-intensive database instances running on   Windows Server 2003. By taking advantage of newly introduced operating system   support, Oracle Database 10g Release 1 (10.1) or later can now make more efficient use   of processor memory addressing resources. Specifically, when large page support is   enabled, the CPUs in the system will be able to access the Oracle Database buffers in   RAM more quickly. Instead of addressing the buffers in 4KB increments, the CPUs are   told to use 2 MB page sizes in Physical Address Extension (PAE) mode and 4MB page   sizes in non-PAE mode when addressing the database buffers.   ÓÉÓÚ32λµÄCPUµÄÔÚwindowsϵͳÖÐ2G¸øÏµÍ³ÓÃ2G¸øÓ¦ÓóÌÐòʹÓã¬Èçϵͳ¼°oracle²ÎÊý²»×÷ÐÞ¸Äʱ£¬oracleµÄSGAÄÚ´æÊ¹Óò»Äܳ¬¹ý1.7G  µ«¿ÉÒÔ¶ÔWindows²ÎÊý½øÐÐÐ޸ģº   1. ÐÞ¸Äboot.iniÎļþ£¬ÔÚÆäÖÐÌí¼Ó/3GBÑ¡Ïî»ò/PAE£¬ÉõÖÁ¶þÕß¶¼ÓÐÖ®¡£   WINDOWS="Microsoft Windows" /3GB   WINDOWS="Microsoft Windows" /PAE         2.ÉèÖÃOracleÔËÐл·¾³£¬ÉèÖÃwindows ×¢²á±í:   ʹÓà regedit¹¤¾ßÔÚHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1ÖÐÕÒµ½AWE_WINDOW_MEMORY²ÎÊý£¬ÐÞ¸ÄΪoracleÐèÒªÄÚ´æµÄ´óС£¬Èç5GB£¬ÒÔ×Ö½Ú·½Ê½¡£         3.ÊÚÓèOracleÓû§ÔÚÄÚ´æËø¶¨Ò³µÄȨÏÞ£¬·½·¨Îª£º¹ÜÀí¹¤¾ß--> Óò°²È«²ßÂÔ--> ±¾µØ°²È«²ßÂÔ -->Ëø¶¨ÄÚ´æÒ³£¬¼ÓÈëora_dba×é¡£   4£ºÉèÖÃoracle²ÎÊýÈçÏ£º   È¡ÏûÊý¾Ý£ºdb_cache_size¡¢sga_max_sizeµÈ10g²ÎÊý£»  Ìí¼Ó²ÎÊý£º  db_block_buffers   USE_INDIRECT_DATA_BUFFERS=TRUE      ²Î¼ûmetalink £ºImplementing Address Windowing Extensions (AWE) or VLM on Windows Platforms    ÎÄÆ½
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    oracle±í¿Õ¼ä²Ù×÷Ïê½â 
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......
	
    
        
    
    
¼×¹ÇÎÄÒѾÍê³ÉÁ˶ÔSUN¹«Ë¾µÄÊÕ¹º£¬ÓÚ1ÔÂ27ÈÕ·¢²¼Á˶ÔSun¸÷ÏîÒµÎñµÄÕûºÏ¹æ»®¡£×ÜÌåÉÏ˵£¬OracleÒª³ÉΪÈíÓ²¼þÒ»Ì廯µÄÕûÌå½â¾ö·½°¸µÄ³§ÉÌ¡£ ÒÔÏÂ¾ÍÆä¶Ô±¸ÊܹØ×¢µÄJava·½ÃæµÄ²ßÂÔ×ö¸ö½éÉÜ¡£ 
Java SE: 
1£©ÍƳöJDK SE 7£¬ Ëü½«°üÀ¨¶à¸öÐµĹ¦ÄÜ£¬ÈçÌá¸ß¿ª·¢ÈËÔ±µÄЧÂÊ£¬Ìṩ¸ßÐÔÄÜ£¬¶Ô¶àºËоƬµÄÖ§³ÖµÈ¡£ 
2£©SunµÄHotSp ......
	
    
        
    
       SGA ÖеÄÁíÍâÒ»¸öÖØÒª½á¹¹Êǹ²Ïí³Ø¡£¹²Ïí³Ø´æ´¢ÁËÓ¦ÓÃÖ´ÐÐÐèÒªµÄPL/SQL¿é½á¹¹£¬SQLÓï¾äµÄÎı¾¡¢SQL±àÒëºóµÄ¿É
Ö´ÐдúÂ롢ϵͳÊý¾Ý×ÖµäµÈ¡£
    Ç¡µ±µÄ¹²Ïí³Ø³ß´çÉèÖý«¼õÉÙϵͳ¸÷ÖÖ×ÊÔ´µÄʹÓá£Ê×ÏÈ£¬¶ÔÓÚSQL¡¢PL/SQL À´Ëµ£¬¹²Ïí³ØÌṩÁËÔËÐÐ״̬ϵÄÁÙʱ
´æ´¢µã£¬ºóÐøÖ´ÐеÄSQLºÍPL/SQL½«Ê ......
	
    
        
    
    Ëùν³öÓÚjob¶øÊ¤ÓÚjob£¬ËµµÄ¾ÍÊÇOracle 10gºóµÄÐÂÌØÐÔSchedulerÀ²¡£ÔÚ10g»·¾³ÖУ¬ORACLE½¨ÒéʹÓÃSchedulerÌæ»»ÆÕͨµÄjob£¬À´¹ÜÀíÈÎÎñµÄÖ´ÐС£Æäʵ£¬½«SchedulerÃèÊö³É¹ÜÀíjobµÄ¹¤¾ßÒѾ̫¹ýÆ¬ÃæÁË£¬10G°æ±¾ÖÐÐÂÔöµÄScheduler¾ø²»½ö½öÊÇ´´½¨ÈÎÎñÕâô¼òµ¥¡£¡£¡£¡£
Ìáʾ£ºORACLEÖйÜÀíSchedulerÊÇͨ¹ýDBMS_SCHEDULER°ü£¬±¾ÕÂÒ ......
	
    
        
    
    Èý¡¢Ê¹ÓÃSchedules
¡¡¡¡10g ÖÐÐÂÍÆ³öµÄSCHEDULER¿ÉÄÜȷʵ»áÈúܶà³õ½Ó´¥µÄÅóÓѸоõÔÎÍ·ÔÎÄÔ£¬Ïà±È֮ǰµÄjobs£¬SCHEDULERÖÐÐÂÔöµÄ¸ÅÄîÌ«¶à¡£±ÈÈç˵jobs£¬ÈÔÈ»¿ÉÒÔÀí½â³É֮ǰ°æ±¾ÖеÄjobs£¬²»¹ý¹¦Äܸü¼ÓÇ¿´ó(×¢Òâ10gÖÐÒ²ÈÔÈ»¿ÉÒÔʹÓÃÆÕͨjobs£¬ÕâÊÇ·Ï»°£¬ÏàÐÅ¿´±¾ÆªÎÄÕµÄÅóÓÑĿǰӦ¸Ã»¹ÊÇÕâÑùÔÚÓÃ)£¬±ÈÈç˵program£¬Ö¸µÄÊÇÔ ......