# 44521
Ting
|
|
To:
Hi 盖老师:
有个问题不太明白,请大师帮忙。
检查点队列与lruw的关系,写脏数据到底写哪个链表呢?
From: Ting 2009.11.26 18:36
|
|
|
|
# 44519
javen
|
|
To: eygle
SQL> select TO_CHAR (snap_time,'yyyy-mm-dd HH24:MI:SS' snap_time,
SUBSTR (TO_CHAR (snap_time,'yyyy-mm-dd HH24:MI:SS',12) TIME,
(newreads.VALUE - oldreads.VALUE) READS,
(newwrites.VALUE - oldwrites.VALUE) WRITES
from perfstat.stats$sysstat oldreads,
perfstat.stats$sysstat newreads,
perfstat.stats$sysstat oldwrites,
perfstat.stats$sysstat newwrites,
perfstat.stats$sysstat sn
where newreads.snap_id=sn.snap_id
and newwrites.snap_id=sn.snap_id
and oldreads.snap_id=sn.snap_id - 1
and oldwrites.snap_id=sn.snap_id - 1
and oldreads.NAME='physical reads'
and newreads.NAME='physical reads'
and oldwrites.NAME='physical writes'
and newwrites.NAME='physical writes'
and (newreads.VALUE - oldreads.VALUE)>0
and (newwrites.VALUE - oldwrites.VALUE)>0
/
From: javen 2009.11.25 20:14
|
|
|
|
# 44516
Ting
|
|
To:
呵呵,多谢大师热心的回答。
还有个问题要请教您
每隔3秒钟会把rba记录到控制文件当中。
日志切换会把rba记录到控制文件和数据文件头。
那么如果控制文件丢失,介质恢复用的是哪个rba,怎样恢复的呢?
From: Ting 2009.11.21 05:55
|
|
|
|
# 44515
咪咪同学
|
|
To: 猫咪同学
突然很想念你喔!
From: 咪咪同学 2009.11.18 20:01
|
|
|
|
# 44513
Ting
|
|
To:
控制文件中的数据文件检查点scn和数据文件的启动scn相同,并且他们的scn大于数据文件中的数据块scn,就一定可以将数据库open?
From: Ting 2009.11.13 20:41
|
|
|
|
To: Ting
一定。。。没有人能判断
数据文件里边的数据块,SCN肯定多数是小于文件头的SCN的。
From: eygle 2009.11.14 01:32
|
|
|
|
|