4/15:关于resource plan

???? 7月前 606

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

最后于 7月前 被????编辑 ,原因:
最新回复 (1)
  • Vince 7月前
    引用 2
    能不能捎带介绍下背景,就是遇着什么问题后需要做这个查询?谢谢
返回
发新帖