Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 BI µÄETLµÄһЩ×ܽá

ÎÒ¶ÔORACLE BI µÄETLµÄһЩ×ܽᣨԭ£© ÊÕ²Ø
http://blog.chinaunix.net/u/25176/showart_2036107.html
Êý¾Ý²Ö¿âÖеÄETLÏêϸµÄ·ÖΪËĸö½×¶Î£ºÌáÈ¡£¬´«Ê䣬ת»»£¬×°ÔØ¡£ÎÒÏȼòµ¥µÄ½éÉÜÒ»ÏÂÌáÈ¡ºÍ´«ÊäµÄ·ÖÀàºÍ·½·¨£º
Ò»£ºÌáÈ¡
   ÌáÈ¡¿ÉÒÔ·ÖΪÂß¼­ÌáÈ¡£¬ºÍÎïÀíÌáÈ¡¡£
   1£ºÂß¼­ÌáÈ¡°´ÕÕ¹æÄ£·ÖΪ£ºÍ ......

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

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

rlwrapʹÓ÷½·¨£¨oracleµÄÖ¸ÁîÉÏÏ·­頁¹¤¾ß£©

rlwrapʹÓ÷½·¨
¹Ø¼ü×Ö: rlwrapʹÓ÷½·¨
ÔÚWindows²Ù×÷ϵͳÉÏ,µ±ÔÚDOSÃüÁî´°¿ÚÖÐÔËÐÐSQL*PlusµÄʱºò,¿ÉÒÔʹÓÃÏòÉÏ,ÏòϼüÀ´Ìø»ØÖ®Ç°ÒѾ­Ö´ÐйýµÄSQLÓï¾ä.Äã¿ÉÒÔ¸ù¾ÝÐèÒªÐÞ¸ÄËûÃÇ,È»ºó°´Enter¼üÖØÐÂÌá½»Ö´ÐÐ.
È»¶ø,µ±ÔÚLinux ShellÖÐÔËÐÐSQL*PlusµÄʱºò,²¢²»Ìṩä¯ÀÀÀúÊ·ÃüÁîÐеŦÄÜ.
ΪÁËÔÚLinuxÖдﵽͬÑùµÄÄ¿µÄ,Ä ......

Oracle °Ù·Ö±È

ÈÕǰÓöµ½Ò»¸öÎÊÌ⣬ÐèÒª¶ÔÔÚOracleÊý¾Ý¿âÖвéѯ³öÀ´µÄÊýÖµ½øÐбÈÂʵļÆËã¡£ÀàËÆÓÚÈçϵÄSQL£º
Select Round((discount/Amount),2) from dual;
ÕâÑùËã³öÀ´µÄÊý×Ö¿ÉÒÔÂú×ã¾ø´ó²¿·ÖµÄÐèÇó¡£µ«ÊǶÔÓÚ²»µ½1µÄÊý×Ö£¬ÎÊÌâ³öÀ´ÁË......ÏÔʾµÄÀàËÆÓÚ .45Ñù×ÓµÄÊý¾Ý¡£0.45Ç°ÃæµÄ0²»¼ûÁË¡£
ÒÔÏÂ×ܽáÁËÁ½ÖÖ·½·¨À´½â¾öȱ0µÄÎÊÌâ¡£
µÚ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ