OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨3£©£º´´½¨OracleÊý¾Ý¿â£¨1£©
¸Ð¾õÕâ¸ö»¹ÊÇ·Ö¿ªÐ´ºÃÁË£¬Êý¾Ý¿âµÄ´´½¨¹¤×÷£¬ÔÒÔΪºÃÈÝÒ×¾ÍÊÇÏÂÒ»²½ÏÂÒ»²½µÄÎÊÌ⣬ÔÀ´ÀïÃæµÄÄÚÈÝ»¹ÊǺܶàµÄ£¬°üÀ¨Ìåϵ½á¹¹ÒªÁ˽âһЩ£¬DBCA½¨¿âÊÇÈÝÒ×À£¬²»¹ýÒª»áÊÖ¶¯½¨¿âÄDzŽпáÂÄøö½çÃæµãÏÂÒ»²½ÏÂÒ»²½Ë²»»á°¡£¬ÄÇ»¹½ÐDBA°¡£¿ºÇºÇ¡£
Oracle·þÎñÆ÷ÓÉÏÂÁÐÁ½¸öʵÌå×é³É£ºÊµÀý£¨Instance£©ÓëÊý¾Ý¿â¡£ÊµÀýÓÉ´æ´¢½á¹¹ºÍ½ø³Ì×é³É£¬²¢ÇÒÖ»¶ÌÔÝ´æÔÚÓÚRAMºÍCPUÖС£Êý¾Ý¿âÓÉ´ÅÅÌÉϵÄÎïÀíÎļþ×é³É¡£
ʵÀýÓëÊý¾Ý¿âµÄ¹ØÏµÊÇÒ»¶ÔÒ»µÄ£¬Ò»¸öʵÀýÁ¬½ÓÒ»¸öÊý¾Ý¿â£¬µ«Ò²ÓпÉÄÜÊǶà¶ÔÒ»µÄ£¬¼´²»Í¬¼ÆËã»úÉϵĶà¸öʵÀý´ò¿ª¹²Ïí´ÅÅÌϵͳÉϵÄÒ»¸ö¹«ÓÃÊý¾Ý¿â¡£ÕâÖÖ¶à¶ÔÒ»¹ØÏµ±»³ÆÎªÊµ¼ÊÓ¦ÓÃȺ¼¯£¨Real Application Clusters£¬¼òдΪRAC£©¡£
ÏÂÃæÎÒÃǸù¾ÝÕâÕÅͼ£¬À´ÏêϸÁË½â¹ØÓÚOracleµÄÌåϵ½á¹¹£º
1¡¢ÊµÀý£º´æ´¢½á¹¹Óë½ø³Ì
Ò»¸öOracleʵÀýÓÉÒ»¿é±»³ÆÎªÏµÍ³È«¾ÖÇø£¨System Global Area£¬¼òдΪSGA£©µÄ¹²ÏíÄÚ´æÒÔ¼°Èô¸É½ø³Ì×é³É¡£SGAÖÁÉÙ°üº¬¹²Ïí³Ø¡¢Êý¾Ý¿â¸ßËÙ»º´æÇø£¨Database Buffer Cache£©ÒÔ¼°ÈÕÖ¾»º³åÇøÕâÈýÖÖÊý¾Ý½á¹¹£¬´ËÍ⻹¿ÉÄܰüº¬´ó³Ø¡¢Java³Ø»òÁ÷³Ø¡£Æô¶¯ÊµÀý»áÈ·¶¨ÉÏÊöijЩSGA½á¹¹µÄ´óС£¬¶øÆäËûһЩSGA½á¹¹µÄ´óС¿ÉÒÔ¶¯Ì¬±ä»¯¡£²»¹ý£¬´´½¨Êý¾Ý¿âʱ²¢²»»áÈ·¶¨ÈκÎSGA½á¹¹µÄ´óС£¬ÎÒÃÇ¿ÉÒÔËæÊ±Í£Ö¹ºÍÖØÐÂÆô¶¯ÊµÀý£¬Ã¿´Î¶¼½«µÃµ½Ò»ÖÖÍêÈ«²»Í¬µÄÄÚ´æÅäÖá£
¼Çס£ºÈç¹ûÔÚÏÖ³¡ÏµÍ³ÖÐÆµ·±µØ¸Ä±äÄÚ´æÅäÖ㬲¢ÇÒ¶¼ÊôÓÚÐèÒª¹Ø±ÕʵÀýµÄ±ä»¯ÀàÐÍ£¬ÄÇÒԻ᲻¶Ï³öÏÖÍ£»ú£¬´Ó¶øÔì³ÉÖÕ¶ËÓû§µÄ²»Âú¡£
Òª²é¿´SGAµÄ´óС£¬ÎÒÃÇ¿ÉÒÔͨ¹ýÈçÏÂÓï¾ä£º
?[Copy to clipboard]View Code SQL
SQL> select * from v$sga;
NAME VALUE
-------------------- ----------
Fixed Size 1218868
Variable Size 79693516
Database Buffers 180355072
Redo Buffers 2973696
1.1¡¢¹²Ïí³Ø£¨Shared Pool£©
¹²Ïí³ØÊÇSGAÖÐ×î¹Ø¼üµÄÄÚ´æÆ¬¶Î£¬ÌرðÊÇÔÚÐÔÄܺͿÉÉìËõÐÔÉÏ¡£Ò»¸ö̫СµÄ¹²Ïí³Ø»á¶óɱÐÔÄÜ£¬Ê¹ÏµÍ³Í£Ö¹£¬Ì«´óµÄ¹²Ïí³ØÒ²»áÓÐͬÑùµÄЧ¹û£¬½«»áÏûºÄ´óÁ¿µÄCPUÀ´¹ÜÀíÕâ¸ö¹²Ïí³Ø¡£²»ÕýÈ·µÄʹÓù²Ïí³ØÖ»»á´øÀ´ÔÖÄÑ¡£¹²Ïí³ØÖ÷ÒªÓÖ¿ÉÒÔ·ÖΪÒÔÏÂÁ½¸ö²¿·Ö£º
¿â»º´æÇø£¨Library Cache£©£¬Ò²½ÐSQLÓï¾ä»º³åÇø¡£µ±Ò»¸öÓû§Ìá½»Ò»¸öSQLÓï¾ä£¬Oracle»á½«Õâ¾äSQL½øÐзÖÎö£¨Parse£©£¬Õâ¸ö¹ý³ÌÀàËÆÓÚ±àÒ룬»áºÄ·ÑÏà¶Ô½Ï¶àµÄʱ¼ä¡£ÔÚ·ÖÎöÍêÕâ¸öSQL£¬Oracle»á°ÑËûµÄ·ÖÎö½á¹û¸ø±£´æÔÚShared PoolµÄLibrary CacheÖУ¬µ±
Ïà¹ØÎĵµ£º
µÚÒ»Õ£ºÈÕÖ¾¹ÜÀí
1.forcing log switches
sql> alter system switch logfile;
2.forcing checkpoints
sql> alter system checkpoint;
3.adding online redo log groups
sql> alter database add logfile [group 4]
sql> ('/disk3/log4a.rdo','/disk4/log4b.rdo') size 1m;
4.adding online re ......
SELECT...FOR UPDATE Óï¾äµÄÓï·¨ÈçÏ£º
¡¡¡¡SELECT ... FOR UPDATE [OF column_list][WAIT n|NOWAIT][SKIP LOCKED];
ÆäÖУº
¡¡¡¡OF ×Ó¾äÓÃÓÚÖ¸¶¨¼´½«¸üеÄÁУ¬¼´Ëø¶¨ÐÐÉϵÄÌØ¶¨ÁС£
¡¡¡¡WAIT ×Ó¾äÖ¸¶¨µÈ´ýÆäËûÓû§ÊÍ·ÅËøµÄÃëÊý£¬·ÀÖ¹ÎÞÏÞÆÚµÄµÈ´ý¡£
¡¡¡¡“ʹÓÃFOR UPDATE WAIT&rd ......
Ö¸±êÃû³Æ
Ö¸±êÃèÊö
Ö¸±ê·¶Î§
Ö¸±êµ¥Î»
1£®¹ØÓÚʵÀýЧÂÊ£¨Instance Efficiency Percentages£©µÄÐÔÄÜÖ¸±ê
»º³åÇøÎ´µÈ´ýÂÊ
(Buffer Nowait %)
Ö¸ÔÚ»º³åÇøÖлñÈ¡BufferµÄδµÈ´ý±ÈÂÊ¡£
¸ÃÖ¸±êµÄÖµÓ¦½Ó½ü100%£¬Èç¹û¸ÃÖµ½ÏµÍ£¬Ôò¿ÉÄÜÒªÔö´óbuffer cache¡£
%
Redo»º³åÇøÎ´µÈ´ý ......
ÈçͼËùʾ£¬queryÓï¾äÖÐÈç¹ûûÓÐд \ £¬»á³öÏÖ£º
LRM-00112: ²ÎÊý 'query' ²»ÔÊÐíÓжà¸öÖµ
EXP-00019: ´¦Àí²ÎÊýʧ°Ü£¬ÓйذïÖúÇë¼üÈë 'EXP HELP=Y'
EXP-00000: µ¼³öÖÕֹʧ°Ü
exp system/system@oracledb file=d:\daochu.dmp tables=(store.jobs) query='where jobs.job like "w%"'
ÕâÑùÖ´ÐÐÈÔÈ»Èçͼʾ£¬¸ÃÔõô½â¾öÄØ£ ......
ÏëÔÚLinuxϵͳ°ÑOralce°²×°ºÃ£¬È·ÊµÊǸö²»Ð¡µÄÌôÕ½£¬×îÆðÂëµÄ£¬Ê×ÏÈÒª¶ÔLinuxϵͳÓÐËùÁ˽⣬²»Ëµ¶àµÄ£¬¼òµ¥µÄһЩÅäÖÃÎļþºÍ³£ÓÃÃüÁî×ÜÒªÖªµÀ£¬Òª²»Õæ²»ÖªµÀÈçºÎÏÂÊÖ¡£½ñÌì°´Êé±¾µÄÆôʾ£¬ºÍÍøÉϱðÈËдµÄÎÄÕ»¹ÓÐOralce¹Ù·½µÄ°ïÖú¸Ð¾õ¶¼¶ÔÎÒ°ïÖúÉõ΢°¡¡£¡£¡£²»¹ý¸Ð¾õ×îºó»¹ÊÇÔÚQQȺºÍ°Ù¶ÈµÄ°ïÖúÏ£¬µ±È»Êé±¾ºÍÄÇЩÎÄÕ¶¼Æðµ½ ......