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
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.