今天早上数据库有些慢,打开ALERT.LOG,看到大量的这个错.
Error 9925 received logging on to the standby
Mon May8 09:39:06 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2097K exceeds notification threshold (2048K)
KGL object name :Select A.CURENO,A.DRUGCODE,A.STATUS,
SUM(A.DOSAGE) as DOSAGE1,
DECODE(MAX(B.TYPE),'针剂',
SUM(CEIL(A.DOSAGE)),'注射剂',SUM(CEIL(A.DOSAGE)),CEIL(SUM(A.DOSAGE))) as DOSAGE,
MAX(B.NAME) as DRUGNAME,MAX(B.UNIT) as DRUGUNIT,MAX(B.SPECIFICATION) as SPEC,
A.SHEETID,A.INTERVALTYPE,A.QTYPERTIME as perdosage,A.W
ARDNO,A.SENDTIME,A.ISLONG,replace(replace(C.USETIME,':00'),'/','-') as USETIME,M
AX(d.HOSNO) as HOSNO,MAX(d.BEDNO)||'床' as bedno,
Mon May8 09:39:13 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2097K exceeds notification threshold (2048K)
Details in trace file /soft/oracle/admin/ora8/udump/ora8_ora_17957.trc
KGL object name :Select A.CURENO,A.DRUGCODE,A.STATUS,
SUM(A.DOSAGE) as DOSAGE1,
DECODE(MAX(B.TYPE),'针剂',
SUM(CEIL(A.DOSAGE)),'注射剂',SUM(CEIL(A.DOSAGE)),CEIL(SUM(A.DOSAGE))) as DOSAGE,
MAX(B.NAME) as DRUGNAME,MAX(B.UNIT) as DRUGUNIT,MAX(B.SPECIFICATION) as SPEC,
A.SHEETID,A.INTERVALTYPE,A.QTYPERTIME as perdosage,A.W
ARDNO,A.SENDTIME,A.ISLONG,replace(replace(C.USETIME,':00'),'/','-') as USETIME,M
AX(d.HOSNO) as HOSNO,MAX(d.BEDNO)||'床' as bedno,
初步看来是这句SQL报的错,我现在还在调查,有没有人以前碰到过类似问题,谢谢.
|