大家好,我不太了解oracle的数据库。
提个问题:检查checkpoint的频率时,结果会出现负数,这是什么原因啊。
这个语句好像适用老版本,现在的数据库是10g,在线求答,谢谢
my $query = qq(
SELECT /*+dynamic_sampling(2)*/ e.NAME NAME, e.VALUE - NVL (b.VALUE, 0) VALUE
FROM perfstat.stats\$sysstat b,
perfstat.stats\$sysstat e
WHERE b.snap_id =
(SELECT MIN (snap_id)
FROM perfstat.stats\$snapshot
WHERE snap_time >=
TO_DATE ('$date1 $time1', 'yyyy-mm-dd hh24.mi.ss')
AND snap_time <=
TO_DATE ('$date2 $time2', 'yyyy-mm-dd hh24.mi.ss'))
AND e.snap_id =
(SELECT MAX (snap_id)
FROM perfstat.stats\$snapshot
WHERE snap_time >=
TO_DATE ('$date1 $time1', 'yyyy-mm-dd hh24.mi.ss')
AND snap_time <=
TO_DATE ('$date2 $time2', 'yyyy-mm-dd hh24.mi.ss'))
AND b.dbid(+) = e.dbid
AND b.instance_number(+) = e.instance_number
AND b.NAME(+) = e.NAME
AND b.statistic# = 153
);
提个问题:检查checkpoint的频率时,结果会出现负数,这是什么原因啊。
这个语句好像适用老版本,现在的数据库是10g,在线求答,谢谢
my $query = qq(
SELECT /*+dynamic_sampling(2)*/ e.NAME NAME, e.VALUE - NVL (b.VALUE, 0) VALUE
FROM perfstat.stats\$sysstat b,
perfstat.stats\$sysstat e
WHERE b.snap_id =
(SELECT MIN (snap_id)
FROM perfstat.stats\$snapshot
WHERE snap_time >=
TO_DATE ('$date1 $time1', 'yyyy-mm-dd hh24.mi.ss')
AND snap_time <=
TO_DATE ('$date2 $time2', 'yyyy-mm-dd hh24.mi.ss'))
AND e.snap_id =
(SELECT MAX (snap_id)
FROM perfstat.stats\$snapshot
WHERE snap_time >=
TO_DATE ('$date1 $time1', 'yyyy-mm-dd hh24.mi.ss')
AND snap_time <=
TO_DATE ('$date2 $time2', 'yyyy-mm-dd hh24.mi.ss'))
AND b.dbid(+) = e.dbid
AND b.instance_number(+) = e.instance_number
AND b.NAME(+) = e.NAME
AND b.statistic# = 153
);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货