This discussion is archived
3 Replies Latest reply: Jul 10, 2013 4:24 PM by user13040671 RSS

DBRM for IO rationing...when does IO rationing kick in

user13040671 Newbie
Currently Being Moderated


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




  • Correct Answers - 10 points
  • Helpful Answers - 5 points