ORACLE 12c
小学生汤米
这个作者很懒,什么都没留下…
展开
-
Oracle 多租户CDB/PDB操作汇总
--查看当前数据库是否为CDB SELECT NAME, CDB, CON_ID FROM V$DATABASE; --查看CDB中可用的service: col name format a20 col pdb format a20 set linesize 200 select name,pdb from v$services; --切换会话到pdb原创 2017-10-30 15:12:43 · 797 阅读 · 0 评论 -
Oracle 12.1.0.2 In-Memory组件测试
1:连接到sys用户下,查看内存初始化参数的值 [sql] view plain copy [oracle@oracle12c ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 30 23:25:42 2014 Copyrigh转载 2017-10-26 13:57:21 · 673 阅读 · 0 评论 -
ORACLE 12c sharded database
alter system set open_links=16 scope=spfile; alter system set open_links_per_instance=16 scope=spfile; alter user gsmcatuser account unlock; alter user gsmcatuser identified by oracle; cre原创 2017-09-27 14:47:14 · 352 阅读 · 0 评论