How to check if a database is configured with Oracle Multitenant Architecture

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: Additionally, in case your database is a multitenant database, you can visualize it by using the following query: Published: 08/11/2018Updated: 12/04/2023 brunorsHi! 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…