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

ORACLE Ä£Äâ java SPLIT

CREATE OR REPLACE FUNCTION F_HPS_SPLIT
/*
 * ¹¦    ÄÜ: split.
 * ÊäÈë²ÎÊý: Liststr  string
 * ÊäÈë²ÎÊý: Sepe     index
 * ÊäÈë²ÎÊý: Sepe     separator. default is ','.
 * return sepeCount
 */
(
  Liststr in varchar2,
  inde    in number,
  Sepe    in varchar2 := ','
) return varchar2 is
  -- È¥µôǰºó·Ö¸ô·ûºóµÄ×Ö·û´®
  Str       varchar2(4000);
  -- Òª·µ»ØµÄ×Ö·û´®
  retStr    varchar2(100);
  -- ·Ö¸ô·û¸öÊý
  sepeCount number(4);
begin
  -- È¥µôǰºóµÄ·Ö¸ô·û;
  Str       := TRIM(BOTH Sepe from Liststr);
  sepeCount := f_hps_getsepcount(Liststr, Sepe);
  IF sepeCount = 0 THEN
     return Liststr;
  END IF;
  IF inde > sepeCount THEN
    retStr := '0';
  ELSIF inde = sepeCount THEN
    retStr := Substr(str, Instr(str, Sepe, 1, inde) + 1, length(Str));
  ELSIF inde = 0 THEN
    retStr := Substr(str, 1, Instr(str, Sepe, 1, 1) - 1);
  ELSE
    str    := SubStr(Str, Instr(str, Sepe, 1, inde) + 1, length(str));
    retStr := Substr(str, 1, Instr(str, Sepe, 1, 1) - 1);
  END IF;
  return retStr;
end;


Ïà¹ØÎĵµ£º

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
    Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ ......

¶à¸öoracleÊý¾Ý¿âÖ®¼äÊý¾Ý¹²Ïí database link

ÒòΪ¹«Ë¾µÄÕÆÉϳÇÊÐϵͳÔÚ¶à¸öµØÊÆÍ¬Ê±ÉÏÏߣ¬¶øÎªÁËÈÃÿ¸ö³ÇÊеÄ3G¿ìѶ¾ßÓеØÊÆÌØÉ«ÐÔ£¬Ã¿¸öµØÊÆÓÐ×Ô¼ºµ¥¶ÀµÄÊý¾Ý¿âϵͳ£¬¶øÃ¿¸öµØÊƵĿìѶÓÖһЩ¹²Í¬µÄ£¬Æ©ÈçͻȻ³öÁËÒ»Ìõ¹ú¼ÊÐÂÎÅ£¬ÄÇôÊDz»ÊÇÿ¸öµØÊƵĺǫ́±à¼­¶¼ÒªÂ¼ÈëÒ»±é£¬ÕâÑùÎÞÒÉÊÇ×öÁËÐí¶àÎÞÓù¦£¬ËùÒÔ¹«Ë¾¿¼ÂǼÜÉèÒ»¸ö×ÜÕ¾£¬×ÜÕ¾ÉÏÓÐרÃŵÄÈ˸ºÔð£¬Ã¿Ì츺Ôð¼ÈëÒ» ......

oracle·þÎñÓ²¼þÉý¼¶ µ÷Õû²ÎÊý

author£ºskate
time£º2010-05-13
1)If memory increases and you're 64-bit,  e.g  8G to 16G,  Oracle SGA and related parameters need adjust; So are some the Unix kernel parameters.
2)As for CPU related configuration,  some  parameters, based on CPU_co ......

ORACLEÌåϵ½á¹¹ ʵÀý

ORACLEʵÀýÓÐϵͳȫ¾ÖÇø£¨SGA£©ºÍһЩºǫ́½ø³Ì×é³É.
ϵͳȫ¾ÖÇø£¨SGA£©Óй²Ïí³Ø£¨shared pool£©,Êý¾Ý¿â¸ßËÙ»º³åÇø£¨database buffer cache£©,ÖØ×öÈÕÖ¾»º³åÇø£¨redo log buffer£©.¹²Ïí³ØÓÖÓпâ¸ßËÙ»º´æ£¨library cache£©ºÍÊý¾Ý×Öµä¸ßËÙ»º´æ£¨dictionary cache£©×é³É¡£
ORACLE ʵÀý5¸ö±ØÐèµÄºǫ́½ø³Ì£ºSMON,PMON,DBWR,LGWR, ......

oracle Êý¾ÝÀàÐÍÏê½â ÈÕÆÚÐÍ

oracle Êý¾ÝÀàÐÍÏê½â---ÈÕÆÚÐÍ
      oracleÊý¾ÝÀàÐÍ¿´ÆðÀ´·Ç³£¼òµ¥£¬µ«ÓÃÆðÀ´»á·¢ÏÖÓÐÐí¶à֪ʶµã£¬±¾ÎÄÊÇÎÒ¶ÔORACLEÈÕÆÚÊý¾ÝÀàÐ͵ÄһЩÕûÀí£¬¶¼ÊÇ¿ª·¢ÈëÃÅ×ÊÁÏ£¬Óë´ó¼Ò·ÖÏí£º
×¢£ºÓÉÓÚINTERVAL¼°TIME ZONEʵ¼ÊÓõñȽÏÉÙ£¬ËùÒÔ±¾ÎÄÄÚÈÝÎ´Éæ¼°ÕâÁ½¸ö·½Ãæ¡£
1¡¢³£ÓÃÈÕÆÚÐÍÊý¾ÝÀàÐÍ
1.1¡¢DATE
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ