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

oracleÓÅ»¯ »º´æ¶ÔÏóÓëÊý¾Ý

author£ºskate
time£º2010/03/16
µ±ÏµÍ³³öÏÖÐÔÄÜÆ¿¾±Ê±£¬¾¡Á¿½ÏÉÙ²»±ØÒªµÄ×ÊÔ´ÏûºÄ£¬×îºó¾ÍÊÇÆ½ºâcpu£¬Äڴ棬io£¬networkµÈ×ÊÔ´£¬Ê¹Êý¾Ý¿â
¿ÉÒÔÎȶ¨µÄÔËÐС£
oracleÊý¾Ý¿âÓÅ»¯µÄ¸ù±¾ÊÇ
1.¾¡Á¿¼õÉÙ×ÊÔ´ÏûºÄ£¬ÀýÈçÓÅ»¯sql£¬¼õÉÙsql±¾ÉíµÄ×ÊÔ´ÏûºÄ
2.Èç¹ûÎÞ·¨½øÒ»²½¼õÉÙ×ÊÔ´µÄÏûºÄ£¬ÄǾÍÈÃÊý¾Ý¾¡Á¿¿¿½ücpu£¬Ò²¾ÍÊǰÑÊý¾Ý´ÓÓ²ÅÌ×ªÒÆµ½Äڴ棨ÄÚ´æµÄ¶ÁдËٶȿ죩
  »òÕß»»¸ü¿ìµÄ´ÅÅÌ
±¾Îľͼòµ¥×ܽáÏÂÈçºÎ»º´æÊý¾ÝºÍÊý¾Ý¿â¶ÔÏó£¨Ò²¾ÍÊǰÑÊý¾ÝÒÆÏòÄڴ棬Ìá¸ßÄÚ´æµÄÃüÖÐÂÊ£¬ÒÔÌá¸ßÕûÌåioËÙ¶È£©
1.»º´æÊý¾Ý
2.»º´æÊý¾Ý¶ÔÏóµÄ¶¨Ò壬ÀýÈçpackage£¬procedure£¬pl/sqlºÍsql£¨Ò²¾ÍÊÇcursor£©µÈ
ÉÏÃæËµµÄÕâÁ½ÖÖÊý¾Ý¾Í´æÔÚoracle×îÖØÒªµÄÁ½¸ö²¿¼þÖÐshare poolºÍbuffer poolÖУ¬Ìá¸ßÕâÁ½¸öpoolµÄÃüÖÐÂÊÒ²Ìá¸ßÁË
ioËÙ¶È£¬¶øioÓÖÊǵ±½ñ¼¼Êõ·¢Õ¹×îÂý£¬ÏµÍ³µÄ×î´óµÄÆ¿¾±¡£
1. »º´æÊý¾Ý
ÕâÀï˵µÄoracleÊý¾ÝÊÇÕ¼´óÁ¿´æ´¢¿Õ¼äµÄ£¬²»ÊÇ´æÔÚÊý¾Ý¿â×ÖµäÀïµÄÊý¾Ý£»oracleµÄÊý¾ÝµÄÀàÐÍÒ»°ãΪ£º
SQL> select se.segment_type from dba_segments se group by se.segment_type;
SEGMENT_TYPE
------------------
LOBINDEX
INDEX PARTITION
TABLE PARTITION
NESTED TABLE
ROLLBACK
LOB PARTITION
LOBSEGMENT
INDEX
TABLE
CLUSTER
TYPE2 UNDO
11 rows selected
SQL>
Ôڴ󲿷Öʱºò£¬°ÑÕâЩÊý¾Ý·Åµ½ÄÚ´æÀ»áºÜ´óµÄÌáÉýϵͳµÄÐÔÄÜ
buffer pool·ÖΪÈý¸ö×Ópool£¬ÕâÈý¸öpool¶¼Ö÷ҪʹÓÃLRUËã·¨¹ÜÀíµÄ
default buffer pool£ºÄ¬ÈÏËùÓеÄÊý¾Ý¿é¶¼´æÔÚÕ⣬²¢×ñÑ­±¾poolµÄLRUËã·¨
keep buffer pool£ºÈç¹ûÖ¸¶¨Êý¾Ý¿é»º´æµ½keepÇøµÄ£¬Êý¾Ý¿é¾Í²»Ì«¿ÉÄÜÒòΪִÐÐÆäËûһЩ²Ù×÷±»ÆäËûÊý¾Ý¿é½»»»³ö£¬¼´Ê¹½Ï³¤Ê±¼äûʹÓÃÁË£¬Ö»×ñÑ­±¾poolµÄLRU
recycle buffer pool£ºÉèÖÃrecycleÊÇÒòΪÓÐʱ»áÓÐһЩ´óµÄÓÖ½ÌÉÙʹÓõıíµÄ²Ù×÷£¬Èç¹û²»ÉèÖõ¥¶ÀµÄ»º´æÇø£¬ÄÇôȱʡµÄ»º´æÇøÖеÄÊý¾Ý¿é¾Í±»ÕâЩż¶ûʹÓõÄÊý¾Ý»»³ö£¬ËüµÄ¿Õ¼ä±È½ÏС£¬ËùÒÔ˵һ°ãʹÓÃÍê¾ÍÊͷŵôÁË£¬ËüÒ²Ö»×ñÊØ±¾poolµÄLRUËã·¨
ÒÔtableΪÀý£º
ÐÞ¸ÄtableµÄ»º´æ¿Õ¼ä
alter table a_user storage(buffer_pool keep) cache/nocache;  ---°Ñ±ía_user»º´æµ½keep buffer poolÖÐ×îÈȶË/°Ñ±ía_user´Ókeep buffer poolÁ¢¿ÌÊͷųöÈ¥
alter table a_user cache/nocache  ---°Ñ±ía_user»º´æµ½default buffer poolÖÐ×îÈȶË/°Ñ±ía_user´Ódefault buffer poolÁ¢¿ÌÊͷųöÈ¥
eg£º
1)
SQL> alter t


Ïà¹ØÎĵµ£º

OracleÆô¶¯¹ý³ÌÏê½â ½éÉܼ°ÃüÁ»¹ÓйرÕ

OracleÆô¶¯¹ý³Ì½éÉܼ°ÃüÁ»¹Óйرա£
дÔÚÇ°Ãæ£ºÆô¶¯Êý¾Ý¿âǰ£¬ÇëÏÈÆô¶¯¼à³ÌÐò¡£
lsnrctl start
Æô¶¯µÄÈý¸ö²½Ö裬ÒÀ´ÎΪ1.´´½¨²¢Æô¶¯ÊµÀý¡¢2.×°ÔØÊý¾Ý¿â¡¢3.´ò¿ªÊý¾Ý¿â¡£
¿ÉÒÔͨ¹ýÃüÁîstartupÀ´ÊµÏÖ¡£
startup ÃüÁî¸ñʽ
startup [ nomount | mount | open | force ] [ restrict ] [ pfile=filename ];
·½·¨1 -- st ......

cmdÃüÁî¶Ôoracle±¸·Ý»Ö¸´

oracleµÄµ¼Èëµ¼³öÃüÁîÖ±½ÓÓÃcmd¾Í¿ÉÒÔÍê³É£¬µ¼³öµÄÎļþµØÖ·¾ÍÊÇcmdµÄµØÖ·£¬cmdµÄԭʼµØÖ·¿ÉÒԸģ¬ÔËÐÐcd ..Í˻ص½Éϼ¶Ä¿Â¼  cd¿Õ¸ñ¼ÓĿ¼Ãû Êǵ½Ï¼¶Ä¿Â¼ ÊäÈëD£º»Ø³µ¾Í¿ÉÒÔÖ±½Óµ½dÅÌ
exp Óû§Ãû/ÃÜÂë@Êý¾Ý¿âÃû file=ÐèÒª±£´æµÄÎļþ.dmp tables=£¨A±í,B±í....£© log=ÈÕÖ¾.log
exp jjeto_eim_user/jjetoeimuser@EIM ......

Oracle 10g SQL*PlusÃüÁîʵ¼ù


1¡¢Á¬½ÓOracleÊý¾Ý¿â
Æô¶¯SQL*Plus£¬ÒªÇóÊäÈëUser Name¡¢Password¡¢Host StringÕâÈý¸ö²ÎÊý£¬ÀýÈçÎÒÔÚ°²×°µÄʱºòĬÈÏ´´½¨µÄÊý¾Ý¿âΪorcl£¬Ò²¾ÍÊÇSID£¬ÃÜÂëҲΪorcl£¬¶ÔÓ¦ÉÏÃæµÄÈý¸ö²ÎÊýÈçÏÂËùʾ£º
User Name£ºorcl
Password£ºorcl
Host String£ºorcl as sysdba
¾Í¿ÉÒԵǼ³É¹¦¡£
»òÕßÒ²¿ÉÒÔʹÓÃĬÈϵÄscottÀ´µÇ¼£º ......

db2,oracle,mysql³£ÓÃÃüÁî±È½Ï


¡¶oracle,db2,mysqlÀà±È¡·×÷ΪÈýÖÖÊý¾Ý¿âÒ»¸öÀà±È£¬Ä¿µÄÔÚÓÚͨ¹ýÀà±È£¬Á˽âÏÖÔÚÊý¾Ý¿âÏàËÆµãÓëÒìͬµã£¬Í¬Ê±¿ÉÒÔ°ïÖú´ó¼ÒÔÚÁ˽âÒ»ÖÖÊý¾Ý¿â£¬Äܹ»Ñ¸ËÙµØÑ§»áÆäËûÊý¾Ý¿â¡£³õ²½¶¨ÒåΪoracle,db2,mysqlÈýÖÖÊý¾Ý¿â£¬ÒÔºó¿ÉÄÜ»¹ÊÇ×·¼Óinformix,sysbase,sql serverµÈÊý¾Ý¿â¡£
±¾Æª×÷ΪÊׯª£¬Ä¿µÄÊÇÈôó¼Ò¶ÔÕâÈýÖÖÊý¾Ý¿â³£ÓõÄÖªÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ