Oracle
2011/09/07
Oracle Database¤Ç¥¨¥¯¥¹¥Ý¡¼¥È½ÐÎÏÀè¤òÊѹ¹¤¹¤ëÊýË¡
°ÊÁ°½ñ¤¤Þ¤·¤¿¤¬¡¢
Oracle¤Îµì¥¨¥¯¥¹¥Ý¡¼¥Èµ¡Ç½¡Êexp¡Ë¤Ï10gR2¤«¤é¥µ¥Ý¡¼¥È¤µ¤ì¤Ê¤¯¤Ê¤ê¤Þ¤·¤¿¡£
¤½¤ó¤ÊÌõ¤Ç¡¢¤³¤ì¤«¤é¤ÏOracle Data Pump¤Î¥¨¥¯¥¹¥Ý¡¼¥È¡Êexpdp¡Ë¥³¥Þ¥ó¥É¤ò»È¤¦Ìõ¤Ç¤¹¤¬¡¢
¤³¤¤¤Ä¤Î½ÐÎÏÀè¤Ï¥Ç¥£¥ì¥¯¥È¥ê¥ª¥Ö¥¸¥§¥¯¥È¤È¤·¤Æ´ÉÍý¤µ¤ì¤Æ¤¤¤ë¤½¤¦¤Ê¡£
¤Ç¡¢½ÐÎÏÀè¥Ç¥£¥ì¥¯¥È¥ê¤òÊѹ¹¤¹¤ë¤Ë¤Ï¡¢°Ê²¼¤ÎSQL¤ò»È¤¤¤Þ¤·¤¿¡£
CREATE OR REPLACE DIRECTORY "DATA_PUMP_DIR" AS '/hoge/fuga'
¤¨¤¨¡£¤¿¤À¤Î¥á¥â¤Ç¤¹¤¬¡¢²¿¤«¡©¨¤(¡±¥Ø¡±¡Ë¨£
Oracle¤Îµì¥¨¥¯¥¹¥Ý¡¼¥Èµ¡Ç½¡Êexp¡Ë¤Ï10gR2¤«¤é¥µ¥Ý¡¼¥È¤µ¤ì¤Ê¤¯¤Ê¤ê¤Þ¤·¤¿¡£
¤½¤ó¤ÊÌõ¤Ç¡¢¤³¤ì¤«¤é¤ÏOracle Data Pump¤Î¥¨¥¯¥¹¥Ý¡¼¥È¡Êexpdp¡Ë¥³¥Þ¥ó¥É¤ò»È¤¦Ìõ¤Ç¤¹¤¬¡¢
¤³¤¤¤Ä¤Î½ÐÎÏÀè¤Ï¥Ç¥£¥ì¥¯¥È¥ê¥ª¥Ö¥¸¥§¥¯¥È¤È¤·¤Æ´ÉÍý¤µ¤ì¤Æ¤¤¤ë¤½¤¦¤Ê¡£
¤Ç¡¢½ÐÎÏÀè¥Ç¥£¥ì¥¯¥È¥ê¤òÊѹ¹¤¹¤ë¤Ë¤Ï¡¢°Ê²¼¤ÎSQL¤ò»È¤¤¤Þ¤·¤¿¡£
CREATE OR REPLACE DIRECTORY "DATA_PUMP_DIR" AS '/hoge/fuga'
¤¨¤¨¡£¤¿¤À¤Î¥á¥â¤Ç¤¹¤¬¡¢²¿¤«¡©¨¤(¡±¥Ø¡±¡Ë¨£
tsutaken at 12:35¡ÃPermalink¨¢Comments(1)
2009/11/14
Oracle Enterprise Manager¤òºÆ¹½À®¤¹¤ëÊýË¡¡ÊWindowsÈÇ¡Ë
¤Ò¤ç¤ó¤Ê¤³¤È¤«¤é¡¢Windows¥µ¡¼¥Ð¾å¤ÎOracle°Ü¹Ô¤ò¤ä¤ë¤³¤È¤Ë¤Ê¤ê¡¢
¤¢¤ì¤³¤ì¤ä¤Ã¤Æ¤¤¤ë¤¦¤Á¤Ë¡¢Enterprise Manager¤¬µ¯Æ°¤·¤Ê¤¯¤Ê¤Ã¤¿¡Ê´À¡Ë
»ÅÊý¤Ê¤¯¡¢Enterprise Manager¤ÎºÆ¹½À®¤ò¼Â»Ü¤·¤¿¤Î¤Ç¥á¥â¡£
Oracle¤Î¥Ð¡¼¥¸¥ç¥ó¡¡¡§¡¡10.1.0.2.0
³¤¤òÆɤà
¤¢¤ì¤³¤ì¤ä¤Ã¤Æ¤¤¤ë¤¦¤Á¤Ë¡¢Enterprise Manager¤¬µ¯Æ°¤·¤Ê¤¯¤Ê¤Ã¤¿¡Ê´À¡Ë
»ÅÊý¤Ê¤¯¡¢Enterprise Manager¤ÎºÆ¹½À®¤ò¼Â»Ü¤·¤¿¤Î¤Ç¥á¥â¡£
Oracle¤Î¥Ð¡¼¥¸¥ç¥ó¡¡¡§¡¡10.1.0.2.0
³¤¤òÆɤà
tsutaken at 23:50¡ÃPermalink¨¢Comments(0)
2009/04/12
Oracle Database¤ÎJA16SJIS¤Ë¤Ï£²¼ïÎढ¤ë
¤Á¤ç¤³¤Ã¤È¥á¥â½ñ¤¡£
Oracle Database¤ÎSJIS¤Ë¤Ï£²¼ïÎब¤¢¤ë¡£
£±¡¥JAPANESE_JAPAN.JA16SJIS
£²¡¥JAPANESE_JAPAN.JA16SJISTILDE
¤½¤Î°ã¤¤¤Ï¡¢¼è¤ê½Ð¤·¤¿Ê¸»ú¤òUNICODE¤Ç°·¤¦¾ì¹ç¤Ë¡¢¡Ö¡Á¡×¤¬²½¤±¤ë¤«Èݤ«¡£
¢¨¤½¤Î¾¤ÎºÇ¿·¾ðÊó¤Ï¸ø¼°¥Þ¥Ë¥å¥¢¥ë»²¾È
Oracle Database¤ÎSJIS¤Ë¤Ï£²¼ïÎब¤¢¤ë¡£
£±¡¥JAPANESE_JAPAN.JA16SJIS
£²¡¥JAPANESE_JAPAN.JA16SJISTILDE
¤½¤Î°ã¤¤¤Ï¡¢¼è¤ê½Ð¤·¤¿Ê¸»ú¤òUNICODE¤Ç°·¤¦¾ì¹ç¤Ë¡¢¡Ö¡Á¡×¤¬²½¤±¤ë¤«Èݤ«¡£
¢¨¤½¤Î¾¤ÎºÇ¿·¾ðÊó¤Ï¸ø¼°¥Þ¥Ë¥å¥¢¥ë»²¾È
tsutaken at 17:01¡ÃPermalink¨¢Comments(0)
2009/02/21
Oracle Database 11g¤Îmemory_max_target¤Ï¤É¤³¤Þ¤Ç¤¤¤±¤ë¤Î¤«¡©¡Ê32bit WinÈÇ¡Ë
Oracle11g¤Îmemory_max_target¤òÃΤä¿»þ¤«¤éµ¤¤Ë¤Ê¤Ã¤Æ¤¤¤¿¤³¤È¡£
¡Øɸ½à¾õÂÖ¤ÎWindows¡Ê32bit¡Ë¤Ç¤Ï¡¢ºÇÂ粿MB¤Þ¤Ç²ÔÆ°²Äǽ¤Ê¤Î¤«¡©¡Ù
¤ò»î¤·¤Æ¤ß¤Þ¤·¤¿¡£
¢¨¤½¤Î°Ù¤Ë¡ÖOracle¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥Ñ¥é¥á¡¼¥¿ÀßÄê¥Õ¥¡¥¤¥ë¡×¤òÄ´¤Ù¤Æ¤¿Ìõ¤Ç¤¹£÷
¢£ÍøÍѴĶ
¡¡OS¡§Windows Server 2003 Standard Edition SP2
¡¡CPU¡§Dual-Core Xeon 2.4Ghz
¡¡MEM¡§3.75GB
²¿¸Î¤«¡¢memory_max_target¡ámemory_target¡á2432MB¤Þ¤Ç
µ¯Æ°¤¹¤ë¤³¤È¤¬³Îǧ¤Ç¤¤Þ¤·¤¿¡£
OS¤ÎÀ©¸Â¾å¡¢1¥×¥í¥»¥¹¤¢¤¿¤ê¤Ï2GB¤Þ¤Ç¤·¤«»È¤¨¤Ê¤¤¤Ï¤º¤Ê¤ó¤Ç¤¹¤¬¡¢
Éé²Ù¤¬¤«¤«¤Ã¤Æ¤¤¤Ê¤¤¾õÂ֤Ǥϡ¢¤½¤³¤Þ¤Ç¥á¥â¥ê³ÎÊݤ˹Ԥ«¤Ê¤¤¤Î¤«¤â¡£
¤Þ¤¡¡¢Í¾Íµ¤ò¸«¤Æ¤â¡¢1800MB¤¯¤é¤¤¤ÏÀßÄꤷ¤ÆÎɤµ¤½¤¦¤Ç¤¹¤Í(¡¦¢Ï¡¦)
¡Øɸ½à¾õÂÖ¤ÎWindows¡Ê32bit¡Ë¤Ç¤Ï¡¢ºÇÂ粿MB¤Þ¤Ç²ÔÆ°²Äǽ¤Ê¤Î¤«¡©¡Ù
¤ò»î¤·¤Æ¤ß¤Þ¤·¤¿¡£
¢¨¤½¤Î°Ù¤Ë¡ÖOracle¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥Ñ¥é¥á¡¼¥¿ÀßÄê¥Õ¥¡¥¤¥ë¡×¤òÄ´¤Ù¤Æ¤¿Ìõ¤Ç¤¹£÷
¢£ÍøÍѴĶ
¡¡OS¡§Windows Server 2003 Standard Edition SP2
¡¡CPU¡§Dual-Core Xeon 2.4Ghz
¡¡MEM¡§3.75GB
²¿¸Î¤«¡¢memory_max_target¡ámemory_target¡á2432MB¤Þ¤Ç
µ¯Æ°¤¹¤ë¤³¤È¤¬³Îǧ¤Ç¤¤Þ¤·¤¿¡£
OS¤ÎÀ©¸Â¾å¡¢1¥×¥í¥»¥¹¤¢¤¿¤ê¤Ï2GB¤Þ¤Ç¤·¤«»È¤¨¤Ê¤¤¤Ï¤º¤Ê¤ó¤Ç¤¹¤¬¡¢
Éé²Ù¤¬¤«¤«¤Ã¤Æ¤¤¤Ê¤¤¾õÂ֤Ǥϡ¢¤½¤³¤Þ¤Ç¥á¥â¥ê³ÎÊݤ˹Ԥ«¤Ê¤¤¤Î¤«¤â¡£
¤Þ¤¡¡¢Í¾Íµ¤ò¸«¤Æ¤â¡¢1800MB¤¯¤é¤¤¤ÏÀßÄꤷ¤ÆÎɤµ¤½¤¦¤Ç¤¹¤Í(¡¦¢Ï¡¦)
tsutaken at 17:59¡ÃPermalink¨¢Comments(0)
2009/02/15
Oracle Database 10¤Î¥Ñ¥é¥á¡¼¥¿ÀßÄê¥Õ¥¡¥¤¥ë
Oracle¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ë¤Ï¡¢¥Ñ¥é¥á¡¼¥¿ÀßÄê¥Õ¥¡¥¤¥ë¤¬£²¼ïÎढ¤ë¡£
¡¦pfile¡¡¢ª¡¡¥Æ¥¥¹¥È·Á¼°¡Ê¡áľÀÜÊÔ½¸²Äǽ¡Ë
¡¦spfile¡¡¢ª¡¡¥Ð¥¤¥Ê¥ê·Á¼°¡Ê¡áSQL¤ÇÊѹ¹¡Ë
¤Ç¡¢ÍøÍѤµ¤ì¤ë¾ò·ï¤Ï°Ê²¼¤ÎÄ̤ꡣ
¹¹¤Ë¡¢SQL¤Ç°ìÊý¤«¤é¾Êý¤òÀ¸À®¤¹¤ë¤³¤È¤¬¤Ç¤¤ë¡£
¡¦pfile ¢ª¡¡spfileÀ¸À®
¡¡SQL> create spfile from pfile;
¡¦spfile ¢ª¡¡pfileÀ¸À®
¡¡SQL> create pfile from spfile;
½ÐÎϾì½ê¤Ï
D:\ORACLE\PRODUCT\10.2.0\DB_1\dbs\SPFILEORCL.ORA
¤È¤«¡£
¥Ñ¥é¥á¡¼¥¿¤Î¸¡¾Ú¤Î»þ¤Ï¡¢µ¯Æ°¤¹¤ë¾õÂÖ¤Îpfile¤òºî¤Ã¤Æ¼è¤Ã¤Æ¤ª¤±¤Ð°Â¿´¡£
pfile°ìËÜÁä¤Ç¤âÎɤµ¤½¤¦¤Ê¤â¤Î¤Ç¤¹¤¬¡¢²ÔÆ°Ãæ¤Ë¤¢¤ëÄøÅÙ¤ÎÊѹ¹¤¬¸ú¤¯¤Î¤Ïspfile¤Î¤ª¤«¤²¤Ê¤Î¤«¤â¡Ê¡©¡Ë
¡¦pfile¡¡¢ª¡¡¥Æ¥¥¹¥È·Á¼°¡Ê¡áľÀÜÊÔ½¸²Äǽ¡Ë
¡¦spfile¡¡¢ª¡¡¥Ð¥¤¥Ê¥ê·Á¼°¡Ê¡áSQL¤ÇÊѹ¹¡Ë
¤Ç¡¢ÍøÍѤµ¤ì¤ë¾ò·ï¤Ï°Ê²¼¤ÎÄ̤ꡣ
¡üÍ¥Àè½ç°Ì¤Ï¡¢°Ê²¼¤Î¤È¤ª¤ê¤È¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£
1.. µ¯Æ°»þ¤Ë»ØÄꤷ¤¿pfile¡§startup pfile='[¥Õ¥¡¥¤¥ë]'
2.. spfileSID.ora
3.. spfile.ora
4.. initSID.ora
5.. init.ora
¹¹¤Ë¡¢SQL¤Ç°ìÊý¤«¤é¾Êý¤òÀ¸À®¤¹¤ë¤³¤È¤¬¤Ç¤¤ë¡£
¡¦pfile ¢ª¡¡spfileÀ¸À®
¡¡SQL> create spfile from pfile;
¡¦spfile ¢ª¡¡pfileÀ¸À®
¡¡SQL> create pfile from spfile;
½ÐÎϾì½ê¤Ï
D:\ORACLE\PRODUCT\10.2.0\DB_1\dbs\SPFILEORCL.ORA
¤È¤«¡£
¥Ñ¥é¥á¡¼¥¿¤Î¸¡¾Ú¤Î»þ¤Ï¡¢µ¯Æ°¤¹¤ë¾õÂÖ¤Îpfile¤òºî¤Ã¤Æ¼è¤Ã¤Æ¤ª¤±¤Ð°Â¿´¡£
pfile°ìËÜÁä¤Ç¤âÎɤµ¤½¤¦¤Ê¤â¤Î¤Ç¤¹¤¬¡¢²ÔÆ°Ãæ¤Ë¤¢¤ëÄøÅÙ¤ÎÊѹ¹¤¬¸ú¤¯¤Î¤Ïspfile¤Î¤ª¤«¤²¤Ê¤Î¤«¤â¡Ê¡©¡Ë
tsutaken at 00:25¡ÃPermalink¨¢Comments(0)
2009/02/08
Oracle Database¤ÎɽÎΰ褬32GB¤«¤é¼«Æ°³ÈÄ¥¤·¤Ê¤«¤Ã¤¿·ï
º£¤Þ¤Ç¤¢¤Þ¤ê°Õ¼±¤·¤Æ¤¤¤Ê¤«¤Ã¤¿¡¢
Oracle¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎɽÎΰè¤È¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤Ë¤Ä¤¤¤Æ¡£
¤³¤ó¤ÊSQL¤ÇɽÎΰè¤òºîÀ®¤¹¤ë¤È¡¢
ɽÎΰè¤ÏɬÍפ˱þ¤¸¤Æ¼«Æ°¤Ç³ÈÄ¥¤µ¤ì¤ë¡£
¤Ê¤Î¤Ç¡¢Êü¤Ã¤Æ¤ª¤¤¤Æ¤âÂç¾æÉפÀ¤È»×¤Ã¤Æ¤¤¤¿¤ó¤Ç¤¹¤¬¡¢
¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤òSMALLFILE¤ÇºîÀ®¤¹¤ë¤È¡¢¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¥µ¥¤¥º¤¬32GB¤Þ¤Ç¤·¤«³ÈÄ¥¤µ¤ì¤Ê¤¤¤é¤·¤¤¡£¡£¡£
¤¸¤ã¤¢¡¢¤É¤¦¤¹¤ë¤«¡©
¡±¿ÍѤÎÅÓÃæ¤Ç¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤òÄɲ乤ë
¢¹½ÃÛ»þ¤Î¥µ¥¤¥¸¥ó¥°¤ÇɬÍפʥǡ¼¥¿¥Õ¥¡¥¤¥ë¿ô¤ò³ä¤ê½Ð¤·¡¢¤Ï¤¸¤á¤«¤é¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤òÊ£¿ô¤Ë¤·¤Æ¤ª¤¯¡£
¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤ò³ÈÄ¥¤Ç¤¤Ê¤¯¤Ê¤Ã¤¿¤é¡¢
Ʊ¤¸¤È¤³¤í¤Ë¾¡¼ê¤Ë¿·µ¬ºîÀ®¤·¤Æ¤¯¤ì¤ì¤ÐÎɤ¤¤Î¤Ë¡£¡£¡£
¤Ê¡Á¤ó¤Æ»×¤¦¤Î¤Ï¡¢Àõ¤Ï¤«¤Ç¤·¤ç¤¦¤«¡©¡©
¹¹¤ËÊ£¿ô¤Î¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤Ï¡¢°Ê²¼¤Î¤è¤¦¤Ë»È¤ï¤ì¤ë¤é¤·¤¤¡£
¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤Îʬ³ä¤Ï¡¢¥Ç¥£¥¹¥¯IO¤òʬ»¶¤µ¤»¤¿¤¤»þ¤Ë¤âÍøÍѤ¹¤ë¤é¤·¤¤¤Î¤Ç¡¢
¾åµ¤ÎÆ°¤¤ÏÅöÁ³¤È¸À¤¨¤ÐÅöÁ³¤Ç¤¹¤Í¡£
£¤Ï¤¸¤á¤«¤é¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤òBIGFILE¤ÇºîÀ®¤¹¤ë¡£
¤³¤ì¤Ï¤ä¤Ã¤¿¤³¤È¤¬Ìµ¤¤¤Ç¤¹¡£
ÇË»»þ¤Î¥ê¥¹¥È¥¢¤Ë»þ´Ö¤¬¤«¤«¤ë¤é¤·¤¤¤Î¤Ç¡¢¤´ÍøÍѤϷײèŪ¤Ëw
Oracle¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎɽÎΰè¤È¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤Ë¤Ä¤¤¤Æ¡£
¤³¤ó¤ÊSQL¤ÇɽÎΰè¤òºîÀ®¤¹¤ë¤È¡¢
CREATE SMALLFILE TABLESPACE "TBL01"
DATAFILE 'TBL01.DBF'
SIZE 1000M
REUSE AUTOEXTEND ON
LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
ɽÎΰè¤ÏɬÍפ˱þ¤¸¤Æ¼«Æ°¤Ç³ÈÄ¥¤µ¤ì¤ë¡£
¤Ê¤Î¤Ç¡¢Êü¤Ã¤Æ¤ª¤¤¤Æ¤âÂç¾æÉפÀ¤È»×¤Ã¤Æ¤¤¤¿¤ó¤Ç¤¹¤¬¡¢
¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤òSMALLFILE¤ÇºîÀ®¤¹¤ë¤È¡¢¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¥µ¥¤¥º¤¬32GB¤Þ¤Ç¤·¤«³ÈÄ¥¤µ¤ì¤Ê¤¤¤é¤·¤¤¡£¡£¡£
¤¸¤ã¤¢¡¢¤É¤¦¤¹¤ë¤«¡©
¡±¿ÍѤÎÅÓÃæ¤Ç¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤òÄɲ乤ë
ALTER TABLESPACE "TBL01"
ADD DATAFILE 'TBL02.DBF'
SIZE 1000M
REUSE AUTOEXTEND ON;
¢¹½ÃÛ»þ¤Î¥µ¥¤¥¸¥ó¥°¤ÇɬÍפʥǡ¼¥¿¥Õ¥¡¥¤¥ë¿ô¤ò³ä¤ê½Ð¤·¡¢¤Ï¤¸¤á¤«¤é¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤òÊ£¿ô¤Ë¤·¤Æ¤ª¤¯¡£
CREATE SMALLFILE TABLESPACE "TBL01"
DATAFILE 'TBL01.DBF' SIZE 1000M
REUSE AUTOEXTEND ON
, 'TBL02.DBF' SIZE 1000M
REUSE AUTOEXTEND ON
LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤ò³ÈÄ¥¤Ç¤¤Ê¤¯¤Ê¤Ã¤¿¤é¡¢
Ʊ¤¸¤È¤³¤í¤Ë¾¡¼ê¤Ë¿·µ¬ºîÀ®¤·¤Æ¤¯¤ì¤ì¤ÐÎɤ¤¤Î¤Ë¡£¡£¡£
¤Ê¡Á¤ó¤Æ»×¤¦¤Î¤Ï¡¢Àõ¤Ï¤«¤Ç¤·¤ç¤¦¤«¡©¡©
¹¹¤ËÊ£¿ô¤Î¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤Ï¡¢°Ê²¼¤Î¤è¤¦¤Ë»È¤ï¤ì¤ë¤é¤·¤¤¡£
¤Á¤Ê¤ß¤Ë¡¢10G ¤ÎɽÎΰè¤ò 5G ¤º¤Äʬ¤±¤¿¾ì¹ç¡¢ÊÒÊý¤Î¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤¬¤¤¤Ã¤Ñ¤¤¤Ë¤Ê¤ë¤Þ¤Ç»È¤ï¤ì¤Æ¤½¤ì¤«¤é¤â¤¦ÊÒÊý¤¬»È¤ï¤ì¤ë¤ï¤±¤Ç¤Ï¤Ê¤¯¡¢Î¾Êý¤Î¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤¬¸ò¸ß¤Ë»È¤ï¤ì¤ë¤è¤¦¤Ç¤¹¡£
¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤Îʬ³ä¤Ï¡¢¥Ç¥£¥¹¥¯IO¤òʬ»¶¤µ¤»¤¿¤¤»þ¤Ë¤âÍøÍѤ¹¤ë¤é¤·¤¤¤Î¤Ç¡¢
¾åµ¤ÎÆ°¤¤ÏÅöÁ³¤È¸À¤¨¤ÐÅöÁ³¤Ç¤¹¤Í¡£
£¤Ï¤¸¤á¤«¤é¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤òBIGFILE¤ÇºîÀ®¤¹¤ë¡£
¤³¤ì¤Ï¤ä¤Ã¤¿¤³¤È¤¬Ìµ¤¤¤Ç¤¹¡£
ÇË»»þ¤Î¥ê¥¹¥È¥¢¤Ë»þ´Ö¤¬¤«¤«¤ë¤é¤·¤¤¤Î¤Ç¡¢¤´ÍøÍѤϷײèŪ¤Ëw
tsutaken at 23:59¡ÃPermalink¨¢Comments(0)
2009/01/18
Oracle Database Standard Edition¤ÈStandard Edition One¤Î°ã¤¤
¤¹¤°Ëº¤ì¤ë¤Î¤Ç¥á¥â½ñ¤¡£
Oracle Database Standard Edition ¤È¡¢
Oracle Database Standard Edition One¤Î°ã¤¤¤òÂç¤Þ¤«¤Ë¸À¤¦¤È¡¢¡¢¡¢
SE¤Ï4¥½¥±¥Ã¥È¤Þ¤Ç£Ï£Ë¡£
SE ONE¤Ï2¥½¥±¥Ã¥È¤Þ¤Ç£Ï£Ë¡£
¤Ã¤Æ¤À¤±¡£
¾ÜºÙ¤Ï¤³¤Á¤é¤ò»²¾È¡£
http://www.oracle.com/lang/jp/corporate/pricing/se_seone.html
Oracle Database Standard Edition ¤È¡¢
Oracle Database Standard Edition One¤Î°ã¤¤¤òÂç¤Þ¤«¤Ë¸À¤¦¤È¡¢¡¢¡¢
SE¤Ï4¥½¥±¥Ã¥È¤Þ¤Ç£Ï£Ë¡£
SE ONE¤Ï2¥½¥±¥Ã¥È¤Þ¤Ç£Ï£Ë¡£
¤Ã¤Æ¤À¤±¡£
¾ÜºÙ¤Ï¤³¤Á¤é¤ò»²¾È¡£
http://www.oracle.com/lang/jp/corporate/pricing/se_seone.html
tsutaken at 00:00¡ÃPermalink¨¢Comments(0)
2008/12/11
Oracle Database¤Îmemory_max_target¤ÏÊØÍø¤À¤Í
¤½¤·¤Æ¹¹¤ËÁ°²ó¤Î³¤¡£
ºÇ¶á²¿¸ÎWindows¤Î¥á¥â¥ê¤Ë¤Ä¤¤¤ÆÄ´¤Ù¤Æ¤¤¤¿¤«¤È¤¤¤¦¤È¡¢
Oracle Database 10g¤Î¥á¥â¥ê¥µ¥¤¥º¤òºÇÂç¤Ë¤·¤¿¤«¤Ã¤¿¤«¤é¤Ê¤Î¤Ç¤¹¡£
Oracle¤ÉÁǿͤʻä¤Ï¡¢¥á¥â¥ê¥Á¥å¡¼¥Ë¥ó¥°¤È¸À¤Ã¤Æ¤â¡¢
SGA¤ÈPGA¤¯¤é¤¤¤·¤«ÃΤê¤Þ¤»¤ó¡£
Á°²ó¤Î·ëÏÀ¤«¤é¡¢
SGA + PGA = 2GB
¤Ç¤¢¤ì¤ÐÌäÂê̵¤¤¤Ï¤º¡£¡£¡£
¤â¤Ã¤ÈÁý¤ä¤»¤½¤¦¤Êµ¤¤â¤·¤Þ¤¹¤¬¡¢
º£²ó¤Ï;͵¤ò¤ß¤ÆºÇÂçSGA¥µ¥¤¥º¤ò1.6GBÄøÅ٤ˤ·¤Æ¤ª¤¤Þ¤·¤¿¡£
¤Á¤Ê¤ß¤ËOracle Database 11g¤Ë¤Ê¤ë¤È¡¢
memory_max_target
memory_target
¤È¤¤¤¦¥Ñ¥é¥á¡¼¥¿¤¬¤¢¤ê¡¢
Oracle¤Ë³ä¤êÅö¤Æ¤ëºÇÂç¥á¥â¥ê¥µ¥¤¥º¤µ¤¨»ØÄꤷ¤Æ¤ª¤±¤Ð¡¢
DBMS¤¬¼«Æ°¤ÇSGA¤äPGA¤Ë³ä¤ê¿¶¤Ã¤Æ¤¯¤ì¤ë¤è¤¦¤Ç¤¹¡£
¡Ö¤½¤¦¤½¤¦¡ª¤³¡¼¤¤¤¦¤Î¤òÂԤäƤ¿¤è¡ª¡ª¡×¤Ã¤Æ´¶¤¸¤Ç¤¹¤Í¡Ê^0^¡Ë
ºÇ¶á²¿¸ÎWindows¤Î¥á¥â¥ê¤Ë¤Ä¤¤¤ÆÄ´¤Ù¤Æ¤¤¤¿¤«¤È¤¤¤¦¤È¡¢
Oracle Database 10g¤Î¥á¥â¥ê¥µ¥¤¥º¤òºÇÂç¤Ë¤·¤¿¤«¤Ã¤¿¤«¤é¤Ê¤Î¤Ç¤¹¡£
Oracle¤ÉÁǿͤʻä¤Ï¡¢¥á¥â¥ê¥Á¥å¡¼¥Ë¥ó¥°¤È¸À¤Ã¤Æ¤â¡¢
SGA¤ÈPGA¤¯¤é¤¤¤·¤«ÃΤê¤Þ¤»¤ó¡£
Á°²ó¤Î·ëÏÀ¤«¤é¡¢
SGA + PGA = 2GB
¤Ç¤¢¤ì¤ÐÌäÂê̵¤¤¤Ï¤º¡£¡£¡£
¤â¤Ã¤ÈÁý¤ä¤»¤½¤¦¤Êµ¤¤â¤·¤Þ¤¹¤¬¡¢
º£²ó¤Ï;͵¤ò¤ß¤ÆºÇÂçSGA¥µ¥¤¥º¤ò1.6GBÄøÅ٤ˤ·¤Æ¤ª¤¤Þ¤·¤¿¡£
¤Á¤Ê¤ß¤ËOracle Database 11g¤Ë¤Ê¤ë¤È¡¢
memory_max_target
memory_target
¤È¤¤¤¦¥Ñ¥é¥á¡¼¥¿¤¬¤¢¤ê¡¢
Oracle¤Ë³ä¤êÅö¤Æ¤ëºÇÂç¥á¥â¥ê¥µ¥¤¥º¤µ¤¨»ØÄꤷ¤Æ¤ª¤±¤Ð¡¢
DBMS¤¬¼«Æ°¤ÇSGA¤äPGA¤Ë³ä¤ê¿¶¤Ã¤Æ¤¯¤ì¤ë¤è¤¦¤Ç¤¹¡£
¡Ö¤½¤¦¤½¤¦¡ª¤³¡¼¤¤¤¦¤Î¤òÂԤäƤ¿¤è¡ª¡ª¡×¤Ã¤Æ´¶¤¸¤Ç¤¹¤Í¡Ê^0^¡Ë
tsutaken at 00:46¡ÃPermalink¨¢Comments(0)