-
编辑 删除
卸载IBM DB2数据库
IBM DB2有这广泛的应用，平时运维管理过程中会涉及它的卸载等步骤。 方法/步骤 1 1、环境确认确认DB2的服务都已经正常停止 2 2、卸载程序 3 3、删除用户# rmuser -p db2inst1# rmuser -p db2fenc1 4 4、 删除用户组# rmgroup -p db2fgrp1# rmgroup -p db2igrp1 5 5、删除目录# rm -r /opt/IBM/db2# rm -r /opt/IBM/ldap# rm -r
-
编辑 删除
Share pool内存调整
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-------------------------------------------------------------------------------------------------- 功 能：自动按系统当前的挂号安排产生挂号单，以方便护士练习分诊和医生接诊----
-
编辑 删除
How many partitions can Oracle partitioned?
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.
-
编辑 删除
Oracle分区操作相关语句
-- 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,
