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

Oracle С֪ʶ ÂýÂý¸üÐÂ

1. ÿÌìµÄ8£º00µ½23£º00ÿ¸ô5·ÖÖÓÖ´ÐÐÒ»¸ösqlÓï¾äµÄJOB
     --½¨Á¢Ò»¸ö´æ´¢¹ý³Ì
CREATE OR REPLACE PROCEDURE p_jobtest IS
  v_hh VARCHAR2(2);
BEGIN
  v_hh := to_char(SYSDATE, 'hh24');
  IF v_hh >= '08' AND v_hh <= '22' THEN
    --ÄãµÄsqlÓï¾ä
    NULL;
  END IF;
END;
/
--Ìá½»Ò»¸öJOB
DECLARE
  v_jobno NUMBER;
BEGIN
  dbms_job.submit(v_jobno,
                  'p_jobtest;',
                  trunc(SYSDATE, 'mi') + 1 / 1440,
                  'trunc(SYSDATE, ''mi'') + 5 / 1440');
END;
/
2.  RMAN ÖеÄlist ÃüÁîÏÔʾµÄÐÅÏ¢ÊÇ´Ó¿ØÖÆÎļþÀï»ñÈ¡µÄ£¬Èç¹ûʹÓÃrmµÈÃüÁîÊÖ¹¤µÄɾ³ý±¸·ÝÎļþ£¬Õâ¸ö¶¯×÷²»»áͬ²½µ½¿ØÖÆÎļþ£¬Ôì³É²»Ò»Ö£¬ÕâÖÖ²»Ò»Ö»ᵼÖÂʹÓÃrmanʱ±¨´í¡£¿ÉÒÔʹÓÃdelete ɾ³ýÕâЩ¹ýÆÚµÄ¼Ç¼£¬ÔÚÓþͲ»»á±¨´íÁË¡£
RMAN>crosscheck copy;
RMAN>list copy;
RMAN>delete expired copy;
3. ´¥·¢LGWR½ø³ÌµÄÌõ¼þÓУº 
  1. Óû§Ìá½» 
  2. ÓÐ1/3ÖØ×öÈÕÖ¾»º³åÇøÎ´±»Ð´Èë´ÅÅÌ 
  3. ÓдóÓÚ1MµÄÖØ×öÈÕÖ¾»º³åÇøÎ´±»Ð´Èë´ÅÅÌ 
  4. 3Ã볬ʱ 
  5. DBWR ÐèҪдÈëµÄÊý¾ÝµÄSCN´óÓÚLGWR¼Ç¼µÄSCN£¬DBWR ´¥·¢LGWRдÈë¡£
4. ´¥·¢DBWR½ø³ÌµÄÌõ¼þÓУº 
1.  DBWR³¬Ê±£¬´óÔ¼3Ãë 
2. ÏµÍ³ÖÐûÓжàÓàµÄ¿Õ»º³åÇøÀ´´æ·ÅÊý¾Ý 
3.  CKPT ½ø³Ì´¥·¢DBWR
5. ÿ¸ô3ÃëÖÓckpt»áÈ¥¸üпØÖÆÎļþºÍÊý¾ÝÎļþ£¬¼Ç¼checkpointÖ´ÐеÄÇé¿ö¡£
  µ±·¢Éúcheckpointʱ£¬»á°ÑSCNдµ½ËĸöµØ·½È¥¡£
  Èý¸öµØ·½ÓÚcontrol fileÄÚ£¬Ò»¸öÔÚdatafile header¡£
´¥·¢CheckPoint(¼ì²éµã) Ìõ¼þÓкܶ࣬±ÈÈ磺
1. ͨ¹ýÕý³£ÊÂÎñ´¦Àí»òÕßÁ¢¼´Ñ¡Ïî¹Ø±ÕÀý³Ìʱ(shutdown immediate»òÕßShutdown normal),
2. µ±Í¨¹ýÉèÖóõʼ»¯²ÎÊý:
LOG_CHECKPOINT_INTERVAL,


Ïà¹ØÎĵµ£º

WinXP ÏÂÖØÐÂÉèÖà Oracle ¹ÜÀíÔ±ÃÜÂë

WinXP ÏÂÖØÐÂÉèÖà Oracle ¹ÜÀíÔ±ÃÜÂë
        Windows ÏÂÐÞ¸Ä Oracle ¹ÜÀíÔ±ÃÜÂë²Ù×÷²½Öè¡£´Ë²½ÖèÔÚ WinXP5.1¡¢Oracle92 ϲÙ×÷³É¹¦¡£¸ü¸ÄÒÔºóÐèÒªÖØÆô¼ÆËã»úºÍʵÀý·½¿ÉÉúЧ¡£
        ±³¾°£ºWinXP °æ±¾ 5.1£¨ÄÚ²¿°æ±¾ºÅ 2600.xpsp_sp2_dgr.07022 ......

ÈçºÎÐÞ¸ÄOracleĬÈÏÓû§ÃÜÂëÓÐЧÆÚʱ¼ä

ÈçºÎÐÞ¸ÄOracleĬÈÏÓû§ÃÜÂëÓÐЧÆÚʱ¼ä 1¡¢²é¿´Óû§µÄproifleÊÇÄĸö£¬Ò»°ãÊÇdefault£º sql>SELECT username,PROFILE from dba_users; 2¡¢²é¿´Ö¸¶¨¸ÅÒªÎļþ£¨Èçdefault£©µÄÃÜÂëÓÐЧÆÚÉèÖ㺠sql>SELECT * from dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME'; 3¡¢½«ÃÜÂëÓÐЧÆÚÓÉĬ ......

ORACLE Á¬½Ó ·½Ê½


ORACLE
±íÁ¬½Ó·½Ê½·ÖÎö¼°³£¼ûÓ÷¨

ÕªÒª
:
Õë¶ÔÔÚÊý¾Ý²Ö¿â»·¾³ÏÂ
,
ÓÉÓÚ³¬´óÊý¾ÝÁ¿µÄ´¦Àí¶ø²úÉúµÄЧÂÊÎÊÌ⣬±¾ÎÄÉîÈë·Ö
ÎöÁË
ORACLE
±íµÄ¼¸ÖÖÁ¬½Ó·½Ê½¡¢Ìص㡢ÊÊÓ÷¶Î§
,
ÒÔ¼°¶ÔÓÚ
ÈçºÎʹÓúÍÓÅ»¯×öÁËÏêϸµÄ̽ÌÖ¡£
¹Ø¼ü×Ö£º Êý¾Ý²Ö¿â
ORACLE
±íÁ¬½Ó
Ò» ÒýÑÔ
Êý¾Ý²Ö¿â¼¼ÊõÊÇÄ¿
ǰÒÑÖªµÄ±È½Ï³ÉÊì ......

OracleµÄ°æÈ¨ÉùÃ÷

   
ÒÔÍù´ÓÀ´Ã»ÓÐÏëÈ¥ÈÏÕæ¶ÁÒ»´ÎOracleµÄ°æÈ¨ÉùÃ÷£¬½ñÌì´ò¿ªOracle10gR2µÄÎĵµ£¬ÓÚÊǾÍË÷ÐÔ´ÓÍ·¿ªÊ¼¶ÁÒ»ÏÂÕâÆªÎÄÕ¡£
һЩÎÒÏë´ó¼Ò¶¼Ó¦¸ÃÈ¥ÖªµÀµÄ£¬ËäÈ»¹úÄڵİæÈ¨¸ÅÄîʵÔÚÊDZȽϵ­±¡£¬µ«ÏëÀ´»áÔ½À´Ô½ºÃµÄ¡£
Oracle10g·ÖΪ4¸ö°æ±¾£¬·Ö±ðÊÇ£º
1¡£Oracle Database Standard Edition One£¬×î»ù±¾µÄÉÌÒµ°æ± ......

Oracle SQL DeveloperÓëPL/SQL Developer±È½Ï¡¾×ª¡¿

¸½:Oracle SQL Developer — À©Õ¹½»Á÷ÖÐÐÄ
http://www.oracle.com/technology/global/cn/products/database/sql_developer/files/extensions.htm
      ֮ǰ×÷Ϊһ¸öOracle Employee£¬È´×ÜÊÇÔÚʹÓÃPL/SQL Developer£¨¶øÇÒÊÇÆÆ½â°æ£©£¬ÕâʵÔÚÓÐЩ˵²»¹ýÈ¥£¬µ«ÊÇÈçºÎÕÒµ½Ò»¸öºÏÐijÃÊÖµÄÄܹ»Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ