某电厂数据库的问题,是ops,8.1.6,os是ALPHA OSFV4.0
Sat Dec 4 2004
Errors in file /ora8/oracle/admin/op/bdump/lmd0_1537.trc:
ORA-00600: internal error code, arguments: [kjprsem:inuse&!c], [904184384], [0], [0], [], [], [], []
Sat Dec 4 2004
Errors in file /ora8/oracle/admin/op/bdump/lmd0_1537.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [kjprsem:inuse&!c], [904184384], [0], [0], [], [], [], []
Sat Dec 4 2004
查看全文CREATE OR REPLACE PROCEDURE CheckSpacePutLine
IS
used number;
free number;
total number;
hit number;
pins number;
reloads number;
lib number;
smem number;
sdisk number;
para varchar2(2000);
pbytes number;
err number;
application date;
BEGIN
select sum(usedmb),sum(freemb),sum(totalmb)
into used,free,total
from
(
select usedmb,freemb,totalmb
from ts_used_free
where to_char(check_date,'yyyymmdd')=to_char(sysdate,'yyyymmdd')
);
SELECT 1 - (phy.value / (cur.value + con.value))
into Hit FROM v$sysstat cur, v$sysstat con, v$sysstat phy
WHERE cur.name = 'db block gets' AND con.name = 'consistent gets'
AND phy.name = 'physical reads';
select sum(pins) "Total Pins", sum(reloads) "Total Reloads",
sum(reloads)/sum(pins) *100 libcache
into pins,reloads,lib
from v$librarycache;
SELECT value into smem
FROM v$sysstat WHERE name IN ('sorts (memory)');
SELECT value into sdisk
FROM v$sysstat WHERE name IN ('sorts (disk)');
select bytes into pbytes
from v$sgastat where pool='shared pool' and name ='free memory';
select count(*) into err
from alert_tab WHERE text LIKE '%ORA-%' ;
select max(log_date) into application from eport.application_log ;
para := 'Used '||' '
|| to_char(used) || ' ' || ' Free' ||' '
|| to_char(free) || ' ' || ' Total'||' '
|| to_char(total)|| ' ' ||' bufferHitis '||''
|| to_char(hit)||' ' ||' SharePool'||' '
|| to_char(lib)||' ' || 'MemSort'||''||to_char(smem)||' DiskSort'||' '
|| to_char(sdisk) ||' '||' '
|| 'SharePoolFreebs:'||' '||to_char(pbytes) ||''
|| 'Terrs'||' '|| to_char(err) || ' ' || 'The Last Ap Err occured in' || to_char(application);
dbms_output.put_line(para);
END;
/
第五章 管理体系结构
目标
完成本课,你应该能:
描述自动工作负载资料库(AWR)的各种不同的组件
使用活动会话历史
定义AWR快照基线
对服务端的警告订阅应用程序
解释自动任务特征
描述顾问咨询框架
AWR
AWR是新的管理体系结构的中心元素,它为了发现问题和自我调整,为oracle内部服务组件提高了采集,处理,维护和访问性能统计数据.
AWR 概览
AWR的体系结构就是为oracle 10g组件提供了采集维护和使用统计信息来发现问题和自我调整的服务.
AWR的体系结构包括下面两个主要的部分:
在内存中的统计收集工具.这个统计为了性能的原因存在内存中
AWR快照代表了这个工具的永久部分.AWR快照通过数据字典和db control可以访问.
最近完成了在linux下模拟数据文件损坏和误删除表的恢复。
查看全文
