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ʵÀýÆô¶¯Ê±¶ÁÈ¡pfile²ÎÊýÎļþ£¬ÐÞ¸Äpfile³õʼ»¯²ÎÊýÎļþºó£¬±ØÐëÖØÐÂÆô¶¯ÊµÀý²ÅÄÜÉúЧ¡£
pfile²ÎÊýÎļþÓëspfile²ÎÊýÎļþ¶¼ÊÇÓÃÀ´´æ·Å³õʼ»¯²ÎÊýµÄÎïÀíÎļþ£¬pfileÒÔÎı¾ÎļþµÄÐÎʽ´æ´¢£¬ÓŵãÊÇÒ×Óڲ鿴ÓëÐ޸ģ»spfileÒÔ¶þ½øÖƵÄÐÎʽ´æ´¢£¬ËäÈ»ÄÜʵÏÖÒÔʵÀ ......
2009-07-16 10:59
Ë÷Òý´´½¨²ßÂÔ
1.µ¼ÈëÊý¾ÝºóÔÙ´´½¨Ë÷Òý
2.²»ÐèҪΪºÜСµÄ±í´´½¨Ë÷Òý
3.¶ÔÓÚÈ¡Öµ·¶Î§ºÜСµÄ×ֶΣ¨±ÈÈçÐÔ±ð×ֶΣ©Ó¦µ±½¨Á¢Î»Í¼Ë÷Òý
4.ÏÞÖƱíÖеÄË÷ÒýµÄÊýÄ¿
5.ΪË÷ÒýÉèÖúÏÊʵÄPCTFREEÖµ
6.´æ´¢Ë÷ÒýµÄ±í¿Õ¼ä×îºÃµ¥¶ÀÉ趨
´´½¨²»Î¨Ò»Ë÷Òý
create index emp_ename on employees(ename)
table ......
¹ØÓÚ´æ´¢¹ý³ÌºÍº¯ÊýµÄ¶¨ÒåÍøÉÏÒ»ËÑÒ»´ó°Ñ£¬ÕâÀï¾Í²»ÌØÊâ½éÉÜÁË£¬ÕâÀï¾ÍÖ»¶ÔÎÒ×Ô¼ºÐ´µÄ¼¸ÖÖ¸ñʽµÄ´æ´¢¹ý³ÌºÍº¯Êý×öһЩ×ܽᣬϣÍû¶Ô´ó¼ÒÓеã°ïÖú¡£
Ò»£º´æ´¢¹ý³Ì
1£º×îÆÕͨµÄÒ»ÖÖ¡££¨´«²Î£¬²éѯÓαִ꣬ÐУ¬Ñ»·Óαê×ö²åÈ붯×÷£©¡£
create or replace procedure zy2040_sirole(rolekey in varchar2) ......
declare
msg varchar(1000); --¶¨ÒåÒ»¸ö±äÁ¿ÓÃÓÚÏÔʾ´«³öµÄÐÅÏ¢
begin
PRO_TACCOUNT_RECOUNT ('B9D2B59A955541298D59EA8C35668CFD',msg); --Ö´Ðд洢¹ý³Ì
dbms_output.put_line(msg); --Êä³ö±äÁ¿
end; ......
ÔÚPL/SQL³ÌÐòÉè¼ÆÖУ¬ÓÐÈýÖÖ¶¨Òå¼Ç¼ÀàÐ͵ķ½·¨£ºÒ»ÖÖÊÇʹÓÃ%ROWTYPEÊôÐÔ£»ÁíÒ»ÖÖÊÇÔÚPL/SQL³ÌÐòµÄÉùÃ÷²¿·ÖÏÔʾ¶¨Òå¼Ç¼ÀàÐÍ£»×îºóÒ»ÖÖ·½·¨Êǽ«¼Ç¼ÀàÐͶ¨ÒåΪÊý¾Ý¿â½á¹¹»ò¶ÔÏóÀàÐÍ¡£
ÎÒÏȼòµ¥µÄ½éÉÜÒ»¸öÏÂÃæÒªÓõ½µÄ±íµÄ½á¹¹£¨ºÚÌå±êÃ÷µÄ×Ö¶ÎΪÖ÷¼ü£©£º
INDIVIDUALS±í
INDIVIDUAL ID
FIRST NAME
MIDDLE_INITI ......