28.1 Oracle 11g¼ò½é
28.1 Oracle 11g¼ò½é
¾¹ýÁËÈýÄêµÄ×¼±¸£¬Oracle£¨¼×¹ÇÎÄ£©¹«Ë¾ÓÚ2007Äê7ÔÂ12ÈÕÔÚÈ«Çò·¶Î§ÄÚͬ²½ÍƳöÁËÆä×îа汾µÄÊý¾Ý¿â²úÆ·——Oracle 11g¡£ÐµÄOracleÊý¾Ý¿âÈÔÈ»ÒÔg×÷Ϊ°æ±¾ºó׺£¬ÒÔ´ú±íÕâÊÇÒ»¸ö°üº¬ÁËÍø¸ñ¼ÆËã¼¼ÊõµÄÊý¾Ý¿âÈí¼þ£¨Oracle×Ô10°æ±¾¿ªÊ¼ÒÔg×÷Ϊ°æ±¾ºó׺£¬¶øÔÚÕâ֮ǰÊÇʹÓÃi£¬ÈçOracle 8i¡¢Oracle 9i£¬±íʾ»ùÓÚÍøÂçµÄÊý¾Ý¿â£©¡£¾ÝϤ£¬Ð°汾µÄÊý¾Ý¿â¾¹ýÁË1500ÍòСʱµÄ²âÊÔ£¬¿ª·¢¹¤×÷Á¿Ï൱ÓÚ1000Ãû¿ª·¢ÈËÔ±Á¬ÐøÑз¢3Äê¡£
ÓëÆäÉÏÒ»¸ö°æ±¾10gÏà±È½Ï£¬Oracle 11gÖÐÔö¼ÓÁ˺ܶ༤¶¯ÈËÐĵÄй¦Äܼ°ÐÂÌØÐÔ£¬´ó·ùµØÌá¸ßÁËϵͳÐÔÄܼ°°²È«ÐÔ¡£¸ÅÀ¨À´Ëµ£¬Ö÷ÒªÓÐÒÔϼ¸¸ö·½Ãæ¡£
1£®Êý¾Ý¿â¹ÜÀí
q ÖØÑݹ¦ÄÜ£¬¿É´ÓÊý¾Ý¿âºÍSQLÁ½¸ö¼¶±ð²¶×½¸ºÔز¢½øÐÐÄ£Äâ¡£
q ¼Æ»®¹ÜÀí¹¦ÄÜ£¬¹Ì¶¨SQLÓï¾äµÄÖ´Ðмƻ®¡£
q ×Ô¶¯Õï¶Ï֪ʶ¿â£¬²¶×½ºÍ¼Ç¼ϵͳÖØÒª´íÎó£¬×Ô¶¯·¢ËÍÐÅÏ¢¸øDBA£¨Êý¾Ý¿â¹ÜÀíÔ±£©»òOracleÖ§³ÖÍŶӡ£
q ʼþ´ò°ü·þÎñ£¬°ÑÓëijһʼþÏà¹ØµÄÐÅÏ¢´ò°ü£¬²¢¿É·¢Ë͸øOracleÖ§³ÖÍŶӡ£
q ÔöÇ¿µÄ²¹¶¡¹¦ÄÜ£¬°´ÌØÐÔ¶Ô²¹¶¡½øÐзÖÀ࣬ͨ¹ýÆóÒµ¹ÜÀíȨ¿É¶©ÔÄ»ùÓÚÌØÐԵIJ¹¶¡·þÎñ¡£
2£®ÐÔÄÜ
q ×Ô¶¯SQLÓÅ»¯¹¦ÄÜ£¬Ê¹SQLµÄÖ´ÐÐЧÂÊ¿É»ñµÃÔÐÔÄÜ3±¶µÄÌá¸ß¡£
q ×Ô¶¯ÄÚ´æÓÅ»¯¹¦ÄÜ£¬ËùÓÐÄÚ´æÇø¾ùÓÉOracle×Ô¶¯¹ÜÀíºÍ·ÖÅä¡£
q ¸üеÄ×ÊÔ´¹ÜÀíÆ÷£¬¶ÔCPUºÍIO½øÐйÜÀí¡£
q ADDM£¬¿É¶Ôµ¥¸öʵÀý¼°Õû¸öRAC¸ø³ö½¨Ò飬Ҳ¿ÉÒÔ×ÔÐÐÉ趨¹ØÐĵÄÐÅÏ¢¡£
q ·ÃÎʽ¨ÒéÆ÷£¬¿ÉÌṩ¸üÇ¿µÄ·ÖÇø½¨Ò鹦ÄÜ¡£
3£®PLSQL
q »º´æ½á¹û¼¯£¬´ó´óÌá¸ßÁËSQL²éѯËٶȡ£
q еÄSQLÓï·¨“=>”£¬ÔÚ·ÇDMLµÄSQLÓï¾äÖпÉʹÓÃÐòÁС£
q ¸Ä½øµÄ¶ÔÏóÒÀÀµ¹Øϵ£¬±íÊôÐԵĸı䲻»áµ¼Öº¯ÊýºÍÊÓͼÎÞЧ¡£
q ¶ÔTCP°ü½øÐа²È«¿ØÖÆ¡£
q ¸Ä½øµÄÕýÔò±í´ïʽ¡£
q ¸ü¸ßµÄ´¥·¢Æ÷ЧÂÊ¡£
q Ö§³Ö¶à´¥·¢Æ÷µÄÖ´ÐÐ˳Ðò¶¨Òå¡£
q &nbs
Ïà¹ØÎĵµ£º
1¡¢pfile Îı¾Îļþ client¶Ë²ÎÊýÎļþ£»²»Äܶ¯Ì¬Ð޸ģ¬¿ÉÒÔÓÃÆÕͨµÄ±à¼Æ÷Ð޸ģ¬ÐÞ¸ÄÖ®ºóÐèÒªÖØÆô¡£pfile¿ÉÄܻᵼÖ·þÎñÆ÷Æô¶¯²»Ò»Ö£¬ÒòΪ¿ÉÒÔÔÚ¿Í»§¶ËÆô¶¯¡£ 2¡¢spfile ¶þ½øÖÆÎļþ·þÎñÆ÷¶Ë²ÎÊýÎļþ£¬ÓÐÁËspfile£¬oracle¿ÉÒÔʵÏÖ¶¯Ì¬²ÎÊýÔÚÏßÐ޸ģ¬²¿·Ö²ÎÊýÐÞ¸ÄÖ®ºóÎÞÐèÖØÆô¡£µ«ÊÇ£¬ÒòΪÊǶþ½øÖÆÎļþ£¬ËùÒÔ²»ÄÜÓÃÆÕͨµÄ±à¼ ......
ÇëÎÊÏÂ,ÎÒɾ³ý±íµÄijЩÊý¾Ý,ÈçºÎ°ÑËüÉÁ»ØÀ´Ñ½? 20·ÖÖÓÄÚ²»¹ý¶Ô¸Ã±íÓɲåÈëÁËЩÊý¾Ý
¸ù¾ÝscnºÅÀ´²éѯ
select a, b, c, versions_xid, versions_starttime, versions_endtime,
versions_startscn,versions_endscn,versions_operation
from test versions between scn 339493 and 339635
¸ù¾Ýʱ¼äÒ²¿ÉÒÔ
from te ......
. ´´½¨job
jobÊÇʲôÄØ? ¼òµ¥µÄ˵¾ÍÊǼƻ®(schedule)¼ÓÉÏÈÎÎñ˵Ã÷. ÁíÍ⻹ÓÐһЩ±ØÐëµÄ²ÎÊý.
ÕâÀïÌáµ½µÄ"ÈÎÎñ"¿ÉÒÔÊÇÊý¾Ý¿âÄÚ²¿µÄ´æ´¢¹ý³Ì,ÄäÃûµÄPL/SQL¿é,Ò²¿ÉÒÔÊDzÙ×÷ϵͳ¼¶±ðµÄ½Å±¾.
¿ÉÒÔÓÐÁ½ÖÖ·½Ê½À´¶¨Òå"¼Æ»®":
1) ʹÓÃDBMS_SCHDULER.CREATE_SCHEDULE ¶¨ÒåÒ»¸ö¼Æ»®;
2) µ÷ÓÃDBMS_SCHDULER.CREATE_JOBE¹ý³ÌÖ±½ÓÖ¸¶ ......
ÒòΪҵÎñÐèÒª,ÐÞÒªÐÞ¸Äij¸ö×Ö¶ÎÊý¾ÝÀàÐÍÓÐnumber(5),±äΪnumber(5,2)ÐÍ
ÒªÊÇûÓÐÊý¾ÝµÄ»°Ö±½ÓÓÃÒÔÏÂÓï¾ä¼´¿É
alter table tb_test modify permile number(5,2);
µ«ÊÇÓÐÊý¾ÝµÄ»° ¾Í²»ÄÜÓÃÉÏÃæ·½·¨ÁË,
alter table tb_test add permile_temp number(5,2)
update tb_test set permile_temp=permile;
alter t ......
ÏÈ×°ÁËÊý¾Ý¿â£¬ÓÃnetµ÷ÊÔµÄʱºòûÓÐÎÊÌ⣬µ«ÊÇÉú³ÉÍøÕ¾ºó£¬ÔÚÁ¬½ÓÊý¾Ý¿âµÄʱºòÌáʾ˵¿Í»§¶ËµÄ°æ±¾Ì«µÍ£¨Òâ˼¾ÍÊÇÕâ¸ö£©£¬ºóÓÖ×°ÁËÒ»¸ö9iµÄ¿Í»§¶Ë£¬Ö®ºó¾Í°ÑÏà¹Ø·þÎñ¸Ä³ÉÊÖ¶¯£¬NÌìÖ®ºó·¢ÏÖÊý¾Ý¿â²»ÄÜÕý³£Æô¶¯¡£
Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracl ......