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

×î½üÔÚ×öOracleÁÙʱ±í¼ÓÔØ ×ªÔØÒ»¸öÒÔ±ã²éѯ

×ªÔØ
DML statements on temporary tables do not generate redo logs for the data changes. However, undo logs for the data 
and redo logs for the undo logs are generated. Data from the temporary table is automatically 
dropped in the case of session termination, either when the user logs off or 
when the session terminates abnormally such as during a session or instance failure 
undo logs for the data and redo logs for the undo logs  Ç°Õß²»ÊÇ·ÅÔÚrollback segmentÖÐÂð?ÔõôÄÜдµ½redo logÖÐÈ¥ÄØ?
¸´£º ÁÙʱ±í´æ·ÅÔÚÄĶù£¿
ÁÙʱ±í¶Ôinsert/selectÐ͵ÄÓ¦ÓúÜÓÐÓᣠ
±ÈÈçÔÚ´¦Àíweb·­Ò³Ê±£¬¿ÉÒÔͨ¹ýÁÙʱ±íÀ´Ä£Äâcache·µ»Ø½á¹û¡£ 
ÏàÓ¦µÄ£¬ 
Èç¹ûÊÇupdate/select or delete selectÐ͵ÄÓ¦ÓÃʹÓÃÁÙʱ±íÊDz»Õ¼¶àÉÙÓÅÊÆµÄ¡£ 
ӦΪËäÈ»Æä²»Ö±½Óдredo£¬µ«»áͨ¹ýundo¼ä½Óдredo¡£ 
¶øinsertµÄundoÆäʵÊÇÓÃ¿Õ°×¿é»ØÐ´£¬¼¸ºõ²»Ð´redo¡£ 
ÏàÓ¦µÄupdate/deleteÐèÒª¶ÔÏà¹Ødb block×öcp undoµÄ²Ù×÷£¨ÌرðÊÇdelete£©£¬¶ÔÓ¦µÄredo¿ªÏúÒ²¶à¶àÁË¡£ 
»Ø¸´£º ÈçºÎÔÚÕû¸ösessionÖÐËø¶¨Ä³¸ö±í£¿-----------------------------7d335b34f403eaContent-Disposition
ÔÚOracle8i»òÒÔÉϰ汾ÖУ¬¿ÉÒÔ´´½¨ÒÔÏÂÁ½ÖÖÁÙʱ±í£º 
1¡£»á»°ÌØÓеÄÁÙʱ±í 
    CREATE GLOBAL TEMPORARY <TABLE_NAME> (<column specification>) 
    ON COMMIT PRESERVE ROWS£» 
2¡£ÊÂÎñÌØÓеÄÁÙʱ±í 
    CREATE GLOBAL TEMPORARY <TABLE_NAME> (<column specification>) 
    ON COMMIT DELETE ROWS£» 
   CREATE GLOBAL TEMPORARY TABLE MyTempTable 
Ëù½¨µÄÁÙʱ±íËäÈ»ÊÇ´æÔڵ쬵«ÊÇÄãÊÔÒ»ÏÂinsert Ò»Ìõ¼Ç¼ȻºóÓñðµÄÁ¬½ÓµÇÉÏÈ¥select£¬¼Ç¼Êǿյģ¬Ã÷°×Á˰ɣ¬ÎÒ°ÑÏÂÃæÁ½¾ä»°ÔÙÌùһϣº 
--ON COMMIT DELETE ROWS ˵Ã÷ÁÙʱ±íÊÇÊÂÎñÖ¸¶¨£¬Ã¿´ÎÌá½»ºóORACLE½«½Ø¶Ï±í£¨É¾³ýÈ«²¿ÐУ© 
--ON COMMIT PRESERVE ROWS ˵Ã÷ÁÙʱ±íÊǻỰָ¶¨£¬µ±ÖжϻỰʱORACLE½«½Ø¶Ï±í¡£ 
³åÍ»µÄÎÊÌâ¸ü±¾²»Óÿ¼ÂÇ. 
ÁÙʱ±íÖ»ÊDZ£´æµ±Ç°»á»°(session)Óõ½µÄÊý¾Ý£¬Êý¾ÝÖ»ÔÚÊÂÎñ»ò»á»°ÆÚ¼ä´æÔÚ¡£ 
ͨ¹ýCREATE GLOBAL TEMPORARY TABLEÃ


Ïà¹ØÎĵµ£º

ʹÓÃOracleÊý¾Ý¿â¹ý³ÌÖг£¼û´íÎó

1¡¢ORA£­12541£ºTNS£ºÃ»ÓмàÌýÆ÷ ¡¡¡¡
     Ô­Òò£ºÃ»ÓÐÆô¶¯¼àÌýÆ÷»òÕß¼àÌýÆ÷Ë𻵡£Èç¹ûÊÇǰÕߣ¬Ê¹ÓÃÃüÁînet start OracleOraHome81TNSListener£¨Ãû×Ö¿ÉÄÜÓгöÈ룩¼´¿É£»Èç¹ûÊǺóÕߣ¬ÔòʹÓÓNet8 Configuration Assistant”¹¤¾ßÏòµ¼Ö®“¼àÌý³ÌÐòÅäÖÔÔö¼ÓÒ»¸ö¼àÌýÆ÷¼´¿É£¨»ù±¾²» ......

OracleÊý¾Ý¿âÀ䱸·Ý»Ö¸´µÄ²½Öè

     À䱸·ÝÊý¾Ý±ØÐëÊÇÊý¾Ý¿â²»ÔÚopen״̬Ï¡£ ÒÔϲ½Öè»á¸ø³öÏêϸµÄ¹ý³Ì£º
¡¡¡¡(1)£º ¹Ø±ÕDB £º shutdown immediate£»
¡¡¡¡(2)£ºcopy oradataĿ¼ÏµÄËùÓÐÎļþ£¬ °üÀ¨Êý¾ÝÎļþ£¬ ¿ØÖÆÎļþ£¬redo£¬µÈ£¬»¹ÐèÒªcopy ÃÜÂëÎļþ ÔÚĿ¼ora92Ï µÄdatabase ÖеÄpwd Îļþ.È«²¿copyµ½Ò»¸ö°²È«Ä¿Â¼ÖС£ÔÚsql ......

OracleÊý¾Ý¿â½â³ýscottÓû§Ëø

1¡¢µÇ¼·½·¨:£ºsys or systemµÇ¼
Õ˺ţºsystem
ÃÜÂ룺system as sysdba---------¡·ÃÜÂë+as sysdba
      conn system/password as sysdba
ʹÓÃÃüÁ
sql>alter user scott account unlock;
sql> commit;
Í ......

OracleµÄÓÅ»¯Æ÷ÓÐÁ½ÖÖÓÅ»¯·½Ê½(Ò»)

OracleµÄÓÅ»¯Æ÷ÓÐÁ½ÖÖÓÅ»¯·½Ê½(ÕûÀí), 2010-04-13
RBO·½Ê½£º»ùÓÚ¹æÔòµÄÓÅ»¯·½Ê½(Rule-Based Optimization£¬¼ò³ÆÎªRBO)
  ÓÅ»¯Æ÷ÔÚ·ÖÎöSQLÓï¾äʱ,Ëù×ñÑ­µÄÊÇOracleÄÚ²¿Ô¤¶¨µÄһЩ¹æÔò¡£±ÈÈçÎÒÃdz£¼ûµÄ£¬µ±Ò»¸öwhere×Ó¾äÖеÄÒ»ÁÐÓÐË÷Òýʱȥ×ßË÷Òý¡£
CBO·½Ê½£º»ùÓÚ´ú¼ÛµÄÓÅ»¯·½Ê½(Cost-Based Optimization£¬¼ò³ÆÎªCBO ......

oracle ±¸·Ý,±í¿Õ¼ä¼ì²éshell½Å±¾´úÂë

#!/bin/ksh
#****************************************************************************
#
# (C) Copyright CPIC. 2008
#
# File name:    check_db_alert.sh
# Project:      Database Alerts Check
#
# Parameter : app_name -- name of db application(=ora ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ