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

oracleÖеÄÉÁ±í¹¦ÄÜ

1.Èç¹ûÄãÎóɾ³ýÁËÊý¾Ý,²»Óú¦ÅÂ,¶Ìʱ¼äÄÚ»¹ÊÇ¿ÉÒÔ»Ö¸´µÄ.
select * from (select * from claim_monitor_dispatch as of timestamp to_date('20091203 08:30:00','yyyymmdd hh24:mi:ss')
)
where to_char(created_date,'yyyymmdd')='20090707'
2.Îóɾ³ý±íÖ®ºóµÄ»Ö¸´,»Ö¸´ÕûÕűí
 flashback table name before drop
3.Îóɾ³ýµÄÊý¾ÝÖ÷Ҫȡ¾öÓڻعö¶Î¿Õ¼äµÄ´óС,ÒÔ¼°±£ÁôµÄʱ¼ä,Á½¸öÖ¸±ê. ÓÃDBAÕʺÅÁ¬ÈëÊý¾ÝºóÓÃÒÔÏÂÃüÁî¿É²é¿´.
show parameter undo


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

Oracle ÈÕÆÚ/ʱ¼äµÄÏà¹Ø²Ù×÷

¡¡¡¡±¾ÎĽéÉÜÁËÔÚOracleÊý¾Ý¿âÖУ¬¶ÔÈÕÆÚ¡¢Ê±¼äµÄ¸÷ÖÖ²Ù×÷£¬°üÀ¨£ºÈÕÆÚʱ¼ä¼ä¸ô²Ù×÷¡¢ÈÕÆÚµ½×Ö·û²Ù×÷¡¢×Ö·ûµ½ÈÕÆÚ²Ù×÷¡¢trunk / ROUNDº¯ÊýµÄʹÓᢺÁÃë¼¶µÄÊý¾ÝÀàÐ͵ȡ£
1.ÈÕÆÚʱ¼ä¼ä¸ô²Ù×÷
¡¡¡¡µ±Ç°Ê±¼ä¼õÈ¥7·ÖÖÓµÄʱ¼ä
¡¡¡¡select sysdate,sysdate - interval '7' MINUTE from dual
¡¡¡¡µ±Ç°Ê±¼ä¼õÈ¥7СʱµÄʱ¼ä
¡¡¡ ......

linuxϰ²×°oracle10xe°æ

radhat 5.2ϰ²×°oracle10g
1¡¢ÏµÍ³ÐèÇó£º
Äڴ棺ÖÁÉÙ512mb£¬ÍƼöÓÃ1g£»
Ó²ÅÌ£º·þÎñÆ÷ÖÁÉÙ60g£»
£¨Ò»°ãÇé¿öÏÂÓ²¼þ¶¼ÄÜ·ûºÏÒªÇó£©
Èí¼þ°ü£ºglibc-2.3.2, libaio-0.3.96
½»»»¿Õ¼ä:
RAM: 0~256MB,   SWAP: 3 ±¶ RAM ´óС
RAM: 256~512MB,  SWAP: 2 ±¶ RAM ´óС
RAM: >=512MB,   SWAP: 10 ......

ORACLE JOBS

³£ÒªoracleÊý¾Ý¿â¶¨Ê±µÄ×Ô¶¯Ö´ÐÐһЩ½Å±¾£¬»ò×öÊý¾Ý¿â±¸·Ý£¬»ò×öÊý¾ÝµÄÌáÁ¶£¬»ò×öÊý¾Ý¿âµÄÐÔÄÜÓÅ»¯£¬°üÀ¨Öؽ¨Ë÷ÒýµÈµÈµÄ¹¤×÷,ÕâʱÐèÒªÓõ½Ò»¸öº¯Êýdbms_job.submit£¬À´Íê³ÉOracle¶¨Ê±Æ÷Jobʱ¼äµÄ´¦ÀíÉÏ¡£Ê¹ÓÃdbms_job.submitÕâ¸öº¯Êý£¬ÎÒÃÇÖ»ÐèÒª¿¼ÂÇÁ½¸öÊÂÇ飺°²ÅÅijһÈÎÎñ£¬ºÍ¶¨ÖÆÒ»¸öÖ´ÐÐÈÎÎñµÄʱ¼äµã¡£µ«×îÖØÒªÒ²ÊÇ× ......

OracleÃæÊÔ¹ý³ÌÖг£¼ûµÄ¶þÊ®¸öÎÊÌâ

       QQ:1156316388      Tel:010-51527259
1.À䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
    ½â´ð£ºÈȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐģʽµÄÊý¾Ý¿â¡£Èȱ¸·ÝµÄÓŵã ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ