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

ORACLEÖд¥·¢DBWR½ø³ÌµÄʼþ~

½ñÌìÔÚÒ»±¾ÊéÉÏ¿´µ½µÄ£¬¸Ð¾õͦȫµÄ¡£Ó¡ÏóÖÐ×Ô¼ºÒѾ­²»ÖªµÀ°Ù¶ÈÁ˶àÉÙ´ÎÕâ¸öÎÊÌ⣬½ñÌì¾Í¼ÇÏÂÀ´°É£¬·½±ãÒÔºó²éѯ¡£
Êý¾Ý¿âд½ø³ÌÔÚÒÔÏÂʼþÖ®Ò»·¢Éúʱ°ÑÊý¾Ý¿â¸ßËÙ»º³åÇøµÄÊý¾Ýдµ½Êý¾ÝÎļþÉÏ:
µ±Ô໺³åÇøµÄÊýÁ¿³¬¹ýÁËËùÉ趨µÄÏÞ¶î
µ±ËùÉ趨µÄʱ¼ä¼ä¸ôÒѵ½
µ±Óнø³ÌÐèÒªÊý¾Ý¿â¸ßËÙ»º³åÇøÈ´ÕÒ²»µ½¿ÕÏеĻº³åÇøʱ
µ±¼ì²éµã·¢Éúʱ
µ±Ä³¸ö±í±»É¾³ý(drop)»ò±»½Ø¶Ï(truncate)ʱ
µ±Ä³¸ö±í¿Õ¼ä±»ÖÃΪֻ¶Á״̬(read only)ʱ
µ±Ê¹ÓÃÀàËÆÓÚALTER TABLESPACE users BEGIN BACKUPµÄÃüÁî¶Ôij¸ö±í¿Õ¼ä½øÐÐÁª»ú±¸·Ýʱ
µ±Ä³¸öÁÙʱ±í¿Õ¼ä±»ÉèÖÃΪֻÍÑ»ú״̬(offline)»òÕý³£×´Ì¬(normal)ʱµÈ


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

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

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

Oracle job ʹÓÃ

²½Ö裺
(1) ´´½¨×÷Òµ
(2) ´´½¨job
       dbms_job.submit();
       submit ( jobno¡¡OUT binary_ineger,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡What¡¡¡¡¡¡IN¡¡varchar2,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡next_date IN¡¡date,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡interval¡¡IN¡¡varchar2,
¡¡¡¡¡¡¡¡¡¡¡¡  &nb ......

Oracle 9i/10g pfile/spfile ²ÎÊýÎļþÏê½â


(1)PfileÎļþ
    Pfile£¨Parameter File£©ÎļþÊÇ»ùÓÚÎı¾¸ñʽµÄ²ÎÊýÎļþ£¬º¬ÓÐÊý¾Ý¿âµÄÅäÖòÎÊý¡£
    Oracle 9iÔÚ°²×°Ê±ÎªÃ¿¸öÊý¾Ý¿â½¨Á¢ÁËÒ»¸öPfile£¬Ä¬ÈϵÄÃû³ÆΪ“init+Àý³ÌÃû.ora”£¬ÕâÊÇÒ»¸öÎı¾Îļþ£¬¿ÉÒÔÓÃÈκÎÎı¾±à¼­¹¤¾ß´ò¿ª¡£
ϱíΪÊý¾Ý¿âµÄ³õʼ»¯²Î ......

OracleÖÐTO_DATE¸ñʽ

TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02   13:45:25ΪÀý)
Year:     
yy two digits Á½Î»Äê            ÏÔʾֵ:07
yyy three digits ÈýλÄê          &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ