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

ÈçºÎÓ¦¶Ô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. ½âÊ͹鵵ºÍ·Ç¹éµµÄ£Ê½Ö®¼äµÄ²»Í¬ºÍËüÃǸ÷×ÔµÄÓÅȱµã
½â´ð:¹éµµÄ£Ê½ÊÇÖ¸Äã¿ÉÒÔ±¸·ÝËùÓеÄÊý¾Ý¿â transactions²¢»Ö¸´µ½ÈÎÒâÒ»¸öʱ¼äµã¡£·Ç¹éµµÄ£Ê½ÔòÏà·´£¬²»Äָܻ´µ½ÈÎÒâÒ»¸öʱ¼äµã¡£µ«ÊǷǹ鵵ģʽ¿ÉÒÔ´øÀ´Êý¾Ý¿âÐÔÄÜÉϵÄÉÙÐíÌá¸ß.
14. ÈçºÎ½¨Á¢Ò»¸ö±¸·Ý¿ØÖÆÎļþ?
½â´ð:Alter database backup control file to trace.
15. ¸ø³öÊý¾Ý¿âÕý³£Æô¶¯Ëù¾­ÀúµÄ¼¸ÖÖ×´Ì


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

ORACLEÈÏÖ¤Åàѵ³£¼ûÎÊÌâ

ORACLEÈÏÖ¤Åàѵ³£¼ûÎÊÌâ
1¡¢ÎÊ£ºÊ²Ã´ÊÇ Oracle ÈÏÖ¤£¿¶¼ÓÐÄÄЩÖÖÀࣿ                              
¡¡¡¡´ð£ºOracle ÈÏÖ¤ÊÇÓÉOracle¹«Ë¾°ä²¼²¢ÊµÊ©µÄÒ»ÏîÈ¨Í ......

C# Á¬½ÓOracleÊý¾Ý¿â


C#Á¬½ÓOracleÊý¾Ý¿â×Ö·û´®
http://developer.51cto.com
 2009-08-20 17:55  ØýÃû  °Ù¶È¿Õ¼ä  ÎÒÒªÆÀÂÛ(
0
)
C#Á¬½ÓOracleÊý¾Ý¿âÒÔ¼°C#Á¬½ÓOracleÊý¾Ý¿â×Ö·û´®µÈÄÚÈݽ«ÔÚ±¾ÎÄÖÐÕ¹ÏÖ£¬Ï£Íû±¾ÎÄÄܶԴó¼ÒÁ˽âC#Á¬½ÓÊý¾Ý¿âÓÐËù°ïÖú¡£
C#Á¬½ÓOracleÊý¾Ý¿â×Ö·û´®£¨²éѯÊý¾Ý£©
using
 Syst ......

Oracle 10G Êý¾Ý±Ãѧϰ¼ÍÒª£¨expdp/impdp£©

ʵÀý£º
    1¡¢Í¨¹ýDBLINKµÄ·½Ê½£º±í¿Õ¼ä²»Ò»Ñù
impdp logfile=DUP_MCMDB.LOG network_link=to_crm_7 schemas=MCMDB  REMAP_TABLESPACE=table_space11:table_space12,table_space21:table_space22
    2¡¢Í¨¹ýDBLINKµÄ·½Ê½£º·½°¸£¨schemas£©²»Ò»Ñù
impdp logfile=DUP_MCMDB.LOG net ......

oracleÔÚHp unixÉϵÄ×Ô¶¯Æô¶¯

http://space.itpub.net/9134/viewspace-166486
¾­³£ÓÐÈË»áÐèÒªOracleÊý¾Ý¿âËæ×ŲÙ×÷ϵͳһÆðÆô¶¯ºÍ¹Ø±Õ£¬¶øÐÞ¸Ä/etc/oratab,ÉèÖÃÁËoracle SIDÐÐÆô¶¯ÎªYʱʵ¼ÊÉÏÊDz»ºÃÓõġ£±¾ÎÄÒÔÒ»¸öÀý×ÓÀ´Ê¾·¶ÈçºÎÈ¥×ö¡£
ÈçϸøµÄÊÇÒ»¸öexample£¬×¢Òⲿ·ÖÄÚÈÝ¿ÉÄÜÒª¸Ä£¬±ÈÈçoracleµÄÓû§Ãû¡£
1¡¢ÔÚ/sbin/init.d/Ŀ¼Ï½¨Á¢Ò»¸öÎļþ£¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ