Database Reference
In-Depth Information
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SYS@orcl3>select value from v$parameter where name='threaded_execution';
VALUE
--------------------------------------------------------------------------------
TRUE
Multi-threading is certainly enabled. Let's now turn it off:
SYS@orcl3>ALTER SYSTEM SET threaded_execution=FALSE SCOPE=SPFILE;
System altered.
Then restart the instance:
SYS@orcl3>SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@orcl3>STARTUP;
ORACLE instance started.
Total System Global Area 3256942592 bytes
Fixed Size 2293640 bytes
Variable Size 1744830584 bytes
Database Buffers 1493172224 bytes
Redo Buffers 16646144 bytes
Database mounted.
Database opened.
Now try again to enter Oracle CDB from the Unix command line:
[oracle@orlin ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Sun Dec 22 23:45:08 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SYS@orcl3>select sys_context('userenv', 'con_name') from dual;
SYS_CONTEXT('USERENV','CON_NAME')
--------------------------------------------------------------------------------
CDB$ROOT
