資源規(guī)劃
I/O資源隔離
set linesize 400
col PDB_NAME for a10
col BEGIN_TIME for a30
col END_TIME for a30
SELECT R.SNAP_ID,
R.CON_ID,
P.PDB_NAME,
TO_CHAR(R.BEGIN_TIME, YYYY-MM-DHH24:MI) AS BEGIN_TIME,
TO_CHAR(END_TIME, YYYY-MM-D HH24:MI) AS END_TIME,
R.IOPS,
R.IOMBPS,
R.IOPS_THROTTLE_EXEMPT,
R.IOMBPS_THROTTLE_EXEMPT,
R.AVG_IO_THROTTLE
FROM DBA_HIST_RSRC_PDB_METRIC R, CDB_PDBS P
WHERE R.CON_ID = P.CON_ID
ORDER BY R.BEGIN_TIME;
SQL> alter session set container=masterpdb;
Session altered.
SQL> alter system set max_iops=27 scope=both;
System altered.
SQL> alter system set max_mbps=1 scope=both;
System altered.
SQL> alter session set container=masterpdb2;
Session altered.
SQL> alter system set max_iops=25 scope=both;
System altered.
SQL> alter system set max_mbps=1 scope=both;
System altered.
內(nèi)存隔離
如果需對每個PDB進行內(nèi)存控制,需要滿足:
CDB$ROOT中初始化參數(shù)NONCDB_COMPATIBLE保持為默認(rèn)的FALSE。
CDB$ROOT中初始化參數(shù)MEMORY_TARGET設(shè)置為0。
CDB$ROOT中的SGA_TARGET不為0。
PDB中的pga_aggregate_target必須小于CDB$ROOT中的pga_aggregate_target。
SQL> alter session set container=masterpdb;
Session altered.
SQL> alter system set sga_target=200M scope=both;
System altered.
SQL> alter system set sga_min_size=100M scope=both;
System altered.
SQL> alter system set pga_aggregate_limit=256M;
System altered.
SQL> alter system set pga_aggregate_target=10M scope=both;
System altered.
SQL> alter session set container=masterpdb2;
Session altered.
SQL> alter system set sga_target=230M scope=both;
System altered.
SQL> alter system set sga_min_size=50M scope=both;
System altered.
SQL> alter system set pga_aggregate_limit=256M;
System altered.
SQL> alter system set pga_aggregate_target=10M scope=both;
System altered.
CPU隔離
SQL> exec DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA();
PL/SQL procedure successfully completed.
BEGIN
DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN(plan => CDB_PLAN_TEST,
comment => CDB PLAN);
END;
/
BEGIN
DBMS_RESOURCE_MANAGER.CREATE_CDB_PROFILE_DIRECTIVE(plan => CDB_PLAN_TEST,
profile => PDB_1_PROFILE,
shares => 3,
utilization_limit => 40,
parallel_server_limit => 40);
END;
/
BEGIN
DBMS_RESOURCE_MANAGER.CREATE_CDB_PROFILE_DIRECTIVE(plan => CDB_PLAN_TEST,
profile => PDB_2_PROFILE,
shares => 1,
utilization_limit => 20,
parallel_server_limit => 20);
END;
/
SQL> exec DBMS_RESOURCE_MANAGER.VALIDATE_PENDING_AREA();
PL/SQL procedure successfully completed.
SQL> exec DBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA();
PL/SQL procedure successfully completed.
ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = CDB_PLAN_TEST scope=both;
SQL> alter session set container=masterpdb;
Session altered.
SQL> alter system set db_performance_profile=PDB_1_PROFILE scope=spfile;
System altered.
SQL> alter session set container=masterpdb2;
Session altered.
SQL> alter system set db_performance_profile=PDB_2_PROFILE scope=spfile;
System altered.
SQL> alter pluggable database all close immediate;
Pluggable database altered.
SQL> alter pluggable database all open;
Pluggable database altered.
select inst_id, name, con_id, value, ispdb_modifiable
from gv$system_parameter2
where name = db_performance_profile
order by 1, 2, 3, 4;
SQL> alter session set container=CDB$ROOT;
Session altered.
select p.name, shares, utilization_limit, parallel_server_limit, profile
from v$rsrc_plan r, v$pdbs p
where r.con_id = p.con_id;
文章版權(quán)歸作者所有,未經(jīng)允許請勿轉(zhuǎn)載,若此文章存在違規(guī)行為,您可以聯(lián)系管理員刪除。
轉(zhuǎn)載請注明本文地址:http://specialneedsforspecialkids.com/yun/129418.html
集成安裝之Oracle12C補丁升級數(shù)據(jù)字典更新報錯處理 img{ display:block; margin:0 auto !important; width:100%; } body{ width:75%; ...
閱讀 1346·2023-01-11 13:20
閱讀 1684·2023-01-11 13:20
閱讀 1132·2023-01-11 13:20
閱讀 1858·2023-01-11 13:20
閱讀 4100·2023-01-11 13:20
閱讀 2704·2023-01-11 13:20
閱讀 1385·2023-01-11 13:20
閱讀 3597·2023-01-11 13:20