reads vs writes

We are trying to find out if our database is more read or write intensive. so I queried v$sysstat in our DB that has been running for the past 2 years. When i was looking for physical writes, I queried for statistics using 'physical write%' and 'physical read%' and it looks like we are read heavy with about 15x more reads than writes. Is this a right way approximately to gauge if a system is read or write heavy?

--

Thanks,
Ram

--

http://www.freelists.org/webpage/oracle-l Received on Mon Feb 12 2024 - 20:59:07 CET