OracleÃæÊÔ¹ý³ÌÖг£¼ûµÄ¶þÊ®¸öÎÊÌâ
QQ:1156316388 Tel:010-51527259
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°üº¬´óÁ¿µÄÖ÷ÒªµÄÐÅÏ¢¶ødime nsion tables ´æ·Å¶Ôfact table ijЩÊôÐÔÃèÊöµÄÐÅÏ¢
10.FACT TableÉÏÐèÒª½¨Á¢ºÎÖÖË÷Òý?
½â´ð:λͼË÷Òý (bitmap index)
11. ¸ø³öÁ½ÖÖÏà¹ØÔ¼Êø?
½â´ð:Ö÷¼üºÍÍâ¼ü
12. ÈçºÎÔÚ²»Ó°Ïì×Ó±íµÄÇ°ÌáÏ£¬Öؽ¨Ò»¸öĸ±í
½â´ð:×Ó±íµÄÍâ¼üÇ¿ÖÆʵЧ£¬Öؽ¨Ä¸±í£¬¼¤»îÍâ¼ü
13. ½âÊ͹鵵ºÍ·Ç¹éµµÄ£Ê½Ö®¼äµÄ²»Í¬ºÍËüÃǸ÷×ÔµÄÓÅȱµã
½â´ð:¹éµµÄ£Ê½ÊÇÖ
Ïà¹ØÎĵµ£º
Ö÷ÒªÊÇͨ¹ýreplaceºÍtranslateÀ´ÊµÏÖ
SQL> create view v_tt
2 as
3 select ename||' '||deptno as data
4 from emp;
View created.
SQL> select * from v_tt;
DATA
---------------------------------------------------
SMITH 20
ALLEN 30
WARD 30
JONES 20
MARTIN 30
BLAKE 30
CLARK 10
......
Ö÷Òª·½·¨ÊÇͨ¹ýʹÓÃCASE±í´ïʽÀ´“±ê¼Ç”Ò»¸öÖµÊÇ·ñΪNULL¡£ÕâÀï±ê¼ÇÓÐÁ½¸öÖµ£¬Ò»¸ö±íʾNULL£¬Ò»¸ö±íʾ·ÇNULL¡£ÕâÑù£¬Ö»ÒªÔÚORDER BY×Ó¾äÖÐÔö¼Ó±ê¼ÇÁУ¬±ã¿ÉÒÔºÜÈÝÒ׵ĿØÖÆ¿ÕÖµÊÇÅÅÔÚÇ°Ã滹ÊÇÅÅÔÚºóÃ棬¶ø²»»á±»¿ÕÖµËù¸ÉÈÅ¡£
SQL> select ename,sal,comm from emp;
ENAME SAL COMM
----- ......
¡¡¡¡±¾ÎĽéÉÜÁËÔÚOracleÊý¾Ý¿âÖУ¬¶ÔÈÕÆÚ¡¢Ê±¼äµÄ¸÷ÖÖ²Ù×÷£¬°üÀ¨£ºÈÕÆÚʱ¼ä¼ä¸ô²Ù×÷¡¢ÈÕÆÚµ½×Ö·û²Ù×÷¡¢×Ö·ûµ½ÈÕÆÚ²Ù×÷¡¢trunk / ROUNDº¯ÊýµÄʹÓᢺÁÃ뼶µÄÊý¾ÝÀàÐ͵ȡ£
1.ÈÕÆÚʱ¼ä¼ä¸ô²Ù×÷
¡¡¡¡µ±Ç°Ê±¼ä¼õÈ¥7·ÖÖÓµÄʱ¼ä
¡¡¡¡select sysdate,sysdate - interval '7' MINUTE from dual
¡¡¡¡µ±Ç°Ê±¼ä¼õÈ¥7СʱµÄʱ¼ä
¡¡¡ ......
radhat 5.2Ï°²×°oracle10g
1¡¢ÏµÍ³ÐèÇó£º
Äڴ棺ÖÁÉÙ512mb£¬ÍƼöÓÃ1g£»
Ó²ÅÌ£º·þÎñÆ÷ÖÁÉÙ60g£»
£¨Ò»°ãÇé¿öÏÂÓ²¼þ¶¼ÄÜ·ûºÏÒªÇó£©
Èí¼þ°ü£ºglibc-2.3.2, libaio-0.3.96
½»»»¿Õ¼ä:
RAM: 0~256MB, SWAP: 3 ±¶ RAM ´óС
RAM: 256~512MB, SWAP: 2 ±¶ RAM ´óС
RAM: >=512MB, SWAP: 10 ......
Ò»°ãÇé¿öÏÂÊǺ¬ÓÐÈ«±íɨÃèµÄsql»áÔì³ÉÈȵã¿é¡£
1¡¢ÕÒµ½×îÈȵÄÊý¾Ý¿éµÄlatchºÍbufferÐÅÏ¢
select b.addr,a.ts#,a.dbarfil,a.dbablk,a.tch,b.gets,b.misses,b.sleeps from
(select * from (select addr,ts#,file#,dbarfil,dbablk,tch,hladdr from x$bh ......