does anyone know what views i could use to get the values for blocks read and blocks written for tablespace i/o.
Cheers
Douglas
Printable View
does anyone know what views i could use to get the values for blocks read and blocks written for tablespace i/o.
Cheers
Douglas
You can use the v$filestat view wich show informations about the datafile, so you can see who are the files that use your tablespace and get the information.