For the first question: your storage vendor should give you this number. The figure can change dramatically depending on the load profile of the database: generally speaking the number of IOPS will decrease as the IO size gets bigger.
For the second question: You didn't mention you OS. In Linux/Unix you'd use iostat or something fancier if it's installed. In windows you'd use perfmon.
Harel Safra On 07/12/2010 21:25, Oracle Dba Wannabe wrote:
If not does anyone know how to calculate how many iops are possible from a storage and how much the oracle server is issuing?thanks ------------------------------------------------------------------------ **
