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

ѧϰ¡¶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 ÃüÁî·µ»ØµÄ½á¹û¼¯ÔÚ´ò¿ªµÄÄÇÒ»¿Ì£¨Ê±¼äµã£©¾ÍÒѾ­È·¶¨¡£´ò¿ªÊ±£¬ÎÒÃǸù±¾Ã»ÓÐÅö¹ý±í
ÖеÄÈκÎÊý¾Ý¿é£¬µ«´ð°¸ÒѾ­ÊÇÌú°å¶¤¶¤µÄÁË


Ïà¹ØÎĵµ£º

ORACLEº¯Êý´óÈ«

SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2.CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr65 from ......

ѧϰ¡¶Oracle 9i10g±à³ÌÒÕÊõ¡·µÄ±Ê¼Ç (¶þ)

 Ò».Ëø
Êý¾Ý¿âʹÓÃËø£¨lock£© À´±£Ö¤Èκθø¶¨Ê±¿Ì×î¶àÖ»ÓÐÒ»¸öÊÂÎñÔÚÐ޸ĸø¶¨µÄÒ»¶ÎÊý¾Ý¡£ÊµÖÊÉϽ²£¬
ÕýÊÇËø»úÖÆ²Åʹ²¢·¢¿ØÖƳÉΪ¿ÉÄÜ¡£ÀýÈ磬Èç¹ûûÓÐijÖÖËø¶¨Ä£ÐÍÀ´×èÖ¹¶ÔͬһÐеIJ¢·¢¸üУ¬Êý¾Ý¿â¾Í
²»¿ÉÄÜÌṩ¶àÓû§·ÃÎÊ¡£²»¹ý£¬Èç¹ûÀÄÓûòÕßʹÓò»µ±£¬Ëø·´µ¹»á×è°­²¢·¢ÐÔ¡£Èç¹ûÄã»òÊý¾Ý¿â±¾Éí²»±Ø
ÒªµØ¶ÔÊý¾Ý ......

oracle asm ´´½¨Óë¹ÜÀí

 
ASM
ASM¿ÉÒÔÌõ´ø»¯ºÍ¾µÏñ´ÅÅÌ£¬Òò´Ë¿ÉÒÔÔÚÊý¾Ý¿â±¸¼ÓÔØµÄÇé¿öÏÂÌí¼Ó¡¢É¾³ý´ÅÅÌ¡¢ÒÔ¼°×Ô¶¯Æ½ºâIO¡£
ASM²»ÊÇÒ»¸öÎļþϵͳ£¬ËùÒÔÎÞ·¨´Ó²Ù×÷ϵͳ·ÃÎÊASM´æ´¢µÄÎļþ£¬¶ÔÓÚʹÓÃASMµÄÊý¾Ý¿âÖ»ÄÜÓÃRMAN½øÐб¸·ÝºÍ»Ö¸´¡£
ASM×÷Ϊµ¥¶ÀµÄORACLEʵÀýʵʩ£¬Ö»ÓÐASMÔËÐÐʱÊý¾Ý¿â²ÅÄÜ·ÃÎÊ¡£
Ò»¡¢´ÅÅÌ×é
ASMÌṩÁËÈýÖдÅÅÌ×éÀà ......

oracle ASM ÅäÖ㨰²×°dbʱ´´½¨Ñ¡Ôñasm£©

 
oracle ASM ÅäÖà ת
2008-04-30 11:14
oracle ASM ÅäÖÃ
2006Äê12ÔÂ11ÈÕ ÐÇÆÚÒ» 11:09
×Ô¶¯´æ´¢¹ÜÀí (ASM)

   ASM ÊÇ Oracle Êý¾Ý¿â 10g
ÖÐÒ»¸ö·Ç³£³öÉ«µÄÐÂÌØÐÔ£¬ËüÒÔÆ½Ì¨Î޹صķ½Ê½ÌṩÁËÎļþϵͳ¡¢Âß¼­¾í¹ÜÀíÆ÷ÒÔ¼°Èí¼þ RAID µÈ·þÎñ¡£ASM
¿ÉÒÔÌõ´ø»¯ºÍ¾µÏñ´ÅÅÌ£¬´Ó¶øÊµÏÖÁËÔÚÊý¾Ý¿â±»¼ÓÔØµ ......

½â¾öÐ޸ļÆËã»úÃûOracleÎÞ·¨Æô¶¯µÄÎÊÌâ

°²×°Oracle Database(10.0.2)ºó£¬Èç¹ûÐ޸ĻúÆ÷Ãûºó£¬
»áµ¼Ö¿ØÖÆÃæ°åµÄ·þÎñÖÐÆô¶¯OracleTNSLisener·þÎñÁ¢¿Ì¾ÍÍ£Ö¹¡£
ʹÓÃÃüÁîÐй¤¾ß£¬ÌáʾÈçÏ£º
(»úÆ÷ÃûÔ­À´Îª£ºANSWER-1738E000£¬¸ÄΪ£ºANSWER)
 
½â¾ö·½·¨£º
1>¹Øµô¿ØÖÆÃæ°åÖÐÓйØÓÚ Oracle Database µÄ·þÎñ¡£
2>ÐÞ¸Ä C:\oracle\product\10.2.0\db_1\NE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ