How to know if my oracle DB (19c) is on premise or running on cloud? This DB is connected with Apex as well. I have searched in Google but could not get any solution.
Asked
Active
Viewed 192 times
1
-
It's not possible because DBMS knows nothing about what its host is. Cloud instance is the same dedicated database as on premise, but with additional resource management – astentx Mar 09 '23 at 05:52
1 Answers
1
Run
select CLOUD_IDENTITY
from v$pdbs;
That will tell if you its on Oracle cloud, or (null) means on-premises.
Connor McDonald
- 10,418
- 1
- 11
- 16
-
I am getting invalid identifier error while trying to select cloud_identity from v$pdbs – Baidarvi Roy Mar 10 '23 at 08:58
-
if the column is not present, then you're definitely not cloud. – Connor McDonald Mar 10 '23 at 09:59