RE: Am I on Oracle RDS?
Date: Fri, 12 May 2023 13:36:08 +0000
Message-ID: <CY4PR0701MB3700B0FCB4B6FD91D33BE6CB83759_at_CY4PR0701MB3700.namprd07.prod.outlook.com>
Perhaps the following:
SQL> select substr(file_name,1,10) filename_dir from dba_data_files where rownum=1;
FILENAME_DIR
-----Original Message-----
Hello Nenad,
Best Regards
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de/
> Nenad Noveljic <nenad.noveljic_at_gmail.com> hat am 12.05.2023 10:07 CEST geschrieben:
/rdsdbdata
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Stefan Koehler
Sent: Friday, 12 May 2023 10:32
To: nenad.noveljic_at_gmail.com; ORACLE-L <oracle-l_at_freelists.org>
Subject: [EXTERNAL] Re: Am I on Oracle RDS?
I don't have a RDS instance at hand right now but maybe you also have the metadata information available in RDS (by using UTL_HTTP) like described here with EC2: https://www.dbi-services.com/blog/oracle-disables-your-multitenant-option-when-you-run-on-ec2/
Stefan Koehler
Twitter: _at_OracleSK
>
> Is there anything else, besides V$INSTANCE.INSTANCE_NAME, that we can query to determine if we're connected to an RDS instance?
>
> SQL> select instance_name from v$instance ;
>
> INSTANCE_NAME
> ----------------
> RDSCDB
>
> Best regards,
> Nenad
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 12 2023 - 15:36:08 CEST