OEM 12c - Disk f of server is 99% busy, but how to tell what instance is doing most of that work.
I am using OEM Cloud Control 12c (12.1.0.2) and I have a disk on a server that is getting killed by IO. 99% busy and is highlighted as critical in OEM and I can drill down on this until I am blue in the face and I only get more graphs telling me just how bad it is.
I have over 20 instances on this server, so I would like to be able to figure out how to see a percentage of the IO broken down by target (db instance).
which database is doing the most IO on this drive that is so busy?