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

Oracle¹éµµÈÕÖ¾¹ÜÀí


²é¿´µ±Ç°Êý¾Ý¿â¹éµµÈÕÖ¾²Ù×÷ģʽ:
select name,log_mode from v$database;
²é¿´¹éµµÈÕ־λÖÃ:
show parameter log_archive_dest; µÚÒ»¸ö¹éµµÎ»ÖÃ
show parameter log_archive_duplex_dest; µÚ¶þ¸ö¹éµµÎ»ÖÃ
ÏȹرÕÊý¾Ý¿â,È»ºó×°ÔØÊý¾Ý¿â:
shutdown immediate;
startup mount;
Ð޸Ĺ鵵ÈÕÖ¾²Ù×÷ģʽ,È»ºó´ò¿ªÊý¾Ý¿â:
alter database archivelog;
alter database open;
(archivelog:ÆôÓù鵵ÈÕ־ģʽ,noarchivelog:·Ç¹éµµÈÕ־ģʽ)


Ïà¹ØÎĵµ£º

oracle´¦Àíʱ¼äµÄ³£Óú¯Êý

36.ADD_MONTHS
¡¡¡¡Ôö¼Ó»ò¼õÈ¥Ô·Ý
¡¡¡¡SQL> select to_char(add_months(to_date(199912,yyyymm),2),yyyymm) from dual;
¡¡¡¡TO_CHA
¡¡¡¡------
¡¡¡¡200002
¡¡¡¡SQL> select to_char(add_months(to_date(199912,yyyymm),-2),yyyymm) from dual;
¡¡¡¡TO_CHA
¡¡¡¡------
¡¡¡¡199910
¡¡¡¡37.LAST_DAY
¡¡¡¡·µ» ......

Oracle³£ÓòÙ×÷±Ê¼Ç

select name from v$datafile;
create dataspace tablespace datafile '/oracle/oradata/orcl/data01.dbf' size 1024m,'/oracle/oradata/orcl/data02.dbf' size 1024m autoextend on next 100m maxsize unlimited;
alter tablespace dataspace add datafile '/oracle/oradata/orcl/da ......

oracleÓësql server¶Ô±È·ÖÎö

±¾ÒëÎIJÉÓÃ֪ʶ¹²ÏíÊðÃû-·ÇÉÌÒµÐÔʹÓÃ-Ïàͬ·½Ê½¹²Ïí 3.0 UnportedÐí¿ÉЭÒé·¢²¼£¬×ªÔØÇë±£Áô´ËÐÅÏ¢
ÒëÕߣºÂí³ÝÜÈ | Á´½Ó£ºhttp://www.dbabeta.com/2010/oracle-sql-server-comparison-i.html
×÷ÕߣºSadequl Hussain | Ô­ÎÄ£ºhttp://www.sql-server-performance.com/articles/dba/oracle_sql_server_comparison_p1.aspx
Ò» ......

Oracle Listener ¶¯Ì¬×¢²á Óë ¾²Ì¬×¢²á

Ò»£®Ê²Ã´ÊÇ×¢²á
×¢²á¾ÍÊǽ«Êý¾Ý¿â×÷Ϊһ¸ö·þÎñ×¢²áµ½¼àÌý³ÌÐò¡£¿Í»§¶Ë²»ÐèÒªÖªµÀÊý¾Ý¿âÃûºÍʵÀýÃû£¬Ö»ÐèÒªÖªµÀ¸ÃÊý¾Ý¿â¶ÔÍâÌṩµÄ·þÎñÃû¾Í¿ÉÒÔÉêÇëÁ¬½Óµ½Êý¾Ý¿â¡£Õâ¸ö·þÎñÃû¿ÉÄÜÓëʵÀýÃûÒ»Ñù£¬Ò²ÓпÉÄܲ»Ò»Ñù¡£
¡¡¡¡ÔÚÊý¾Ý¿â·þÎñÆ÷Æô¶¯¹ý³ÌÖУ¬Êý¾Ý¿â·þÎñÆ÷»áÏò¼àÌý³ÌÐò×¢²áÏàÓ¦µÄ·þÎñ£¨ÎÞÂÛºÎʱÆô¶¯Ò»¸öÊý¾Ý¿â£¬Ä¬Èϵض¼ ......

SELECT ... FOR UPDATE£¨WAIT/NOWAIT£©ÃüÁîÓëORACLEËø

oracleËøµÄÅŶӻúÖÆ£º
 
 
 
ÇëÇóËø¶¨ÐèÒªÅŶӡ£Èç¹ûij¸ö»á»°ÇëÇóÒ»¸öËø¶¨£¬µ«ÊÇÓÉÓÚÆäËû»á»°ÒѾ­Ëø¶¨ÁËÖ¸¶¨¼Ç¼»ò¶ÔÏó¶øÎÞ·¨»ñµÃËùÐèµÄËø¶¨£¬ÄÇôÕâ¸ö»á»°½«»áµÈ´ý¡£´Ëʱ£¬¿ÉÄܶà¸ö»á»°¶¼Ôڵȴý·ÃÎÊÏàͬ¼Ç¼»ò¶ÔÏó£¬ÔÚÕâÖÖÇé¿öÏ£¬ORACLE»á¸ú×ÙÕâЩ»á»°ÇëÇóËø¶¨µÄ˳Ðò¡£
 
 
 
Èç¹û ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ