Показать сообщение отдельно
  #4  
Старый 12.03.2010, 09:54
Marley Marley вне форума
Senior Member
 
Регистрация: 19.09.2009
Сообщений: 7,211
По умолчанию

select fs.phyrds "Reads" , fs.phywrts "Writes" , fs.avgiotim "Average I/O Time", df.name "Datafile"
FROM v$datafile df, v$filestat fs
WHERE df.file# = fs.file#;



select fs.phyrds "Reads" , fs.phywrts "Writes" , fs.avgiotim "Average I/O Time", df.name "Datafile"
FROM v$tempfile df, v$tempstat fs
WHERE df.file# = fs.file#;



SELECT ts.name AS ts, fs.phyrds "Reads" , fs.phywrts "Writes",
fs.phyblkrd as br, fs.phyblkwrt as bw,
fs.readtim "RTime", fs.writetim "WTime"
FROM v$tablespace ts, v$datafile df, v$filestat fs
WHERE ts.ts# = df.ts# AND df.file# = fs.FILE#
UNION
SELECT ts.name AS ts, ts.phyrds "Reads", ts.phywrts "Writes",
ts.phyblkrd AS br, ts.phyblkwrt AS bw,
ts.readtim "RTime", ts.writetim "WTime"
FROM v$tablespace ts, v$tempfile tf, v$tempstat ts
WHERE ts.ts# = tf.ts# AND tf.file# = ts.file# ORDER BY 1;
__________________
Телеграм чат

Последний раз редактировалось Marley; 12.03.2010 в 10:02.
Ответить с цитированием