oracle 同时运行多个pdb,在Oracle 12.2多租户架构中只flush 某个pdb的buffer cache

[oracle@db12cr2 ~]$ sqlplus / as sysdba

sql*Plus: Release 12.2.0.1.0 Production on Mon Mar 13 03:22:53 2017

Copyright (c) 1982,2016,Oracle. All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

sql> set lines 300

sql> column NAME format a30

sql> col pdb format a30

sql> select CON_ID,NAME,OPEN_MODE from V$PDBS;

CON_ID NAME OPEN_MODE

---------- ------------------------------ ----------

2 PDB$SEED READ ONLY

3 HIGHGO1 READ WRITE

4 HIGHGO2 MOUNTED

5 HIGHGO3 MOUNTED

sql> alter session set container = highgo1;

Session altered.

sql> show con_id

CON_ID

------------------------------

3

sql> show con_name

CON_NAME

------------------------------

HIGHGO1

sql> alter system flush BUFFER_CACHE;

System altered.

sql>

alert中的输出:

2017-03-13T03:29:12.398178+08:00

HIGHGO1(3):ALTER SYSTEM: Flushing buffer cache inst=0 container=3 global

结论:

Oracle数据库实现了buffer cache,shared pool等等内存区域的con_id化.

如下摘自Oracle database 12.2管理文档 第1434页.

Although consolidated into a single physical CDB,PDBs mimic the behavior of traditional non-CDBs.

For example,a PDB administrator can flush the shared pool

or buffer cache in the context of a PDB without affecting other PDBs in the CDB.

总结

如果觉得编程之家网站内容还不错，欢迎将编程之家网站推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。