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,
Ïà¹ØÎĵµ£º
---------------oracle ÈëÃÅ
´ò¿ª·þÎñÆ÷
net start oracleserviceORCL
´ò¿ª¼àÌýÆ÷
lsnrctl start
¹Ø±Õ·þÎñÆ÷
net stop oracleserviceORCL
¹Ø±Õ¼àÌýÆ÷
lsnrctl stop
-----------------------------
1.´´½¨±í
Create table ±íÃû
(×Ö¶ÎÃû Êý¾Ý ......
--´´½¨±í¿Õ¼ä
create tablespace testSP
datafile 'E:\COMPANY\rbtsql\testSP.dbf'
size 100M AutoExtend On Next 10M Maxsize 2048M
--´´½¨Óû§
create user janely identified by wawa
default tablespace testSP--ĬÈϱí¿Õ¼äÊÇ system
temporary tablespace temp--±£´æÁÙʱ¶ÔÏóËùʹÓõĿռä±í
--¸³È¨ÏÞ
grant ......
Oracle RAC ÖÐOCR ºÍVoting Disk ±¸·ÝÔÚÎÒµÄblog£º Oracle RAC ³£ÓÃά»¤¹¤¾ßºÍÃüÁî ÖÐÒѾÓÐ˵Ã÷£¬ÏÖÔÚÔٴΰÑËüµ¥¶ÀÄóö×öÒ»¸ö˵Ã÷£¬ ÒòΪOCR ºÍ Voting Disk ¶ÔÓÚRAC ϵͳÀ´ËµÌ«ÖØÒªÁË¡£
Oracle RAC ³£ÓÃά»¤¹¤¾ßºÍÃüÁî ......
Ò»¡¢Oracle Âß¼½á¹¹¼ò½é
oracleµÄÂß¼½á¹¹°üÀ¨±í¿Õ¼ä(tablespace)£¬¶Î(segment),Êý¾Ý¿é(data block)ÒÔ¼°Ä£Ê½¶ÔÏó(schema)¡£
oracle Êý¾Ý¿âÔÚÂß¼ÉÏÊÇÓɶà¸ö±í¼ä×é³ÉµÄ£¬±í¿Õ¼äÖд洢µÄ¶ÔÏó½Ð¶Î£¬±ÈÈçÊý¾Ý¶Î£¬Ë÷Òý¶Î£¬ºÍ»ØÍ˶Ρ£¶ÎÓÉÇø×é³É£¬ÇøÊÇ´ÅÅÌ·ÖÅäµÄ×îСµ¥Î»¡£ ......
¸½:Oracle SQL Developer — À©Õ¹½»Á÷ÖÐÐÄ
http://www.oracle.com/technology/global/cn/products/database/sql_developer/files/extensions.htm
֮ǰ×÷Ϊһ¸öOracle Employee£¬È´×ÜÊÇÔÚʹÓÃPL/SQL Developer£¨¶øÇÒÊÇÆƽâ°æ£©£¬ÕâʵÔÚÓÐЩ˵²»¹ýÈ¥£¬µ«ÊÇÈçºÎÕÒµ½Ò»¸öºÏÐijÃÊÖµÄÄܹ»Ô ......