1.无参数create or replace procedure insertTbisbegininsert into tb values('hongda',10);commit;endcall insertTb();2.有参数create or replace procedure insertTb2(country in varchar2 ,people in number)isbegininsert into tb values(country,people);commit;end insertTb2; call insertTb...【阅读全文】
通常,如果缓存的命中率太低可以增大缓存的大小和避免你的应用程序执行全表扫描.To increase cache size, first set the DB_CACHE_ADVICE initialization parameter toON, and let the cache statistics stabilize. Examine the advisory data in theV$DB_CACHE_ADVICE view to determine the next increm...【阅读全文】
However, increasing the cache size to 334MB would potentially decrease reads by a factor of .93 or 7%. If an additional 30MB memory is available on the host system and theSGA_MAX_SIZE setting allows the increment, it would be advisable to increase the default buffer cache pool size to 334MB.但是,...【阅读全文】
To interpret the buffer cache hit ratio,you should consider the following:解释缓存的命中率,你应该解释如下:Repeated scanning of the same large tableor index can artificially inflate a poor cache hit ratio. Examine frequentlyexecuted SQL statements with a large number of b...【阅读全文】
create or replace procedure sp_pro6(spname char) is --创建一个过程附带一个输入形参v_price goods.unitprice%type;--变量类型begin--执行部分select unitprice into v_price from goods where goodsname=spname;if v_price<5 then--条件语句update goods set unitprice=unitprice*1.1 where goodsname=spname;end if;end;
exec sp_pro【阅读全文】