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

.batÆô¶¯Êý¾Ý¿â·þÎñ(MSSQL,Oracle)

 @echo off
:dosmenu
REM Ñ¡Ôñ²Ëµ¥
echo  Windows ·þÎñÆô¶¯»ò¹Ø±Õ By hope 2008Äê2ÔÂ7ÈÕ     
echo.
echo [1]Æô¶¯Sql Server2005   [2]¹Ø±ÕSql Server2005
echo [3]Æô¶¯Oracle9i         [4]¹Ø±ÕOracle9i
echo.
echo             ÆäËü¼üÍ˳ö±¾³ÌÐò
echo.
set /P CHS= ÇëÑ¡Ôñ·þÎñ: [1],[2],[3],[4]
if /I "%CHS%"=="1" (
goto aaaa
)
if /I "%CHS%"=="2" (
goto bbbb
)
if /I "%CHS%"=="3" (
goto cccc
)
if /I "%CHS%"=="4" (
goto dddd
)
goto close
:aaaa
REM Æô¶¯Sql Server2005
net start MSSQLSERVER
pause
cls
goto dosmenu
:bbbb
REM ¹Ø±ÕSql Server2005
net stop MSSQLSERVER
pause
cls
goto dosmenu
:cccc
REM Æô¶¯Oracle9I
net start "OracleServiceHOPE"
net start "OracleOraHome92TNSListener"
pause
cls
goto dosmenu
:dddd
REM Æô¶¯Oracle9I
net stop "OracleOraHome92TNSListener"
net stop "OracleServiceHOPE"
pause
cls
goto dosmenu
:close
REM Í˳ö
exit
-----------------------------------
      ¿½±´ÉÏÃæµÄÄÚÈÝ£¬ÃüÃûΪ.bat Îļþ£¬Ë«»÷ÔËÐм´¿ÉÆô¶¯£¬Í£Ö¹Êý¾Ý¿â·þÎñ


Ïà¹ØÎĵµ£º

oracle hintÖÐordered ºÍleadingÔ­ÀíºÜºÃµÄÌû×Ó

ÎÊÌ⣺Çë½ÌHINTд·¨
ÎÒÓÐÒ»¸öSQLÌí¼ÓÈçÏÂhint,Ä¿µÄÊÇÖ¸¶¨hash_join·½Ê½¡£
select /*+ordered use_hash(a,b,c,d) */ *
from a,b,c,d
Where ...
ÆäÖÐ,
      aÖ»ÓëbÓйØÁª¹ØÏµ£¬bÖ»ÓëcÓйØÁª¹ØÏµ£¬bÖ»ÓëcÓйØÁª¹ØÏµ,cÖ»ÓëdÓйØÁª¹ØÏµ£¬
    ÊýÁ¿¼¶£ºa:1000Ìõ,  b:100 ÍòÌõ£¬ ......

Oracle expÏê½â

 µ¼Èë/µ¼³öÊÇORACLEÐÒ´æµÄ×î¹ÅÀϵÄÁ½¸öÃüÁîÐй¤¾ß£¬ÆäʵÎÒ´ÓÀ´²»ÈÏΪExp/ImpÊÇÒ»Öֺõı¸·Ý·½Ê½£¬ÕýÈ·µÄ˵·¨ÊÇExp/ImpÖ»ÄÜÊÇÒ»¸öºÃµÄת´¢¹¤¾ß£¬ÌرðÊÇÔÚСÐÍÊý¾Ý¿âµÄת´¢£¬±í¿Õ¼äµÄÇ¨ÒÆ£¬±íµÄ³éÈ¡£¬¼ì²âÂß¼­ºÍÎïÀí³åÍ»µÈÖÐÓв»Ð¡µÄ¹¦ÀÍ¡£µ±È»£¬ÎÒÃÇÒ²¿ÉÒÔ°ÑËü×÷ΪСÐÍÊý¾Ý¿âµÄÎïÀí±¸·ÝºóµÄÒ»¸öÂß¼­¸¨Öú±¸·Ý£¬Ò²ÊDz»´íµ ......

Oracle Data Gurad Logical Standby Ïà¹ØËµÃ÷


Ò»£®Âß¼­StandbyµÄ×¼±¸¹¤×÷
1  È·ÈϲÙ×÷µÄ¶ÔÏóºÍÓï¾äÊÇ·ñÄܱ»Âß¼­StandbyÖ§³Ö
ÓÉÓÚÂß¼­StandbyÊÇͨ¹ýSQLÓ¦ÓÃÀ´±£³ÖÓëPrimaryÊý¾Ý¿âµÄͬ²½¡£SQLÓ¦ÓÃÓëREDOÓ¦ÓÃÊÇÓкܴóµÄÇø±ð£¬REDOÓ¦ÓÃʵ¼ÊÉÏÊÇÔÚÎïÀíStandby¶Ë½øÐÐRECOVER£»SQLÓ¦ÓÃÔòÊÇ·ÖÎöÖØ×öÈÕÖ¾ÎļþÖеÄREDOÐÅÏ¢£¬²¢½«Æäת»»ÎªSQLÓï¾ä£¬ÔÚÂß¼­Standby¶ËÖ´ ......

oracle RACͬ²½ÆµÂÊÉèÖÃ

max_commit_propagation_delayĬÈÏֵΪ700£¬¼´7Ã루µ¥Î»0.01s£¬http://www.orafaq.com/parms/parm1217.htm£©¡£
Õâ¸ö²ÎÊýÓ¦¸ÃÅäÖõÄÊÇRAC£¨Real Application Cluster£©Ö®¼äͬ²½Êý¾ÝµÄƵÂÊ¡£ÐÞ¸ÄÕâ¸ö²ÎÊýµÄºÃ´¦¾Í²»ÓÃ˵ÁË£¨
±¾ÈËÉîÊÜÆä¿à°¡
£©£¬µ«ÊÇÈç¹û×ßÁíÒ»¸ö¼«¶Ë£¬¿ÉÄÜ»á¸øÊý¾Ý¿âÔì³É¸ü´óµÄѹÁ¦
²ÎÊýÖ¸¶¨Ò»¸öinstance ......

oracle ÁÐתÐÐʵÀý

select * from (select pro_id, sum(decode(month, '01', summ)) one,
                    sum(decode(month, '02', summ)) two,
             &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ