默认情况下 cellnode的iormplan的objective为basic,表示minimally enabled,是默认值。如果需要启用iormplan,需要将其修改为其他值。
dbplan是按照数据库进行io资源划分,catplan是按照业务模块重要性进行资源划分
在资源比较紧张的情况下,会有限保障share值高的io请求。单个数据库的share值可设置位1-32之间。
flashcache选项可以限制一个db是否可使用flashcache功能
flashlog选项可以限定一个db是否可使用flashlog功能
CellCLI> alter iormplan objective=auto;
IORMPLAN successfully altered
CellCLI> list iormplan attributes objective;
auto
CellCLI> alter iormplan dbplan=((name=db1,share=8),(name=cdb1,share=4));
IORMPLAN successfully altered
CellCLI> list iormplan attributes dbplan;
((name=db1,share=8),(name=cdb1,share=4))
CellCLI> alter iormplan dbplan=((name=db1,share=50));
CELL-00023: The IORMPLAN contains an invalid value 50 for share. Share must be assigned an integer from 1 to 32.
CellCLI> alter iormplan dbplan=((name=db1,limit=90,share=20),(name=cdb1,limit=30,share=10));
IORMPLAN successfully altered
CellCLI> list iormplan attributes dbplan;
((name=db1,limit=90,share=20),(name=cdb1,limit=30,share=10))
CellCLI> alter iormplan dbplan=((name=db1,limit=90,share=20,flashcache=on,flashlog=on),(name=cdb1,limit=30,share=10,flashcache=off,flashlog=off));
IORMPLAN successfully altered
CellCLI> list iormplan attributes dbplan;
((name=db1,limit=90,share=20,flashcache=on,flashlog=on),(name=cdb1,limit=30,share=10,flashcache=off,flashlog=off))
CellCLI> alter iormplan dbplan='',catplan=((name=cat_high,level=1,allocation=70),(name=cat_mid,level=1,allocation=5),(name=other,level=1,allocation=10));
IORMPLAN successfully altered
CellCLI> list iormplan detail;
name: slcc04cel08_IORMPLAN
catPlan: name=cat_high,level=1,allocation=70
name=cat_mid,level=1,allocation=5
name=other,level=1,allocation=10
dbPlan:
objective: auto
status: active
参考了帖子
http://rob.lasonder.org/index.php?title=Configure_IORM
https://emilianofusaglia.net/tag/io-resource-manager/
http://oracle-help.com/oracle-database/multitenant/pdb-performance-profile/