V$pdbs

0 views

Skip to first unread message

Cora Devries

unread,

Aug 4, 2024, 5:24:55 PM8/4/24

to nyobarpatha

Butfor what reason it is such a problem?

In a multitenant environment you can connect directly to your Pluggable Database, but also jump between Pluggable Databases and the Root Container back and forth. When you work with several sessions and also several windows, you can lose track sometimes. Also for scripting it can be helpful to make changes to the right PDB and not to the Root Container by mistake.

With v$pdbs we do have a first option to get helpful information. You will get similar results with select * from cdb_pdbs. In the example we jump per alter session set container from CDB to PDB and back:

We also use third-party cookies that help us analyze how you use this website, store your preferences, and provide the content and advertisements that are relevant to you. These cookies will only be stored in your browser with your prior consent.

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.