Oracle Á¬½Ó ¸´Ï°
SQL> select * from ta;
ID NAME
---------- --------------------
1 gorey
2 gorey2
SQL> select * from tb;
ID ADDRESS
---------- --------------------
2 g2
3 g3
SQL>
¡ñ×óÍâÁ¬½Ó -¡· ×ó±í¼Ç¼ȫ²¿Ñ¡ÖУ¬ÓÒ±íÆ¥ÅäÑ¡ÖÐ £¬Î´Æ¥ÅäµÄÇé¿öNULLÏÔʾ
SQL> select * from ta left outer join tb on ta.id = tb.id;
ID NAME ID ADDRESS
---------- -------------------- ---------- --------------------
1 gorey
2 gorey2 2 g2
SQL> select * from ta left join tb on ta.id = tb.id;
ID NAME ID ADDRESS
---------- -------------------- ---------- --------------------
1 gorey
2 gorey2 2 g2
SQL> select * from ta,tb where ta.id = tb.id(+);
ID NAME ID ADDRESS
---------- ------------
Ïà¹ØÎĵµ£º
Oracle Flashback Technology
Oracle Flashback Technology reduces recovery time from hours to minutes.
from: http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm
According to many studies, 40% of application outages are caused by operator or user errors. Part of be ......
»ù±¾ÒªÇó
win 7µÄ°æ±¾ÊÇÆì½¢°æ£¬oracle 10g£¨Oracle10gµÚ2°æ10.2.0.3-10.2.0.410203vistaw2k8x86productiondb£©Ñ¸À×ÓÐÏÂÔØ
£¨ËÑË÷“oracle 10g vista”£¬760MB£©
¾ßÌå¹ý³Ì
1.ÅäÖÃÒ»¸öÐéÄâµÄIP£ºÔÚ°²×°ORACLE 10gǰϵͳ»á¼ì²â°²×°µÄһЩǰÌáÌõ¼þÊÇ·ñÂú×㣬
ÍùÍù»áÌáʾ˵£º½«Microsoft LoopBack AdapterÅäÖÃΪ ......
±¾ÈËÒÔÇ°ÕûÀíµÄÊý¾Ý¿âÎļþǨÒƹý³Ì£¬Ï£ÍûÄܹ»¶Ô´ó¼ÒÓÐËù°ïÖú
1¡¢sqlplus "sys/sys@·þÎñÃû as sysdba"
2¡¢Ð޸ĿØÖÆÎļþ:
alter system set control_files='E:\oracle\oradata\myOracle_1\control01.ctl',
'E:\oracle\oradata\myOracle_1\control02.ctl','E:\oracle\oradata\my ......
ÔÚlinuxÏÂÆô¶¯oracle ºÍÔÚwindowsÊÇÓвî±ðµÄ£¬¶ÔÓÚÒ»°ãÔÚwindowsϲÙ×÷Ï°¹ßÈËÓкܶ಻ÊÊÓ¦£¬ËùÒÔÎÒÌرðдÕâÑùÎÄÕ£¬ÒÔ·½±ãÐÂÊÖ½øÐвÙ×÷£¬ÏÂÃæ¾ÍÒ»²½Ò»²½½²½âÆô¶¯¹ý³Ì¡£
1.ͨ¹ýÖÕ¶ËÁ¬½Óµ½linux·þÎñÆ÷,µ±È»ÕâÑùµÄÈí¼þºÜ¶àÀýÈçputty,SecureCRT,²¢ÒÔoracleÓû§½øÐеǼ£¬·ñÔòÆô¶¯oracleʱ»á´íµÄ£¬Ã»ÓÐȨÏÞÆô¶¯.(Ò²¿ÉÓû§root µ ......
SELECT EXECUTIONS , DISK_READS, BUFFER_GETS,
¡¡¡¡ROUND((BUFFER_GETS-DISK_READS)/BUFFER_GETS,2) Hit_radio,
¡¡¡¡ROUND(DISK_READS/EXECUTIONS,2) Reads_per_run,
¡¡¡¡SQL_TEXT
¡¡¡¡from V$SQLAREA
¡¡¡¡WHERE EXECUTIONS>0
¡¡¡¡AND BUFFER_GETS > 0
¡¡¡¡AND (BUFFER_GETS-DISK_READS)/BUFFER_GETS ......