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»á¸ù¾ÝÕâЩͳ¼ÆÐÅÏ¢À´¾ö¶¨ÊÇ×ßRBO(Rule-BasedOptimization)£¬»¹ÊÇ×ßCBO(Cost-BasedOptimization)£¬»áȥѡÔñÄÄÖÖÖ´Ðмƻ®¸ü»®Ëã,Ó°ÏìÊÇ·ñ×ßÏà¹ØµÄË÷ÒýµÈ.Èç¹ûÊÇCBOµÄ»°£¬ËüÒÀ¿¿×¼È·µÄ£¨»òÕß˵±È½Ï׼ȷµÄ£©Í³¼ÆÐÅÏ¢À´²úÉúÓÅ»¯µÄÖ´Ðз¾¶,Èç¹ûûÓÐ×ö¹ýͳ¼Æ£¬CBOÒ²¾ÍûÓÐ×öcostÆÀ¹ÀµÄÒÀ¾Ý ......
Ïȹ¹ÔìÒ»¸ö±í:
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³öÏÖÎÊÌ⣬¿ª»úʱÀÏÊDZ¨“agntsrvc.exe³ö´í”£¬¾¹ýËÑË÷·¢ÏÖÊÇÏÂÁÐÎÊÌ⣺
1.agntsrvc.exeÊÇOracle Intelligent Agent·þÎñ¶ÔÓ¦µÄ³ÌÐò¡£
2.Òò´Ë·þÎñÊÇ×Ô¶¯Æô¶¯µÄ£¬ËùÒÔÒ»°ã¶àÔÚµçÄÔÆô¶¯Ê±µ¯³öϵͳ´íÎó¡£
3.ÎÊÌâ´¦Àí£º£¨±¾±¸·ÝÑø³ÉÏ°¹ßŶ£©
¡¡É¾³ýÁË %ORACLE_HOME%/ora ......
oracle ÖУ¬¶ÔÓÚÒ»¸öÌá½»µÄsqlÓï¾ä,´æÔÚÁ½ÖÖ¿ÉÑ¡µÄ½âÎö¹ý³Ì, Ò»ÖÖ½Ð×öÓ²½âÎö,Ò»ÖÖ½Ð×öÈí½âÎö.
Ò»¸öÓ²½âÎöÐèÒª¾½âÎö,Öƶ¨Ö´Ðз¾¶,ÓÅ»¯·ÃÎʼƻ®µÈÐí¶àµÄ²½Öè.Ó²½âÊͲ»½ö½öºÄ·Ñ´óÁ¿µÄcpu£¬¸üÖØÒªµÄÊÇ»áÕ¼¾ÝÖØÒªµÄÃÇãÅ£¨latch£©×ÊÔ´£¬ÑÏÖصÄÓ°ÏìϵͳµÄ¹æÄ£µÄÀ©´ó£¨¼´ÏÞÖÆÁËϵͳµÄ²¢·¢ÐУ©£¬ ¶øÇÒÒýÆðµÄÎÊÌâ ......
¡¾IT168¼¼ÊõÎĵµ¡¿
DATA GUARDµÄ×îÖ÷ÒªµÄ¹¦ÄÜÊÇÈßÔÖ¡£µ±È»¸ù¾ÝÅäÖõIJ»Í¬£¬DATA GUARD»¹¿ÉÒԾ߱¸ÒÔÏÂÌص㣺¸ß¿ÉÓá¢ÐÔÄÜÌáÉý¡¢Êý¾Ý±£»¤ÒÔ¼°¹ÊÕϻָ´µÈ¡£
DATA GUARD¿ÉÒÔ·ÖΪÎïÀíSTANDBYºÍÂß¼STANDBYÁ½ÖÖ¡£¶þÕßµÄ×î´ó²î±ðÔÚÓÚ£¬ÎïÀíSTANDBYÓ¦ÓõÄÊÇÖ÷¿âµÄ¹éµµÈÕÖ¾£¬¶ø ......