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

oracle±í·ÖÇøÏê½â

http://tianzt.blog.51cto.com/459544/171759
 ´ËÎÄ´ÓÒÔϼ¸¸ö·½ÃæÀ´ÕûÀí¹ØÓÚ·ÖÇø±íµÄ¸ÅÄî¼°²Ù×÷:
        1.±í¿Õ¼ä¼°·ÖÇø±íµÄ¸ÅÄî
        2.±í·ÖÇøµÄ¾ßÌå×÷ÓÃ
        3.±í·ÖÇøµÄÓÅȱµã
        4.±í·ÖÇøµÄ¼¸ÖÖÀàÐͼ°²Ù×÷·½·¨
        5.¶Ô±í·ÖÇøµÄά»¤ÐÔ²Ù×÷.
(1.) ±í¿Õ¼ä¼°·ÖÇø±íµÄ¸ÅÄî
±í¿Õ¼ä£º
¡¡¡¡ÊÇÒ»¸ö»ò¶à¸öÊý¾ÝÎļþµÄ¼¯ºÏ£¬ËùÓеÄÊý¾Ý¶ÔÏ󶼴æ·ÅÔÚÖ¸¶¨µÄ±í¿Õ¼äÖУ¬µ«Ö÷Òª´æ·ÅµÄÊÇ±í£¬ ËùÒÔ³Æ×÷±í¿Õ¼ä¡£
 
·ÖÇø±í£º 
µ±±íÖеÄÊý¾ÝÁ¿²»¶ÏÔö´ó£¬²éѯÊý¾ÝµÄËٶȾͻá±äÂý£¬Ó¦ÓóÌÐòµÄÐÔÄܾͻáϽµ£¬Õâʱ¾ÍÓ¦¸Ã¿¼ÂǶԱí½øÐзÖÇø¡£±í½øÐзÖÇøºó£¬Âß¼­ÉϱíÈÔÈ»ÊÇÒ»ÕÅÍêÕûµÄ±í£¬Ö»Êǽ«±íÖеÄÊý¾ÝÔÚÎïÀíÉÏ´æ·Åµ½¶à¸ö±í¿Õ¼ä(ÎïÀíÎļþÉÏ)£¬ÕâÑù²éѯÊý¾Ýʱ£¬²»ÖÁÓÚÿ´Î¶¼É¨ÃèÕûÕÅ±í¡£
 
( 2).±í·ÖÇøµÄ¾ßÌå×÷ÓÃ
OracleµÄ±í·ÖÇø¹¦ÄÜͨ¹ý¸ÄÉƿɹÜÀíÐÔ¡¢ÐÔÄܺͿÉÓÃÐÔ£¬´Ó¶øΪ¸÷ʽӦÓóÌÐò´øÀ´Á˼«´óµÄºÃ´¦¡£Í¨³££¬·ÖÇø¿ÉÒÔʹijЩ²éѯÒÔ¼°Î¬»¤²Ù×÷µÄÐÔÄÜ´ó´óÌá¸ß¡£´ËÍâ,·ÖÇø»¹¿ÉÒÔ¼«´ó¼ò»¯³£¼ûµÄ¹ÜÀíÈÎÎñ£¬·ÖÇøÊǹ¹½¨Ç§Õ××Ö½ÚÊý¾Ýϵͳ»ò³¬¸ß¿ÉÓÃÐÔϵͳµÄ¹Ø¼ü¹¤¾ß¡£
 
·ÖÇø¹¦ÄÜÄܹ»½«±í¡¢Ë÷Òý»òË÷Òý×éÖ¯±í½øÒ»²½Ï¸·ÖΪ¶Î£¬ÕâЩÊý¾Ý¿â¶ÔÏóµÄ¶Î½Ð×ö·ÖÇø¡£Ã¿¸ö·ÖÇøÓÐ×Ô¼ºµÄÃû³Æ£¬»¹¿ÉÒÔÑ¡Ôñ×Ô¼ºµÄ´æ´¢ÌØÐÔ¡£´ÓÊý¾Ý¿â¹ÜÀíÔ±µÄ½Ç¶ÈÀ´¿´£¬Ò»¸ö·ÖÇøºóµÄ¶ÔÏó¾ßÓжà¸ö¶Î£¬ÕâЩ¶Î¼È¿É½øÐм¯Ìå¹ÜÀí£¬Ò²¿Éµ¥¶À¹ÜÀí£¬Õâ¾ÍʹÊý¾Ý¿â¹ÜÀíÔ±ÔÚ¹ÜÀí·ÖÇøºóµÄ¶ÔÏóʱÓÐÏ൱´óµÄÁé»îÐÔ¡£µ«ÊÇ£¬´ÓÓ¦ÓóÌÐòµÄ½Ç¶ÈÀ´¿´£¬·ÖÇøºóµÄ±íÓë·Ç·ÖÇø±íÍêÈ«Ïàͬ£¬Ê¹Óà SQL DML ÃüÁî·ÃÎÊ·ÖÇøºóµÄ±íʱ£¬ÎÞÐèÈκÎÐ޸ġ£
 
ʲôʱºòʹÓ÷ÖÇø±í£º
1¡¢±íµÄ´óС³¬¹ý2GB¡£
2¡¢±íÖаüº¬ÀúÊ·Êý¾Ý£¬ÐµÄÊý¾Ý±»Ôö¼Ó¶¼ÐµķÖÇøÖС£
 
 (3).±í·ÖÇøµÄÓÅȱµã
±í·ÖÇøÓÐÒÔÏÂÓŵ㣺 
1¡¢¸ÄÉƲéѯÐÔÄÜ£º¶Ô·ÖÇø¶ÔÏóµÄ²éѯ¿ÉÒÔ½öËÑË÷×Ô¼º¹ØÐĵķÖÇø£¬Ìá¸ß¼ìË÷Ëٶȡ£
2¡¢ÔöÇ¿¿ÉÓÃÐÔ£ºÈç¹û±íµÄij¸ö·ÖÇø³öÏÖ¹ÊÕÏ£¬±íÔÚÆäËû·ÖÇøµÄÊý¾ÝÈÔÈ»¿ÉÓã»
3¡¢Î¬»¤·½±ã£ºÈç¹û±íµÄij¸ö·ÖÇø³öÏÖ¹ÊÕÏ£¬ÐèÒªÐÞ¸´Êý¾Ý£¬Ö»ÐÞ¸´¸Ã·ÖÇø¼´¿É£»
4¡¢¾ùºâI/O£º¿ÉÒ԰Ѳ»Í¬µÄ·ÖÇøÓ³Éäµ½´ÅÅÌÒÔƽºâI/O£¬¸ÄÉÆÕû¸öϵͳÐÔÄÜ¡£
 
ȱµã£º 
·ÖÇø±íÏà¹Ø£ºÒѾ­´æÔڵıíûÓз½


Ïà¹ØÎĵµ£º

Íêȫɾ³ýOracle


ʵÏÖ·½·¨£º
     1¡¢¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾¹ÜÀí¹¤¾ß£­£¾·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ¡£
     2¡¢¿ªÊ¼£­£¾³ÌÐò£­£¾Oracle - OraHome81£­£¾Oracle Installation Products£­£¾Universal Installer
жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí²»Äܱ»É¾³ý
  &nb ......

ORACLEÓɽű¾µ½´´½¨Êý¾Ý¿âÍêÕû¹ý³Ì¡£

£¨1£©ÒÔSYSÉí·ÝµÇ½
conn sys/sysem_pwd as sysdba;
£¨2£©´´½¨amlyÓû§
create user amly identified by 9imly;
£¨3£©´´½¨±í¿Õ¼ä
create tablespace ts_amly datafile 'd:\amlyfile\test.dbf' size 100M;
£¨4£©½«±í¿Õ¼ä·ÖÅä¸øÓû§
alter user amly default tablespace ts_amly;
£¨5£©¸øÓû§ÊÚȨ
grant create sess ......

¹ØÓÚORACLE PLSQL¶ÁÎļþ

ת×Ô£ºhttp://www.oracle.com/technology/obe/obe9ir2/obe-cnt/plsql/plsql.htm
¶¼Ëµ¶ÁÊé²»ÇóÉõ½âº¦ËÀÈË£¬Ò»µãÒ²²»´í£¬×î½üÎÒ´ÓÍøÉÏÌÔµ½¹ØÓÚORACLEÈçºÎ´ÓÊý¾Ý¿âĿ¼Ï¶ÁÎļþ£¬ÓÚÊǾÍÓÃÓÚÉú²úÁË£¬½á¹ûÉÏÁËÉú²ú£¬³ÌÐòËÀ»î¾ÍÊÇÅܲ»³öÀ´£¬Ô­ÒòÊÇÎÒÃǵķþÎñÆ÷×öÁËREC£¬Èç¹ûÔÚÁ½Ì¨»úÆ÷ÉÏÕÒÒ»¸öĿ¼ÄØ£¬ÒÔÇ°ÄØÔÚ×Ô¼ºµÄ³ÌÐòÀï°Ñ·¾ ......

Oracle¿ØÖÆÎļþ³£ÓòÙ×÷

ÏÞÖÆ¿ØÖÆÎļþµÄ´óС
a.)²éѯ¿É¸´Óò¿·ÖµÄ±£´æÌìÊý(²»ÄÜÖ±½Ó¿ØÖÆ´óС,±£´æÌìÊýÔ½´óÊý¾ÝÔ½¶à)
SELECT name,value from v$parameter WHERE name = 'control_file_record_keep_time';

b.)ÉèÖÿɸ´Óò¿·Ö±£´æʱ¼ä
ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME = 14;
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ