VMCD.ORG » 12c new feature

关于12c Pluggable database注册listener问题

演示一下12c中关于pdb的listener register,unregister问题

[oracle@db-42 ~]$ lsnrctl status listener1

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on[......]Read more

1. create Pluggable database from NON_CDB database.

[oracle@db-42 ~]$ ora si 

SQL*Plus: Release 12.1.0.1.0 Production on Fri Jul 5 13:07:08 20[......]Read more

根据JL,Glen Fawcett 的文章 oracle 从12c开始提供了3个视图来探测慢速的IO

SQL> desc V$LGWRIO_OUTLIER;
 Name					   Null?    Type
 -----------------------------------[......]Read more

首先我们看一组测试数据库版本oracle 12c beta1

SQL> select count(*) from test;

  COUNT(*)
----------
    725888

SQL> set timing on;
SQL> alter[......]Read more