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

Oracle¿Í»§¶ËµÄÐ¶ÔØ

1.Á÷³ÌÈçÏÂ
Óû§¿ÉÒÔʹÓÃOracle°²×°³ÌÐò´ÓWindows NT¿òÖÐɾ³ýËùÐèÒªµÄ²úÆ·£¬µ«ÊÇÕâ¿ÉÄÜÓеã·Ñ¾¢¡£
Èô²»Ïë±£ÁôÈκÎN TµÄOracle²úÆ·£¬¿ÉÒÔ°´ÒÔÏÂÖ¸Áîɾ³ýËùÓеÄOracle²úÆ·£º
1) Ê×ÏÈ£¬ÓÿØÖÆÃæ°åÉ쵀 Services Ó¦ÓóÌÐòÍ£Ö¹ËùÓеÄOracle·þÎñ¡£
ËùÓеÄOracle·þÎñ¶¼Ó¦ÓÐÒ»¸ö°üº¬“O R C L”¡¢“Oracle”»ò“T N S”µÄÃû×Ö¡£Ã¿´Î·´ÏÔÒ»¸ö£¬µ¥»÷S t o p°´Å¥¡£
2) ½ÓÏÂÀ´£¬ÔËÐÐregedit¡¢Windows 2000 Registry Editor²¢Ñ¡ÔñHKEY_LOCAL_MACHINE→SOFTWARE→Oracle¡£Ê¹ÓÃD E L¼üɾ³ý¸ÃÏî¡£
3) ÏÖÔÚ£¬Ñ¡ÔñKEY_LOCAL_MACHINE→SYSTEM →CurrentControlSet→Services ¡£ÏòϹö¶¯¸ÃÁÐ±í£¬²¢É¾³ýËùÓеÄOracleÏî¡£
4) ´Ó×ÀÃæÉÏɾ³ýOracle³ÌÐò×飬´ÓS t a r t u p×éÖÐɾ³ýOracle To o l b a rͼ±ê¡£
5) ɾ³ýÓëOracleÏà¹ØµÄËùÓÐÎļþ¡£Ê¹ÓÃNT Explorer£¬Ñ¡ÔñOracleËùÓеÄȱʡh o m eĿ¼£¬C£º\Oracle£¬É¾³ýÕû¸öĿ¼¼°ÆäËùÓеÄ×ÓĿ¼¡£ÁíÍ⣬ÔÙ´ÓWindows NTµÄhomeĿ¼(ͨ³£ÎªC£º\ winnt )ÖÐɾ³ýÏÂÁÐÎļþ£º
ORACLE.INI ,ORADIM.INI OTOOLBAR.INI*,OTEMP.INI VS20.INI*
6) ÈôÓû§ÓÐOracle µÄ1 6λWindows 3.1 Ó¦ÓóÌÐò(ͨ³£ÔÚC£º\OrawinÎļþ¼ÐÖÐ)£¬Ò²¿ÉÒÔɾ³ý´ËÎļþ¼Ð¡£
7) ×îºó£¬ÈôÓû§ÔÚw i n . i n iÎļþÖÐÓÐ( Oracle )±ê¼Ç¶Î£¬Ôòɾ³ý¸Ã¶Î¡£


Ïà¹ØÎĵµ£º

Oracle Shrink Table

½ñÌìÔÚ´÷Ã÷Ã÷ͬѧµÄÒ»¸ö»ØÌûÀï¸øÁ˸ö¹ØÓÚShrinkÃüÁîµÄÌû×Ó£¬×ª¹ýÀ´Ñ§Ï°Ñ§Ï°~
=============================================================================================
´Ó10g¿ªÊ¼£¬oracle¿ªÊ¼ÌṩShrinkµÄÃüÁ¼ÙÈçÎÒÃǵıí¿Õ¼äÖÐÖ§³Ö×Ô¶¯¶Î¿Õ¼ä¹ÜÀí (ASSM),¾Í¿ÉÒÔʹÓÃÕâ¸öÌØÐÔËõС¶Î£¬¼´½µµÍHWM¡£ÕâÀïÐèҪǿµ÷ ......

ORACLE ÄÚ´æ¹ÜÀí


Oracle 9i¶¯Ì¬SGA¹ÜÀí
ÔÚOracle 9iÖУ¬¿ÉÒÔÉèÖÃSGA_MAX_SIZE£¬¸Ã²ÎÊýÓÃÒÔ¿ØÖƸ÷»º³å³ØÊ¹ÓõÄÄÚ´æ×ܺͣ¬±¾ÖÊÉÏÊÇÔÚ½ø³ÌÖÐÔ¤ÏÈ·ÖÅäÒ»¶ÎÐéÄâµØÖ·±¸Óöø²»·ÖÅäÎïÀíÄڴ棬ĿµÄÊÇ·ÀÖ¹ºÍ½ø³Ç˽ÓеØÖ·¶ÎµÄ³åÍ»¡£
Ö»Òª×ܵÄSGAÄÚ´æÉèÖò»³¬¹ýSGA_MAX_SIZEµÄÉèÖ㬸ü¸Ä¶¼¿ÉÒÔÁ¢¼´ÉúЧ¡£ÐèҪעÒâµÄÊÇ£¬ÔÚOracle 9iR1ÖУ¬¶¯Ì¬¼õСÄÚ´ ......

ÔÚlinuxÉÏsilent°²×°oracle¼òÖ±ÊÇÒ»³¡Ø¬ÃÎ

 Parsing command line arguments:
    Parameter "silent" = true
java.lang.ArrayIndexOutOfBoundsException: 2
        at oracle.net.ca.CmdlineArgs.parseArgs(Unknown Source)
        at oracle.net.ca.I ......

ORACLE²éѯ»òɾ³ýʱָ¶¨Ê¹ÓÃË÷ÒýµÄд·¨­

 ²éѯʱ¿ÉÒÔÖ¸¶¨Ê¹ÓÃË÷ÒýµÄд·¨¡£­
­
SELECT   /*+ index(TB_ALIAS IX_G_COST3) */­
  TB_ALIAS.*­
  from g_Cost TB_ALIAS­
WHERE Item_Two = 0­
   AND Flight_Date >= To_Date('20061201', 'YYYYMMDD')­
   AND Flight_D ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ