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