活动第38次(2018-07-14星期六上午)
以下代码可以代替多租户书上P245页上的@create_burn_cpu.sql:
$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Sat Jul 14 09:27:37 2018
Copyright (c) 1982, 2014, Oracle.All rights reserved.
SQL> connsys/oracle_4U@pdb2 as sysdba
Connected.
SQL> create or replace procedure proc_burn
2is
3 v1 number;
4begin
5 selectcount(*)into v1 from cdb_source a , cdb_tables b;
6end;
7/
Procedure created.
SQL> selectcount(*) from cdb_source;
COUNT(*)
----------
342464
SQL> selectcount(*)fromcdb_tables b;
COUNT(*)
----------
2337
SQL> connsys/oracle_4U@pdb2_2 as sysdba
Connected.
SQL> create or replace procedure proc_burn
2is
3 v1 number;
4begin
5 selectcount(*)into v1 from cdb_source a , cdb_tables b;
6end;
7/
Procedure created.
SQL> selectcount(*) from cdb_source;
COUNT(*)
----------
342464
SQL> selectcount(*)fromcdb_tables b;
COUNT(*)
----------
2337
SQL>
使用图形界面创建书P245页上的两个资源计划(FAIRPLAN和UNFAIRPLAN):
->
->
->
->点“Show SQL”:
->注意一定要填写下图的50/50:
产生的SQL语句:
以下是unfairplan:
注意比较CDB级别的PLAN和插件/普通库里的PLAN:
注意:在做P248实验之前:
$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Sat Jul 14 10:40:14 2018
Copyright (c) 1982, 2014, Oracle.All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> alter system flush buffer_cache;
System altered.
SQL> alter system flush shared_pool;
System altered.
在fairplan下结果是公平的:
改成 unfairplan:
---------------------------------CDB的ADDM:
要立即执行ADDM:
会马上拍一张快照,并且与上一张快照做比较:
在ADDM之后,可以进一步去由ADDM提供一键按钮而进行SQL Tuning Advisor:
页:
[1]