×î½üÔÚ×ö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Ã
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    1¡¢ORA£12541£ºTNS£ºÃ»ÓмàÌýÆ÷ ¡¡¡¡
     ÔÒò£ºÃ»ÓÐÆô¶¯¼àÌýÆ÷»òÕß¼àÌýÆ÷Ë𻵡£Èç¹ûÊÇǰÕߣ¬Ê¹ÓÃÃüÁînet start OracleOraHome81TNSListener£¨Ãû×Ö¿ÉÄÜÓгöÈ룩¼´¿É£»Èç¹ûÊǺóÕߣ¬ÔòʹÓÓNet8 Configuration Assistant”¹¤¾ßÏòµ¼Ö®“¼àÌý³ÌÐòÅäÖÔÔö¼ÓÒ»¸ö¼àÌýÆ÷¼´¿É£¨»ù±¾²» ......
	
    
        
    
         À䱸·ÝÊý¾Ý±ØÐëÊÇÊý¾Ý¿â²»ÔÚopen״̬Ï¡£ ÒÔϲ½Öè»á¸ø³öÏêϸµÄ¹ý³Ì£º 
¡¡¡¡(1)£º ¹Ø±ÕDB £º shutdown immediate£» 
¡¡¡¡(2)£ºcopy oradataĿ¼ÏµÄËùÓÐÎļþ£¬ °üÀ¨Êý¾ÝÎļþ£¬ ¿ØÖÆÎļþ£¬redo£¬µÈ£¬»¹ÐèÒªcopy ÃÜÂëÎļþ ÔÚĿ¼ora92Ï µÄdatabase ÖеÄpwd Îļþ.È«²¿copyµ½Ò»¸ö°²È«Ä¿Â¼ÖС£ÔÚsql ......
	
    
        
    
    1¡¢µÇ¼·½·¨:£ºsys or systemµÇ¼
Õ˺ţºsystem
ÃÜÂ룺system as sysdba---------¡·ÃÜÂë+as sysdba
      conn system/password as sysdba
ʹÓÃÃüÁ
sql>alter user scott account unlock;
sql> commit;
Í ......
	
    
        
    
    OracleµÄÓÅ»¯Æ÷ÓÐÁ½ÖÖÓÅ»¯·½Ê½(ÕûÀí), 2010-04-13
RBO·½Ê½£º»ùÓÚ¹æÔòµÄÓÅ»¯·½Ê½(Rule-Based Optimization£¬¼ò³ÆÎªRBO)
  ÓÅ»¯Æ÷ÔÚ·ÖÎöSQLÓï¾äʱ,Ëù×ñѵÄÊÇOracleÄÚ²¿Ô¤¶¨µÄһЩ¹æÔò¡£±ÈÈçÎÒÃdz£¼ûµÄ£¬µ±Ò»¸öwhere×Ó¾äÖеÄÒ»ÁÐÓÐË÷Òýʱȥ×ßË÷Òý¡£ 
CBO·½Ê½£º»ùÓÚ´ú¼ÛµÄÓÅ»¯·½Ê½(Cost-Based Optimization£¬¼ò³ÆÎªCBO ......
	
    
        
    
    #!/bin/ksh
#****************************************************************************
#
# (C) Copyright CPIC. 2008
#
# File name:    check_db_alert.sh
# Project:      Database Alerts Check
#
# Parameter : app_name -- name of db application(=ora ......