tttile "Disk Read Write" col phyrds format 999,999,999;
col pyywrits format 999,999,999;
col readtim format 999,999,999;
col writetim format 999,999,999; col name format a60;
select name, phyrds, phywrts, readtim, writetim from v$filestat a, v$datafile b where a.file#=b.file# order by 3 desc;
col pyywrits format 999,999,999;
col readtim format 999,999,999;
col writetim format 999,999,999; col name format a60;
select name, phyrds, phywrts, readtim, writetim from v$filestat a, v$datafile b where a.file#=b.file# order by 3 desc;
No comments:
Post a Comment