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

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


Ïà¹ØÎĵµ£º

oracleͬʱÏò¶à±í²åÈëÊý¾Ý

µ¥±í²åÈëÒÔinsert into¿ªÍ·,²»ÄÜÓÐthen intoÓï¾ä.
¶à±í²åÈëÒÔinsert first/all ¿ªÍ·,¿ÉÒÔÓÐthen intoÓï¾ä
ÔÚOracle²Ù×÷¹ý³ÌÖо­³£»áÓöµ½Í¬Ê±Ïò¶à¸ö²»Í¬µÄ±í²åÈëÊý¾Ý£¬´ËʱÓøÃÓï¾ä¾Í·Ç³£ºÏÊÊ¡£
All±íʾ·Ç¶Ì·ÔËË㣬¼´Âú×ãÁ˵ÚÒ»¸öÌõ¼þÒ²µÃÏòÏÂÖ´Ðв鿴ÊÇ·ñÂú×ãÆäËüÌõ¼þ£¬¶øFirstÊǶÌ·ÔËËãÕÒµ½ºÏÊÊÌõ¼þ¾Í²»ÏòϽøÐС£
I ......

OracleÖеÄһЩʱ¼ä´¦Àí


<!--
/* 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:"\@ËÎÌå" ......

Oracle Êý¾ÝÀàÐÍ


Êý¾ÝÀàÐÍ
²ÎÊý
ÃèÊö
char(n)
n=1 to 2000×Ö½Ú
¶¨³¤×Ö·û´®£¬n×Ö½Ú³¤£¬Èç¹û²»Ö¸¶¨³¤¶È£¬È±Ê¡Îª1¸ö×Ö½Ú³¤£¨Ò»¸öºº×ÖΪ2×Ö½Ú£©
varchar2(n)
n=1 to 4000×Ö½Ú
¿É±ä³¤µÄ×Ö·û´®£¬¾ßÌ嶨ÒåʱָÃ÷×î´ó³¤¶Èn£¬
ÕâÖÖÊý¾ÝÀàÐÍ¿ÉÒÔ·ÅÊý×Ö¡¢×ÖĸÒÔ¼°ASCIIÂë×Ö·û¼¯(»òÕßEBCDICµÈÊý¾Ý¿âϵͳ½ÓÊܵÄ×Ö·û¼¯±ê×¼)ÖеÄËùÓзûºÅ¡£
Èç¹ ......

ORACLEÖ®°²×°Æª(Ò») ×¼±¸°²×°

Èí¼þ: 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ÊÓÆµ(½²µÄÕæµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ