Doc Original: | Author: | Type: Tuning | SubType: | Cible: I/O | Desc: Poids des I/O des actions sur la base | Ver.: Oracle7/8 orig: UTLBSTAT/UTLESTAT. père: tun_io.sql, io_wts.sql Ce rapport genere les poids I/O des actions sur la base (util pour etudier l'architecture). NOTE: Les 'disques' sont extraits des XXXX premiers caracteres des filenames. On crée une view qu'on flingue ensuite. # create view radu_total_view as select max(x.phyrds +x.phywrts) max_total from v$filestat x, ts$ ts, v$datafile i,file$ f where i.file#=f.file# and ts.ts#=f.ts# and x.file#=f.file#; column drive format A10 column filename format a25 column total_io format 999999999 column weight format 999.99 rem break on drive skip 1 rem rem Somme des I/O pour chaque disque. rem compute sum of weight on drive rem rem Page formatting rem set linesize 80 pagesize 60 newpage 0 feedback off ttitle skip center "Poids des I/O des fichiers" skip center - "Par Disque" skip 2 rem select substr(i.name,1,6) "DRIVE", /*assumes a 5-letter drive name*/ i.name filename, x.phyrds "I/O Reads", x.phywrts "I/O Writes", x.phyrds + x.phywrts "total_io", round(100*(x.phyrds+x.phywrts)/m.max_total,2) weight from v$filestat x, ts$ ts, v$datafile i,file$ f, radu_total_view m where i.file#=f.file# and ts.ts#=f.ts# and x.file#=f.file# order by 1,2; drop view radu_total_view; ttitle off