在Oracle 12.2多租户架构中只flush 某个pdb的buffer cache

最新推荐文章于 2024-05-16 22:01:34 发布

msdnchina

最新推荐文章于 2024-05-16 22:01:34 发布

阅读量1k

点赞数

分类专栏： Oracle DB 12c Oracle DB 12c新特性文章标签： flush pdb buffer_cache shared_pool

本文链接：https://blog.csdn.net/msdnchina/article/details/62041404

版权

Oracle DB 12c 同时被 2 个专栏收录

62 篇文章 0 订阅

订阅专栏

Oracle DB 12c新特性

39 篇文章 8 订阅

订阅专栏

[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.