Oracle 11g µÄ ×Ô¶¯ÄÚ´æ¹ÜÀí
	
    
    
	Oracle µÄ 9i/10g ÖÐÒѾ¶ÔÄÚ´æ¹ÜÀíÖð²½×öÁ˺ܴóµÄ¼ò»¯£¬11g Ôò¸ü½øÒ»²½£¬ÒýÈëÁËÒ»¸öеĸÅÄî×Ô¶¯»¯ÄÚ´æ¹ÜÀí(Automatic Memory Management,AMM) . Èç¹û DBA ÕæµÄÏë͵ÀÁµÄ»°£¬Ö»ÐèÒªÉ趨Á½¸ö²ÎÊý¾Í¿ÉÒÔ°Ñ·³ÐĵÄÊÂÇé¶¼½»¸ø Oracle ÕÛÌÚÁË(Ö»Òª DBA ×ã¹»ÐÄ¿í)¡£PGA Óë SGA Ò»Æð¸ã¶¨¡£ÕâÁ½¸ö²ÎÊý·Ö±ðÊÇ£º
MEMORY_TARGET--²Ù×÷ϵͳµÄ½Ç¶ÈÉÏ Oracle ËùÄÜʹÓõÄ×î´óÄÚ´æÖµ¡£¶¯Ì¬²ÎÊý
MEMORY_MAX_TARGET--MEMORY_TARGETËùÄÜÉ趨µÄ×î´óÖµ¡£·Ç¶¯Ì¬¿Éµ÷¡£
Tip: Èç¹ûʹÓõÄÊÇ pfile£¬É趨ÁË MEMORY_TARGET ¶øÃ»ÓÐÖ¸¶¨ MEMORY_MAX_TARGET µÄÖµ£¬ÔòʵÀýÆô¶¯ºó MEMORY_MAX_TARGET µÄÖµÓë MEMORY_TARGET ÏàµÈ¡£Èç¹û pfile ÖÐÖ¸¶¨ÁË MEMORY_MAX_TARGET ¶øÃ»ÓÐÖ¸¶¨ MEMORY_TARGET £¬ÊµÀýÆô¶¯ºó MEMORY_TARGET Ϊ 0 ¡£
AMM ÔÚºǫ́»áÆô¶¯Ò»¸öÄÚ´æ¹ÜÀí(Memory Manager, mman)½ø³Ì¡£
ÒòΪ AMM µÄÒýÈ룬Oracle ÄÚ´æ¹ÜÀí¸ü¼ÓÁé»î¶àÑù¡£ ×éºÏ³öÀ´ÓÐ 5 ÖÖÄÚ´æ¹ÜÀíÐÎʽ.
×Ô¶¯ÄÚ´æ¹ÜÀí 
×Ô¶¯¹²ÏíÄÚ´æ¹ÜÀí 
ÊÖ¹¤¹²ÏíÄÚ´æ¹ÜÀí 
×Ô¶¯ PGA ¹ÜÀí 
ÊÖ¶¯ PGA ¹ÜÀí
1) ×Ô¶¯ÄÚ´æ¹ÜÀí
ĬÈϰ²×°µÄʵÀý¼´ÊÇ AMM ·½Ê½¡£ÈçÏ 
SQL> show parameters target 
NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ------------------------------
archive_lag_target                   integer                0
db_flashback_retention_target        integer                1440
fast_start_io_target                 integer                0
fast_start_mttr_target               integer                0
memory_max_target                    big integer            1216M
memory_target                        big integer            1216M
pga_aggregate_target                 big integer            0
sga_target                           big integer            0
ҪעÒâµ½ SGA_TARGET ºÍ ¶¼Îª 0 ¡£ 
2.×Ô¶¯¹²ÏíÄÚ´æ¹ÜÀí(Automatic Shared Memory Management, ASMM)
ÕâÊÇ 10g ÒýÈëµÄ¹ÜÀí·½Ê½£¬ÒªÊ¹ÓÃÕâÖÖ·½Ê½£¬ÐèÒªÉèÖóõʼ»¯²ÎÊý MEMORY_TARGET=0 £¬È»ºóÏÔʽµÄÖ¸¶¨ SGA_TARGET µÄÖµ¡£ 
SQL> alter system set sga_target=1024m scope=both;
alter system set sga_target=1024m scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modif
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    µ¥±í²åÈëÒÔinsert into¿ªÍ·,²»ÄÜÓÐthen intoÓï¾ä.
¶à±í²åÈëÒÔinsert first/all ¿ªÍ·,¿ÉÒÔÓÐthen intoÓï¾ä
ÔÚOracle²Ù×÷¹ý³ÌÖо³£»áÓöµ½Í¬Ê±Ïò¶à¸ö²»Í¬µÄ±í²åÈëÊý¾Ý£¬´ËʱÓøÃÓï¾ä¾Í·Ç³£ºÏÊÊ¡£
All±íʾ·Ç¶Ì·ÔËË㣬¼´Âú×ãÁ˵ÚÒ»¸öÌõ¼þÒ²µÃÏòÏÂÖ´Ðв鿴ÊÇ·ñÂú×ãÆäËüÌõ¼þ£¬¶øFirstÊǶÌ·ÔËËãÕÒµ½ºÏÊÊÌõ¼þ¾Í²»ÏòϽøÐС£
I ......
	
    
        
    
    
<!--
 /* Font Definitions */
 @font-face
	{font-family:ËÎÌå;
	panose-1:2 1 6 0 3 1 1 1 1 1;
	mso-font-alt:SimSun;
	mso-font-charset:134;
	mso-generic-font-family:auto;
	mso-font-pitch:variable;
	mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
	{font-family:"\@ËÎÌå" ......
	
    
        
    
    
Êý¾ÝÀàÐÍ
²ÎÊý
ÃèÊö
char(n)
n=1 to 2000×Ö½Ú
¶¨³¤×Ö·û´®£¬n×Ö½Ú³¤£¬Èç¹û²»Ö¸¶¨³¤¶È£¬È±Ê¡Îª1¸ö×Ö½Ú³¤£¨Ò»¸öºº×ÖΪ2×Ö½Ú£©
varchar2(n)
n=1 to 4000×Ö½Ú
¿É±ä³¤µÄ×Ö·û´®£¬¾ßÌ嶨ÒåʱָÃ÷×î´ó³¤¶Èn£¬
ÕâÖÖÊý¾ÝÀàÐÍ¿ÉÒÔ·ÅÊý×Ö¡¢×ÖĸÒÔ¼°ASCIIÂë×Ö·û¼¯(»òÕßEBCDICµÈÊý¾Ý¿âϵͳ½ÓÊܵÄ×Ö·û¼¯±ê×¼)ÖеÄËùÓзûºÅ¡£
Èç¹ ......
	
    
        
    
    Èí¼þ: VMware Workstation 6.0.2 build-59824
        10201_database_linux32.zip
        rhel.5.0.server.centoschina.com.dvd.iso
Îĵµ:ORACLE10G¹Ù·½°²×°Îĵµ  B19306_01_Oracle10gR2.chm
²Î¿¼:Öܾ¼ÀÏʦµÄORACLE10G OCPÊÓÆµ(½²µÄÕæµÄ ......