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

OracleÓû§¹ÜÀí

 Ò»£¬OracleÊý¾Ý¿âÓû§¼ò½é
 ÔÚOracleÊý¾Ý¿âÖÐÈκζÔÏó¶¼ÊôÓÚÒ»¸öÌض¨Óû§£¬»òÕß˵һ¸öÓû§ÓëͬÃûµÄģʽÏà¹ØÁª¡£
 ÒªÁ¬½Óµ½OracleÊý¾Ý¿âÐèÒªÒ»¸öÓû§ÕÊ»§£¬¸ù¾ÝÐèÒªÊÚÓèµÄ²Ù×÷ȨÏÞ¡£
 1£¬Ä¬ÈÏÊý¾Ý¿âÓû§Ä£Ê½£º
  Sys:Êý¾Ý¿â×ֵ䣨´æ´¢±»¹ÜÀí¶ÔÏóËùÓÐÐÅÏ¢£©ºÍÊÓͼ´æ´¢ÔÚ¸ÃģʽÖС£ÏµÍ³¼¶Óû§¡£
  System:ĬÈÏϵͳ¹ÜÀíÔ±£¨DBAȨÏÞ£©Óû§¡£ÏµÍ³¼¶Óû§¡£
  Scott:Êý¾Ý¿âʾ·¶Óû§£¬Ä¬ÈÏ¿ÚÁîtiger¡£²»Í¬°æ±¾²»Í¬¡£
 
 2£¬Ê²Ã´ÊÇȨÏÞ£¿
  ¹ÜÀíÓû§¶ÔÊý¾Ý¿â¶¨Ò壨DDL£©ºÍ·ÃÎÊÊý¾Ý¿â£¨DML£©µÄ²Ù×÷¡£
  ¢ÙϵͳȨÏÞ£º¹ÜÀíÊý¾Ý¿â²Ù×÷DDL£¬½øÐÐϵͳ¼¶»î¶¯µÄÄÜÁ¦¡£
  ¢Ú¶ÔÏóȨÏÞ£º¹ÜÀí¶ÔÏó½øÐвÙ×÷DML¡£
 
 3£¬Ê²Ã´ÊǽÇÉ«£¿
  ¢Ù¹ÜÀíÓû§¶ÔÊý¾Ý¿â½øÐв»Í¬¼¶±ðµÄ·ÃÎÊ¡£
  ¢Ú½ÇÉ«ÊÇÒ»×éȨÏ޵ļ¯ºÏ£¬½«½ÇÉ«¸³¸øÒ»¸öÓû§£¬Õâ¸öÓû§¾ÍÓµÓÐÁËÕâ¸ö½ÇÉ«ÖеÄËùÓÐȨÏÞ¡£
   Ö»ÒªµÚÒ»´Î½«½ÇÉ«¸³¸øÕâÒ»×éÓû§£¬½ÓÏÂÀ´¾ÍÖ»ÒªÕë¶Ô½ÇÉ«½øÐйÜÀí¾Í¿ÉÒÔÁË¡£
¶þ£¬Óû§Óë±í¿Õ¼äµÄ¹Øϵ
 1£¬Ã¿¸öÓû§¶¼ÓÐÒ»¸öĬÈϱí¿Õ¼ä£¨Ä¬ÈÏΪSystem£©ºÍÒ»¸öÁÙʱ±í¿Õ¼ä£¨Ä¬ÈÏΪTemp£©;
 2£¬±í¿Õ¼ä×÷ÓÃ;
  ¢Ù.¾ö¶¨Êý¾Ý¿âʵÌåµÄ¿Õ¼ä·ÖÅä;
  ¢Ú.ÉèÖÃÊý¾Ý¿âÓû§µÄ¿Õ¼ä·Ý¶î;
  ¢Û.¿ØÖÆÊý¾Ý¿â²¿·ÖÊý¾ÝµÄ¿ÉÓÃÐÔ;
  ¢Ü.·Ö²¼Êý¾ÝÓÚ²»Í¬µÄÉ豸֮¼äÒÔ¸ÄÉÆÐÔÄÜ;
 
 3£¬´´½¨±í¿Õ¼ä(TableSpace)
  Óï·¨¸ñʽ:
  CREATE  TABLESPACE  ±í¿Õ¼äÃû
  DATAFILE Îļþ±êʶ·û [,Îļþ±êʶ·û]
  [SIZEÕûÊý  [K\M]  ]
  [AUTOEXTEND] [ON | OFF]
  ;
  ÆäÖÐ:Îļþ±êʶ·û=’ÎļþÃû’
 
  Àý×Ó£º
   Create TableSpace ts5_11
   DataFile ‘E:\OracleTableSpace\05_11\ts1.DBF’, ‘E:\OracleTableSpace\05_11\ts2.DBF'
   Size 10M;
  
 4£¬Ð޸ıí¿Õ¼äÅäÖÃ
  Óï·¨¸ñʽ:
  ALTER TABLESPCE ±í¿Õ¼äÃû
  (ADD DATAFILE Îļþ±êʶ·û[,Îļþ±êʶ·û]
  | RENAME DATAFILE ’ÎļþÃû’[,’ÎļþÃû’]
  TO ’ÎļþÃû’[,’ÎļþÃû’]
  );
 
Èý£¬Óû§µÄ´´½¨ºÍ¹ÜÀí 
 1£¬´´½¨Êý¾Ý¿âÓû§£¨User£©
  Óï·¨¸ñʽ:


Ïà¹ØÎĵµ£º

Oracle 10g StatisticÊý¾Ýͳ¼Æ


Oracle 10g statisticÊý¾Ýͳ¼Æ,Oracle»á¸ù¾ÝÕâЩͳ¼ÆÐÅÏ¢À´¾ö¶¨ÊÇ×ßRBO(Rule-BasedOptimization)£¬»¹ÊÇ×ßCBO(Cost-BasedOptimization)£¬»áȥѡÔñÄÄÖÖÖ´Ðмƻ®¸ü»®Ëã,Ó°ÏìÊÇ·ñ×ßÏà¹ØµÄË÷ÒýµÈ.Èç¹ûÊÇCBOµÄ»°£¬ËüÒÀ¿¿×¼È·µÄ£¨»òÕß˵±È½Ï׼ȷµÄ£©Í³¼ÆÐÅÏ¢À´²úÉúÓÅ»¯µÄÖ´Ðз¾¶,Èç¹ûûÓÐ×ö¹ýͳ¼Æ£¬CBOÒ²¾ÍûÓÐ×öcostÆÀ¹ÀµÄÒÀ¾Ý ......

Oracle Óï¾ä¼¶´¥·¢Æ÷

Ïȹ¹ÔìÒ»¸ö±í:
create table emp2(
id number(2),
name varchar(10),
currdate date,
action varchar2(1)
)
´´½¨´¥·¢Æ÷£º
create or replace trigger d_i_u_emp2
after insert or update or delete on mysort
begin
if inserting then
insert into emp2 values (12,'dog',sysdate,'i');
elsif deleting then ......

¿ª»úʱOracle agntsrvc.exe±¨ÄÚ´æ³ö´í

ÎҵĻúÆ÷¸ÄÁ˼ÆËã»úÃû³Æ£¬ÔÙ¿ª»úʱ£¬oracle³öÏÖÎÊÌ⣬¿ª»úʱÀÏÊDZ¨“agntsrvc.exe³ö´í”£¬¾­¹ýËÑË÷·¢ÏÖÊÇÏÂÁÐÎÊÌ⣺
1.agntsrvc.exeÊÇOracle Intelligent Agent·þÎñ¶ÔÓ¦µÄ³ÌÐò¡£
2.Òò´Ë·þÎñÊÇ×Ô¶¯Æô¶¯µÄ£¬ËùÒÔÒ»°ã¶àÔÚµçÄÔÆô¶¯Ê±µ¯³öϵͳ´íÎó¡£
3.ÎÊÌâ´¦Àí£º£¨±¾±¸·ÝÑø³ÉÏ°¹ßŶ£©
¡¡É¾³ýÁË %ORACLE_HOME%/ora ......

Oracle °ó¶¨±äÁ¿


oracle ÖУ¬¶ÔÓÚÒ»¸öÌá½»µÄsqlÓï¾ä,´æÔÚÁ½ÖÖ¿ÉÑ¡µÄ½âÎö¹ý³Ì, Ò»ÖÖ½Ð×öÓ²½âÎö,Ò»ÖÖ½Ð×öÈí½âÎö.
Ò»¸öÓ²½âÎöÐèÒª¾­½âÎö,Öƶ¨Ö´Ðз¾¶,ÓÅ»¯·ÃÎʼƻ®µÈÐí¶àµÄ²½Öè.Ó²½âÊͲ»½ö½öºÄ·Ñ´óÁ¿µÄcpu£¬¸üÖØÒªµÄÊÇ»áÕ¼¾ÝÖØÒªµÄÃÇãÅ£¨latch£©×ÊÔ´£¬ÑÏÖصÄÓ°ÏìϵͳµÄ¹æÄ£µÄÀ©´ó£¨¼´ÏÞÖÆÁËϵͳµÄ²¢·¢ÐУ©£¬ ¶øÇÒÒýÆðµÄÎÊÌâ ......

½éÉÜORACLE DATA GUARD

¡¾IT168¼¼ÊõÎĵµ¡¿
     DATA GUARDµÄ×îÖ÷ÒªµÄ¹¦ÄÜÊÇÈßÔÖ¡£µ±È»¸ù¾ÝÅäÖõIJ»Í¬£¬DATA GUARD»¹¿ÉÒԾ߱¸ÒÔÏÂÌص㣺¸ß¿ÉÓá¢ÐÔÄÜÌáÉý¡¢Êý¾Ý±£»¤ÒÔ¼°¹ÊÕϻָ´µÈ¡£
    DATA GUARD¿ÉÒÔ·ÖΪÎïÀíSTANDBYºÍÂß¼­STANDBYÁ½ÖÖ¡£¶þÕßµÄ×î´ó²î±ðÔÚÓÚ£¬ÎïÀíSTANDBYÓ¦ÓõÄÊÇÖ÷¿âµÄ¹éµµÈÕÖ¾£¬¶ø ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ