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

OracleÖØ×öÈÕÖ¾Îļþ³£ÓòÙ×÷

Ç¿ÖÆÇл»ÖØ×öÈÕÖ¾
ALTER SYSTEM SWITCH LOGFILE; Ç¿ÖƲúÉú¼ì²éµã
ALTER SYSTEM CHECKPOINT; ¼ä½Ó²úÉú¼ì²éµã(É趨ʵÀý»Ö¸´Ê±¼ä²»³¬¹ýmmÃë,Ò༴ִÐмì²éµãÖ®ºóÔËÐг¬¹ýÕâ¸öʱ¼ä¾ÍÔÙ´ÎÖ´Ðмì²éµã)
ALTER SYSTEM SET FAST_START_MTTR_TARGET = ÃëÊý; »ñÈ¡ÖØ×öÈÕÖ¾ÎļþÐÅÏ¢
SELECT group#, sequence#, members, bytes, status, archived from v$log;
ÅäºÏ
SELECT * from v$logfile; Ìí¼ÓÖØ×öÈÕÖ¾×é
ALTER DATABASE ADD LOGFILE GROUP 5 ('a:\nihao.log', 'b:\zaijian.log') SIZE 20M;

ÆäÖÐGROUP¶Î¿ÉÒÔûÓÐ,еÄ×éºÅ×Ô¶¯²úÉú,¼´µ±Ç°×î´ó×éºÅ+1 ɾ³ýÖØ×öÈÕÖ¾×é
ALTER DATABASE DROP LOGFILE GROUP 5;

×¢Òâ: µ±Ç°ÖØ×öÈÕÖ¾×é²»¿Éɾ³ý,±¾É¾³ý²¢Î´ÕæÕýµÄɾ³ýÓ²ÅÌÉϵÄÎļþ. Ìí¼ÓÖØ×öÈÕÖ¾³ÉÔ±
ALTER DATABASE ADD LOGFILE MEMBER 'a:\nihao.log' TO GROUP 5, 'b:\zaijian.log' TO GROUP 6; ɾ³ýÖØ×öÈÕÖ¾³ÉÔ±
ALTER DATABASE DROP LOGFILE MEMBER 'a:\nihao.log', 'b:\zaijian.log';

×¢Òâ:²»ÄÜɾ³ýµ±Ç°ÈÕÖ¾×éºÍINVALID״̬µÄ³ÉÔ±. ÿ¸öÖØ×öÈÕÖ¾×éµÄ×îºóÒ»¸öÓÐЧ³ÉÔ±²»Äܱ»É¾³ý,¹éµµÄ£Ê½ÏÂδ¹éµµÍêµÄ³ÉÔ±Ò²²»ÄÜɾ³ý. ±¾É¾³ý²¢Î´ÕæÕýµÄɾ³ýÓ²ÅÌÉϵÄÎļþ Çå³ýÖØ×öÈÕÖ¾×é.(É÷ÓÃ)
ALTER DATABASE CLEAR LOGFILE GROUP 5
»ò Çå³ý±ÀÀ£²»Äܹ鵵µÄÎļþ
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 5

Ö´Ðб¾ÃüÁîÇ°ºóÓ¦×öÊý¾Ý¿âÈ«±¸·Ý.ÒòΪִÐкóÖØ×öÈÕÖ¾Îļþ±àºÅ½«»á¶Ìʱ¼ä²»Á¬¹á,Òò¶ø²»ÄÜÖ´Ðлָ´.ÒÔÇ°µÄ±¸·ÝÒ²²»ÔÙ¿ÉÓÃ. ±¾É¾³ý²¢Î´ÕæÕýµÄɾ³ýÓ²ÅÌÉϵÄÎļþ ʹÓÃOMF(Oracle×Ô¶¯Îļþ¹Ü¿Ø)¹ÜÀíÁª»úÖØ×öÈÕÖ¾Îļþ
a.)Ê×ÏÈÉ趨ÈÕÖ¾ÎļþÄ¿µÄµØĿ¼,×î¶à¿ÉÒÔÓÐ5¸ö
    ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_1 = 'a:\';
    ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_2 = 'b:\';
b.)Ìí¼ÓÒ»×éÖØ×öÈÕÖ¾
     ALTER DATABASE ADD LOGFILE;

     Á½¸öÎļþ·Ö±ð×Ô¶¯Ìí¼Óµ½Ö¸¶¨Ä¿Â¼. Oracle»á×Ô¶¯Éú³Éϼ¶Ä¿Â¼ºÍÎļþÃû
c.)ɾ³ýÒ»×éÖØ×öÈÕÖ¾
    ALTER DATABASE DROP LOGFILE GROUP 5;

    ½û¼ÉͬÉÏ. Or


Ïà¹ØÎĵµ£º

oracle 8i,9iºÍ10g µÄÇø±ð

Oracle 9i±È8i¶àÁËÄÄЩÐÂÌØÐÔ£¿
 ¼òҪ˵£º
    9i¸üÒ×ÓÚ¹ÜÀí¡£
Ïêϸ˵£º
    ²¢·¢¼¯Èº£¬8i OPSÉý¼¶Îª9i RAC£¬8i½áµã¼äÓÃÓ²Å̽»»»ÐÅÏ¢£¬9i½áµã¼ä²ÉÓøßËÙÍøÏߵĻº´æÈÛºÏ(Cache Fusion)¼¼Êõ½»»»ÐÅÏ¢£¬½»»»ËÙ¶ÈÌá¸ß100±¶ÒÔÉÏ¡£
    9i¿ÉÒÔÔÚÏßÐÞ¸ÄÄں˲ÎÊýºÍÄÚ´æ·ÖÅä£ ......

ORACLEÓɽű¾µ½´´½¨Êý¾Ý¿âÍêÕû¹ý³Ì¡£

£¨1£©ÒÔSYSÉí·ÝµÇ½
conn sys/sysem_pwd as sysdba;
£¨2£©´´½¨amlyÓû§
create user amly identified by 9imly;
£¨3£©´´½¨±í¿Õ¼ä
create tablespace ts_amly datafile 'd:\amlyfile\test.dbf' size 100M;
£¨4£©½«±í¿Õ¼ä·ÖÅä¸øÓû§
alter user amly default tablespace ts_amly;
£¨5£©¸øÓû§ÊÚȨ
grant create sess ......

Oracle µÄ Round º¯數(ËÄÉáÎåÈë)º¯Êý


 
¸Ãº¯ÊýÓÃÀ´·µ»ØÒ»¸öËÄÉáÎåÈëºóµÄÖµ
 
SELECT ROUND( number, [ decimalplaces ] ) from DUAL
 
參數:
±ØÌîÏnumber : Òª´¦ÀíµÄÊýÖµ(ÊýÖµ±í´ïʽ)
¿ÉÑ¡Ïdecimalplaces : ËÄÉáÎåÈëʱȡµÄСÊýµÄλÊý£¬²»ÌîÔò·µ»ØÕûÊý
 
Sample :
 
select round(123.456) from dual;& ......

Oracle OSÈÏÖ¤ÒÔ¼°¿ÚÁîÎļþ

 1.OSÈÏÖ¤
Oracle°²×°Ö®ºóĬÈÏÇé¿öÏÂÊÇÆôÓÃÁËOSÈÏÖ¤µÄ£¬ÕâÀïÌáµ½µÄosÈÏÖ¤ÊÇÖ¸·þÎñÆ÷¶ËosÈÏÖ¤¡£OSÈÏÖ¤µÄÒâ˼°ÑµÇ¼Êý¾Ý¿âµÄÓû§ºÍ¿ÚÁîУÑé·ÅÔÚÁ˲Ù×÷ϵͳһ¼¶¡£Èç¹ûÒÔ°²×°OracleʱµÄÓû§µÇ¼OS£¬ÄÇô´ËʱÔڵǼOracleÊý¾Ý¿âʱ²»ÐèÒªÈκÎÑéÖ¤£¬È磺
SQL> connect /as sysdba
ÒÑÁ¬½Ó¡£
SQL> connect sys/aaa@te ......

OracleÖÐstart with...connect by prior×Ó¾äÓ÷¨

 
OracleÖÐstart with...connect by prior×Ó¾äÓ÷¨

connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from tablename start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = 'HBHqfWGWPy'
connect by prior org_id = parent_id;
¼òµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ