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

发布时间：2020-12-12 15:16:20 所属栏目：百科来源：网络整理

导读：[oracle@db12cr2 ~]$ sqlplus / as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Mon Mar 13 03:22:53 2017Copyright (c) 1982,2016,Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Pr

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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!