ITPub博客

share pool的调整主要在2个方面,library cache和dictionary cache的调整，调整需要先确定调整的关键目标指标，主要通过以上两个内容的视图（v$librarycache）或计算而来。library cache和dictionary cache不能单独进行调整，主要是调整share pool大小，减少分析时间。[@more@]SQL> desc v$librarycacheName---------------------------NAMESPACEGETS GETHITSGETHITRATIOPINSPINHITSPINHITRATIORELOADSINVALIDATIONSDLM_LOCK_REQUESTSDLM_PIN_REQUESTSDLM_PIN_RELEASESDLM_INVALIDATION_REQUESTSDLM_INVALIDATIONS1、share pool8i:一般不

-------------------------------------------------------------------------------------------------- 功 能：自动按系统当前的挂号安排产生挂号单，以方便护士练习分诊和医生接诊------------------------------------------------------------------------------------------------[@more@]CREATE OR REPLACE Procedure zl1_UserJobAutoRegist As-------------------------------------------------------------------------------------------------- 功 能：自动按系统当前的挂号安排产生挂号单，以方便护士练习分诊和医生接诊----

Oracle9iR2: Tables can be partitioned into up to 64,000 separate partitions. Oracle10gR2： Tables can be partitioned into up to 1024K-1 separate partitions. ■ Tables greater than 2GB should always be considered for partitioning. ■ Tables containing historical data, in which new data is added into the newest partition. A typical example is a historical table where only the current month's data is updatable and the other 11 months are read only.[@more@]The end.

　　-- Create table(创建分区表) 　　create table BILL_MONTHFEE_ZERO 　　( 　　SERV_ID　　　　　　 NUMBER(20) not null, 　　BILLING_CYCLE_MONTH NUMBER(6) not null, 　　DATE_TYPE　　　　　 NUMBER(1), 　　ACC_NBR　　　　　　 VARCHAR2(80) 　　) 　　partition by range (BILLING_CYCLE_MONTH) 　　(partition p_200407 values less than (200407) 　　tablespace TS_ZIKEN 　　storage(initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0), 　　partition p_200408 values less than (20

　　由于物价局要求从２００７年１月１日起所有卫生材料必须按新的标准进行作价，ＨＩＳ目前不支持批量调价功能，所以编写此存储过程，本来想在一个存储过程中进行处理，测试发现数据未提交最后一个过程提不出数据，所以分开为２个．[@more@]create or replace procedure zl_材料调价 as v_收费价目_ID NUMBER; v_NO VARCHAR2(10); Cursor C_调价明细 is select A.材料ID AS 收费细目ID,a.成本价,b.现价 as 原价,b.id as 原价ID, B.收入项目ID,round(A.成本价/(100-a.指导差价率)*100,2) AS 调整价 from 材料特性 A,