Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)

ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
  
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......

Oracle Êý¾ÝÀàÐÍ


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

oracleº¯Êý´óÈ«


SQLÖеĵ¥¼Ç¼º¯Êý    
1.ASCII    
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;    
SQL> select ascii(’A’) A,ascii(’a’) a,ascii(’0’) zero,ascii(’ ’) space from dual;&nb ......

ORACLE ÁÙʱ±í¿Õ¼äʹÓÃÂʹý¸ßµÄÔ­Òò¼°½â¾ö·½°¸

ORACLE ÁÙʱ±í¿Õ¼äʹÓÃÂʹý¸ßµÄÔ­Òò¼°½â¾ö·½°¸(2009-11-14 19:59:02)
±êÇ©£ºoracle ÁÙʱ±í¿Õ¼ä ʹÓÃÂÊ100 ½â¾ö·½°¸ it
·ÖÀࣺ¼¼Êõ²©ÂÛ
ÔÚÊý¾Ý¿âµÄÈÕ³£Ñ§Ï°ÖУ¬·¢ÏÖ¹«Ë¾Éú²úÊý¾Ý¿âµÄĬÈÏÁÙʱ±í¿Õ¼ätempʹÓÃÇé¿ö´ïµ½ÁË30G£¬Ê¹ÓÃÂÊ´ïµ½ÁË100%£» ´ýµ÷ÕûΪ32Gºó£¬Ê¹ÓÃÂÊ»¹ÊÇΪ100%£¬µ¼Ö´ÅÅ̿ռäʹÓýôÕÅ¡£¸ù¾ÝÁÙʱ±í¿Õ¼äµÄÖ÷ ......

OracleÌåϵ½á¹¹£ºÄÚ´æ½á¹¹ºÍ½ø³Ì½á¹¹

OracleÌåϵ½á¹¹£ºÄÚ´æ½á¹¹ºÍ½ø³Ì½á¹¹
2009-11-24 21:48
¡¡£¨Ò»£©ÄÚ´æ½á¹¹ºÍ½ø³Ì½á¹¹ OracleÊý¾Ý¿âµÄ×ÜÌå½á¹¹ÈçÏÂͼ£º
1£ºOracleʵÀý£¨Instance£©        
   ÔÚÒ»¸ö·þÎñÆ÷ÖУ¬Ã¿Ò»¸öÔËÐеÄOracleÊý¾Ý¿â¶¼ÓëÒ»¸öÊý¾Ý¿âʵÀýÏàÁªÏµ£¬ÊµÀýÊÇÎÒÃÇ
·ÃÎÊÊý¾Ý¿âµÄÊֶΡ£
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ