https://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN-GUID-04B4805A-A3B4-4B1E-B42D-01BAB4D4ECB4

http://blog.itpub.net/7569309/viewspace-2133550/

https://www.cnblogs.com/sqlite3/archive/2012/01/23/2567994.html

Resource plan

1. A container for directives that specify how resources are allocated to resource consumer groups. You specify how the database allocates resources by activating a specific resource plan.

2. The currently active resource plan does not enforce allocations until CPU usage is at 100%. If the CPU usage is below 100%, the database is not CPU-bound and hence there is no need to enforce allocations to ensure that all sessions get their designated resource allocation.

SELECT plan,status,comments FROM dba_rsrc_plans;

检擦当前current plan

SELECT name, is_top_plan FROM v$rsrc_plan;

NAME IS_TOP_PLAN

DEFAULT_PLAN TRUE ORA$AUTOTASK FALSE ORA$AUTOTASK_HIGH_SUB_PLAN FALSE

The plan for which IS_TOP_PLAN is TRUE is the currently active (top) plan