Hi ,
We have a situation where we need to use racdiag.sql on a 10g database. The problem is that the gv$ping view has been deprecated and has no data. So the query below from racdiag.sql returns no rows:
set numwidth 8
column name format a20 tru
column kind format a10 tru
select inst_id, name, kind, file#, status, BLOCKS,
READ_PINGS, WRITE_PINGS
from (select p.inst_id, p.name, p.kind, p.file#, p.status,
count(p.block#) BLOCKS, sum(p.forced_reads) READ_PINGS,
sum(p.forced_writes) WRITE_PINGS
from gv$ping p, gv$datafile df
where p.file# = df.file# (+)
group by p.inst_id, p.name, p.kind, p.file#, p.status
order by sum(p.forced_writes) desc)
where rownum < 11
order by WRITE_PINGS desc;

What is the equivalent view for gv$ping in 10g. We tried gv$cache_transfer and that does not have any data as well.
Your help is really appreciated.
We need this query to work on 10g for an in-house tool.
Thanks