ѧϰ¡¶Oracle 9i10g±à³ÌÒÕÊõ¡·µÄ±Ê¼Ç (Èý)
1.¶à°æ±¾£º¶ÁÒ»Ö²éѯ ·Ç×èÈû²éѯ
Oracle ²ÉÓÃÁËÒ»ÖÖ
¶à°æ±¾¡¢¶ÁÒ»Ö£¨read-consistent£©µÄ²¢·¢Ä£ÐÍ¡£ÔÙ´Î˵Ã÷£¬ÎÒÃǽ«ÔÚµÚ7 Õ¸üÏêϸµØ½éÉÜÓйصļ¼Êõ¡£
²»¹ý£¬ÊµÖÊÉϽ²£¬Oracle ÀûÓÃÕâÖÖ»úÖÆÌṩÁËÒÔÏÂÌØÐÔ£º
¶ÁÒ»Ö²éѯ£º¶ÔÓÚÒ»¸öʱ¼äµã£¨point in time£©£¬²éѯ»á²úÉúÒ»ÖµĽá¹û¡£
·Ç×èÈû²éѯ£º²éѯ²»»á±»Ð´ÈëÆ÷×èÈû£¬µ«ÔÚÆäËûÊý¾Ý¿âÖпÉÄܲ»ÊÇÕâÑù¡£
Oracle Êý¾Ý¿âÖÐÓÐÁ½¸ö·Ç³£ÖØÒªµÄ¸ÅÄî¡£¶à°æ±¾£¨multi-versioning£©Ò»´ÊʵÖÊÉÏÖ¸Oracle Äܹ»´Ó
Êý¾Ý¿âͬʱÎﻯ¶à¸ö°æ±¾µÄÊý¾Ý¡£Èç¹ûÄãÀí½âÁË¶à°æ±¾ÈçºÎ¹¤×÷£¬¾Í»áÖªµÀÄÜ´ÓÊý¾Ý¿âµÃµ½Ê²Ã´¡£ÔÚ½øÒ»
²½ÉîÈëÌÖÂÛOracle ÈçºÎʵÏÖ¶à°æ±¾Ö®Ç°£¬ÏÂÃæÓÃÎÒÈÏΪ×î¼òµ¥µÄÒ»¸ö·½·¨À´ÑÝʾOracle ÖÐµÄ¶à°æ±¾£º
( p_resource_name, p_start_time, p_end_time );
end schedule_resources;
ops$tkyte@ORA10G> create table t
2 as
3 select *
4 from all_users;
Table created.
ops$tkyte@ORA10G> variable x refcursor
ops$tkyte@ORA10G> begin
2 open :x for select * from t;
3 end;
4 /
PL/SQL procedure successfully completed.
ops$tkyte@ORA10G> delete from t;
28 rows deleted.
ops$tkyte@ORA10G> commit;
Commit complete.
ops$tkyte@ORA10G> print x
USERNAME USER_ID CREATED
------------------------------ -------------- ---------------
BIG_TABLE 411 14-NOV-04
OPS$TKYTE 410 14-NOV-04
DIY 69 26-SEP-04
...
OUTLN 11 21-JAN-04
SYSTEM 5 21-JAN-04
ÔÚÇ°ÃæµÄÀý×ÓÖУ¬ÎÒ´´½¨ÁËÒ»¸ö²âÊÔ±íT£¬²¢°ÑALL_USERS ±íµÄһЩÊý¾Ý¼ÓÔØµ½Õâ¸ö±íÖС£È»ºóÔÚÕâ
¸ö±íÉÏ´ò¿ªÒ»¸öÓαꡣÔÚ´ËûÓдӸÃÓαê»ñÈ¡Êý¾Ý£¬Ö»ÊÇ´ò¿ªÓÎ±ê¶øÒÑ¡£
×¢ÒâÒª¼Çס£¬Oracle ²¢²»“»Ø´ð”Õâ¸ö²éѯ¡£´ò¿ªÓαêʱ£¬Oracle ²»¸´ÖÆÈκÎÊý¾Ý£¬Äã¿ÉÒÔÏëÏë¿´£¬
¼´Ê¹Ò»¸ö±íÓÐÊ®ÒÚÌõ¼Ç¼£¬ÊDz»ÊÇÒ²Äܺܿì¾Í´ò¿ªÓαꣿû´í£¬Óαê»áÁ¢¼´´ò¿ª£¬Ëü»á±ßÐнø±ß
»Ø´ð²éѯ¡£»»¾ä»°Ëµ£¬Ö»ÊÇÔÚÄã»ñÈ¡Êý¾ÝʱËü²Å´Ó±íÖжÁÊý¾Ý¡£
ÔÚͬһ¸ö»á»°ÖУ¨»òÕßÒ²¿ÉÒÔÔÚÁíÒ»¸ö»á»°ÖУ»ÕâͬÑùÄܺܺõع¤×÷£©£¬ÔٴӸñíɾ³ýËùÓÐÊý¾Ý¡£Éõ
ÖÁÓÃCOMMIT Ìá½»ÁËɾ³ýËù×öµÄ¹¤×÷¡£¼Ç¼Ðж¼Ã»ÓÐÁË£¬µ«ÊÇÕæµÄûÓÐÁËÂð£¿Êµ¼ÊÉÏ£¬»¹ÊÇ¿ÉÒÔͨ¹ýÓαê»ñ
È¡µ½Êý¾Ý¡£OPEN ÃüÁî·µ»ØµÄ½á¹û¼¯ÔÚ´ò¿ªµÄÄÇÒ»¿Ì£¨Ê±¼äµã£©¾ÍÒѾȷ¶¨¡£´ò¿ªÊ±£¬ÎÒÃǸù±¾Ã»ÓÐÅö¹ý±í
ÖеÄÈκÎÊý¾Ý¿é£¬µ«´ð°¸ÒѾÊÇÌú°å¶¤¶¤µÄÁË
Ïà¹ØÎĵµ£º
±¾ÊµÀýÒÑÍêȫͨ¹ý²âÊÔ,µ¥Ïò,ÓÖÏòͬ²½¶¼¿ÉʹÓÃ.
--Ãû´Ê˵Ã÷£ºÔ´——±»Í¬²½µÄÊý¾Ý¿â
Ä¿µÄ——Ҫͬ²½µ½µÄÊý¾Ý¿â
ǰ6²½±ØÐëÖ´ÐÐ,µÚ6ÒÔºóÊÇһЩ¸¨ÖúÐÅÏ¢.
--1¡¢ÔÚÄ¿µÄÊý¾Ý¿âÉÏ£¬´´½¨dblink
drop public database link dblink_or ......
1.Á÷³ÌÈçÏÂ
Óû§¿ÉÒÔʹÓÃOracle°²×°³ÌÐò´ÓWindows NT¿òÖÐɾ³ýËùÐèÒªµÄ²úÆ·£¬µ«ÊÇÕâ¿ÉÄÜÓеã·Ñ¾¢¡£
Èô²»Ïë±£ÁôÈκÎN TµÄOracle²úÆ·£¬¿ÉÒÔ°´ÒÔÏÂÖ¸Áîɾ³ýËùÓеÄOracle²úÆ·£º
1) Ê×ÏÈ£¬ÓÿØÖÆÃæ°åÉ쵀 Services Ó¦ÓóÌÐòÍ£Ö¹ËùÓеÄOracle·þÎñ¡£
ËùÓеÄOracle·þÎñ¶¼Ó¦ÓÐÒ»¸ö°üº¬“O R C L”¡¢“Oracle&rdqu ......
oracle ASM ÅäÖà ת
2008-04-30 11:14
oracle ASM ÅäÖÃ
2006Äê12ÔÂ11ÈÕ ÐÇÆÚÒ» 11:09
×Ô¶¯´æ´¢¹ÜÀí (ASM)
ASM ÊÇ Oracle Êý¾Ý¿â 10g
ÖÐÒ»¸ö·Ç³£³öÉ«µÄÐÂÌØÐÔ£¬ËüÒÔÆ½Ì¨Î޹صķ½Ê½ÌṩÁËÎļþϵͳ¡¢Âß¼¾í¹ÜÀíÆ÷ÒÔ¼°Èí¼þ RAID µÈ·þÎñ¡£ASM
¿ÉÒÔÌõ´ø»¯ºÍ¾µÏñ´ÅÅÌ£¬´Ó¶øÊµÏÖÁËÔÚÊý¾Ý¿â±»¼ÓÔØµ ......
ORACLEÖ÷ÒªÓÉÁ½²¿·Ö×é³É£ºInstanceºÍDatabase¡£InstanceÊÇÖ¸Ò»×éºǫ́½ø³Ì/Ï̺߳ÍÒ»¿é¹²ÏíÄÚ´æÇøÓò£¬¶øDatabaseÊÇÖ¸´æ´¢ÔÚ´ÅÅÌÉϵÄÒ»×éÎïÀíÎļþ¡£
ORACLEÊý¾Ý¿âµÄÆô¶¯Ö÷Òª·Ö3¸ö²½Ö裺
1¡¢Æô¶¯µ½nomount״̬£»
2¡¢Æô¶¯µ½mount״̬£»
3¡¢Æô¶¯µ½open״̬¡£
ÏÂÃæ·ÖÎöÒ»ÏÂÆô¶¯µÄ¸÷¸ö²½Ö裺
Ò»¡¢Æô¶¯µ½nomount״̬
......