Check whether the database uses Oracle Multitenant Architecture; it is a simple operation. You can check this feature by querying the v$database using the CDB field as in the SQL example below:
SQL> select cdb from v$database; CDB --- YES
Additionally, in case your database is a multitenant database, you can visualize it by using the following query:
[oracle@techdata ~]$ . oraenv ORACLE_SID = [oracle] ? cdb1 The Oracle base remains unchanged with value /u01/app/oracle [oracle@techdata ~]$ sqlplus "/as sysdba" SQL*Plus: Release 19.0.0.0.0 - Production on Thu Nov 4 16:13:41 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> COLUMN NAME FORMAT A15 COLUMN RESTRICTED FORMAT A10 COLUMN OPEN_TIME FORMAT A30 SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM gV$PDBS; NAME OPEN_MODE RESTRICTED OPEN_TIME --------------- ---------- ---------- ------------------------------ PDB$SEED READ ONLY NO 2021-10-26 13:55:39,004 +02:00 TECHDB READ WRITE NO 2021-10-26 13:55:43,725 +02:00 TECHDBX READ WRITE NO 2021-10-26 14:38:36,388 +02:00 TECHDBO READ WRITE NO 2021-10-26 13:55:43,290 +02:00 TECHDBA READ WRITE NO 2021-10-26 13:55:44,569 +02:00
Published: 08/11/2018
Updated: 12/04/2023
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)