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

OracleÊý¾Ý¿âÃæÊÔÎÊÌ⼯ºÏ¼°¼¼ÇÉ

 
ÕâƪÎÄÕÂÊÇORACLEÃæÊÔµÄÎÊÌâ½õ¼¯£¬ËäÈ»²»È«Ã棬µ«ÊÇÕâƪÎÄÕ»áÈÃÄãÖªµÀÈçºÎÈÃÃæÊÔ¿¼¹ÙÁ˽âÄã¶ÔORACLE¸ÅÄîµÄÊìϤ³Ì¶È¡£
 
1.½âÊÍÀ䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
 
½â´ð£ºÈȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐģʽµÄÊý¾Ý¿â¡£Èȱ¸·ÝµÄÓŵãÔÚÓÚµ±±¸·Ýʱ£¬Êý¾Ý¿âÈԾɿÉÒÔ±»Ê¹Óò¢ÇÒ¿ÉÒÔ½«Êý¾Ý¿â»Ö¸´µ½ÈÎÒâÒ»¸öʱ¼äµã¡£À䱸·ÝµÄÓŵãÔÚÓÚËüµÄ±¸·ÝºÍ»Ö¸´²Ù×÷Ï൱¼òµ¥£¬²¢ÇÒÓÉÓÚÀ䱸·ÝµÄÊý¾Ý¿â¿ÉÒÔ¹¤×÷Ôڷǹ鵵ģʽÏÂ,Êý¾Ý¿âÐÔÄÜ»á±È¹éµµÄ£Ê½ÉԺᣣ¨ÒòΪ²»±Ø½«archive logдÈëÓ²ÅÌ£©
 
2.Äã±ØÐëÀûÓñ¸·Ý»Ö¸´Êý¾Ý¿â£¬µ«ÊÇÄãûÓпØÖÆÎļþ£¬¸ÃÈçºÎ½â¾öÎÊÌâÄØ£¿
 
½â´ð£ºÖؽ¨¿ØÖÆÎļþ£¬Óôøbackup control file ×Ó¾äµÄrecover ÃüÁî»Ö¸´Êý¾Ý¿â¡£
 
3.ÈçºÎת»»init.oraµ½spfile?
 
½â´ð£ºÊ¹ÓÃcreate spfile from pfile ÃüÁî.
 
4.½âÊÍdata block , extent ºÍ segmentµÄÇø±ð£¨ÕâÀィÒéÓÃÓ¢ÎÄÊõÓ
 
½â´ð£ºdata blockÊÇÊý¾Ý¿âÖÐ×îСµÄÂß¼­´æ´¢µ¥Ôª¡£µ±Êý¾Ý¿âµÄ¶ÔÏóÐèÒª¸ü¶àµÄÎïÀí´æ´¢¿Õ¼äʱ£¬Á¬ÐøµÄdata block¾Í×é³ÉÁËextent . Ò»¸öÊý¾Ý¿â¶ÔÏóÓµÓеÄËùÓÐextents±»³ÆΪ¸Ã¶ÔÏóµÄsegment.
 
5.¸ø³öÁ½¸ö¼ì²é±í½á¹¹µÄ·½·¨
 
½â´ð£º1.DESCRIBEÃüÁî
 
2.DBMS_METADATA.GET_DDL °ü
 
6.ÔõÑù²é¿´Êý¾Ý¿âÒýÇæµÄ±¨´í
 
½â´ð£ºalert log.
 
7.±È½ÏtruncateºÍdelete ÃüÁî
 
½â´ð£ºÁ½Õ߶¼¿ÉÒÔÓÃÀ´É¾³ý±íÖÐËùÓеļǼ¡£Çø±ðÔÚÓÚ£ºtruncateÊÇDDL²Ù×÷£¬ËüÒƶ¯HWK£¬²»ÐèÒªrollback segment .¶øDeleteÊÇDML²Ù×÷, ÐèÒªrollback segment ÇÒ»¨·Ñ½Ï³¤Ê±¼ä.
 
8.ʹÓÃË÷ÒýµÄÀíÓÉ
 
½â´ð£º¿ìËÙ·ÃÎʱíÖеÄdata block
 
9.¸ø³öÔÚSTAR SCHEMAÖеÄÁ½ÖÖ±í¼°ËüÃÇ·Ö±ðº¬ÓеÄÊý¾Ý
 
½â´ð£ºFact tables ºÍdimension tables. fact table°üº¬´óÁ¿µÄÖ÷ÒªµÄÐÅÏ¢¶ødimension tables ´æ·Å¶Ôfact table ijЩÊôÐÔÃèÊöµÄÐÅÏ¢
 
10.FACT TableÉÏÐèÒª½¨Á¢ºÎÖÖË÷Òý£¿
 
½â´ð£ºÎ»Í¼Ë÷Òý £¨bitmap index£©
 
11. ¸ø³öÁ½ÖÖÏà¹ØÔ¼Êø?
 
½â´ð£ºÖ÷¼üºÍÍâ¼ü
 
12. ÈçºÎÔÚ²»Ó°Ïì×Ó±íµÄÇ°ÌáÏ£¬Öؽ¨Ò»¸öĸ±í
 
½â´ð£º×Ó±íµÄÍâ¼üÇ¿ÖÆʵЧ£¬Öؽ¨Ä¸±í£¬¼¤»îÍâ¼ü
 
13. ½âÊ͹鵵ºÍ·Ç¹éµµÄ£Ê½Ö®¼äµÄ²»Í¬ºÍËüÃǸ÷×ÔµÄÓÅȱµã
 
½â´ð£º


Ïà¹ØÎĵµ£º

oracle £º´æ´¢¹ý³ÌºÍº¯ÊýµÄ¼¸ÖÖд·¨

¹ØÓÚ´æ´¢¹ý³ÌºÍº¯ÊýµÄ¶¨ÒåÍøÉÏÒ»ËÑÒ»´ó°Ñ£¬ÕâÀï¾Í²»ÌØÊâ½éÉÜÁË£¬ÕâÀï¾ÍÖ»¶ÔÎÒ×Ô¼ºÐ´µÄ¼¸ÖÖ¸ñʽµÄ´æ´¢¹ý³ÌºÍº¯Êý×öһЩ×ܽᣬϣÍû¶Ô´ó¼ÒÓеã°ïÖú¡£
 Ò»£º´æ´¢¹ý³Ì
  
1£º×îÆÕͨµÄÒ»ÖÖ¡££¨´«²Î£¬²éѯÓαִ꣬ÐУ¬Ñ­»·Óαê×ö²åÈ붯×÷£©¡£
create or replace procedure zy2040_sirole(rolekey in varchar2) ......

Oracle MTS

¡¡¡¡Ò»¡¢Ê²Ã´ÊÇMTS
¡¡¡¡MTS = Multi-Threaded ServerMTSÊÇORACLE SERVERµÄÒ»¸ö¿ÉÑ¡µÄÅäÖÃÑ¡Ôñ£¬ÊÇÏà¶ÔDEDICATE·½Ê½¶øÑÔ£¬Ëü×î´óµÄÓŵãÊÇÔÚÒÔ²»ÓÃÔö¼ÓÎïÀí×ÊÔ´(ÄÚ´æ)µÄÇ°ÌáÏÂÖ§³Ö¸ü¶àµÄ²¢·¢µÄÁ¬½Ó¡£Joseph C.JohnsonÒԲ͹ݸø³öÒ»¸öMTSµÄÐÎÏóµÄ±ÈÓ÷
¡¡¡¡¼ÙÉèORACLEÊÇÒ»¼Ò²Í¹Ý£¬µ±Äã×ß½øÒ»¼Ò²Í¹ÝʱÄã¸Ð¾õ×îÊæ·þµÄ·þÎñ·½Ê½¾ÍÊ ......

oracle 10.2g ÔÚCentOS 5.1µÄ°²×°¹ý³Ì

µÚÒ»²½¡¢¼ì²é²Ù×÷ϵͳ»·¾³
rpm -q gcc make binutils openmotif glibc setarch compat-db compat-gcc-34 openmotif compat-gcc-34-c++ compat-libstdc++-33
Èç¹û¼ì²âµ½Äĸö°üûÓÐ×°£¬Ôò·Ö±ðÔÚISO¾µÏñÎļþÖÐÕÒµ½½øÐа²×°
¹ÒÔØ6ÕÅ»ò7ÕÅISOÎļþ£¬
±ÈÈç˵£ºrpm -ivh /mnt/iso/3/CentOS/openmotif*
Ö»ÒªÊÇûÓÐ×°µÄ¶¼Òª½øÐа ......

ORACLE PL/SQL ¼Ç¼(Record)ѧϰ±Ê¼Ç(¶þ)

¶þ¡¢ÒÔÐβεÄÐÎʽ¶¨ÒåºÍʹÓüǼ¡¢¶ÔÏóÀàÐÍ
ÔÚÓÃ×÷ÐÎʽ²ÎÊýʱ£¬¼Ç¼ÀàÐͺͶÔÏóÀàÐÍÓкܶàÏà֮ͬ´¦¡£ÔÚ½«ËüÃÇ×÷ΪÓαꡢº¯Êý»ò¹ý³ÌµÄÐÎʽ²ÎÊýÒÔÇ°£¬ÊÂÏȶ¼±ØÐ붨ÒåÒ»¸ö¼Ç¼ÀàÐÍ»òÕ߶ÔÏóÀàÐÍ¡£
ÈçÏÂÀýËùʾ£º
 
¼Ç¼
DECLARE

-- Define a record type.
TYPE individual_record IS RECORD
(individual_id ......

ORACLE PL/SQL ¼¯ºÏѧϰ±Ê¼Ç(¶þ)

Èý¡¢Ç¶Ì×±íµÄʹÓ÷½·¨
 
1¡¢½«Ç¶Ì×±í¶¨ÒåΪPL/SQLµÄ³ÌÐò¹¹Ôì¿é
 
TYPE type_name IS TABLE OF element_type[NOT NULL];
 
ÈçÏÂÀýËùʾ£º
DECLARE

-- Define a nested table of variable length strings.
TYPE card_table IS TABLE OF VARCHAR2(5 CHAR);

-- Declare and initialize a n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ