In Toad, the Database | Monitor | Server Statistics is not displaying the CPU and Memory in Percentage form? Is there an option in Toad to change this display or can I submit and Enhancement for this?
There is no option to display the CPU and Memory in percentage form for this because Oracle doesn't store this info on a percentage basis. We could try calculate the % session CPU and memory as it relates to the total database CPU and memory, but the number would vary based on how many sessions there are, so this information could be misleading. For example, if there are 20 sessions, and one session is using 5% of the CPU, maybe that's no big deal, but if there are 1000 sessions, then the session is using a lot. That's why it is best for Toad to display the numbers that Oracle gives us.