Oracleѧϰ±Ê¼Çժ¼9

   a)Êý¾Ý¿â±¾ÉíµÄÓÅ»¯
       ³õʼ»¯Îļþ init.ora
         open_cursors = 150 ´ò¿ªµÄÓαêµÄ¸öÊý
            ºÜ¶àµÄ´æ´¢¹ý³ÌµÄʱºò ¿ÉÒÔ°ÑËüµ÷´óЩ
         processes = 150  ²¢·¢Á¬½ÓµÄÓû§Êý
            ͬʱÔÚÏßµÄÓû§ºÜ¶à ¿ÉÒÔ°ÑËüµ÷´ó processes = (ÔÚÏßÓû§Êý)/2
   b)Ó¦ÓóÌÐòµÄÓÅ»¯ ********
<1>ÐòÁеÄʹÓÃ
 ×Ô¶¯±àºÅ
 a) ×î´óºÅ+1(´æÔÚȱÏݵÄ,²»ÄÜÓÃ,²¢·¢µÄʱºò³öÏÖËæ»úµÄ´íÎó)
     create or replace function f_getmax
     return number
     as
      maxno number;
      newmax number;
     begin
     --È¡³ö±íÖеÄ×î´óµÄÔ±¹¤ºÅ
         select max(empno) into maxno from
         emp ;
     --ÈÃÕâ¸öÖµ+1ºó·µ»Ø
         return (maxno +1);
     end;
 b)ÐòÁÐ  
  --½¨Á¢ÐòÁÐ
  create sequence seq1 start with 7935;
  --´ÓÐòÁÐÖÐÈ¡³öÔ±¹¤ºÅ
  create or replace function f_getmax
     return number
     as
      maxno number;
     begin
     --È¡³öÐòÁÐÖеÄÖµ
     select seq1.nextval into maxno
     from dual;
     --ÈÃÕâ¸öÖµ·µ»Ø
         return maxno;
     end;
<2> ²¢·¢ -- ¶à¸öÈËÔÚʹÓÃ
   ¼×:update emp
      set sal =1000
      where empno = 7369;
   ÒÒ:update emp
&