For inter-db or for category IORM, we know to turn it on with "alter iormplan dbplan=<> catplan=<> "command.
For intra-database IO rationing, what are we supposed to be doing? Nothing but just turning the DBRM at the database level?
Reason I ask is:
Let's say, we turn it at the DB, using our RESOURCE_MANAGER_PLAN='MY_EXA_PLAN'
What happens to the IO requests for that DB? They automatically are rationed according to the directives in the 'MY_EXA_PLAN'?
Or should we turn it on using: ALTER IORMPLAN ACTIVE?
How, then, to turn the IO rationing OFF? Because I get this when trying to turn it off:
CellCLI> alter iormplan inactive
IORMPLAN status cannot be set to inactive
IORMPLAN successfully altered
This is what they call RTFM...in the old 11.2.2.x version, there does not seem to be the word "objective" in the pdf documentation for Exadata Storage Server Software - User's Guide (E13861-05), updated Jan-2010.
In this pdf for 18.104.22.168.1.130109, the word "objective" is key for turning the I/O rationing/prioritization off or on.
I am talking about Exadata Storage Server Software - User's Guide (E13861-14), updated July-2012.
So, you set it to basic and you turn it off.
You set it to balanced or low_latency or high_throughput or auto, you turn it on.
Note to self: RTFM