Re: Am I on Oracle RDS?

nice.

On Fri, May 12, 2023 at 2:37 PM Tahon Dirk [GTSBE] < dmarc-noreply_at_freelists.org> wrote:

> Perhaps the following:
>
> SQL> select substr(file_name,1,10) filename_dir from dba_data_files where
> rownum=1;
>
> FILENAME_DIR
> ----------------------------------------
> /rdsdbdata
>
>
> -----Original Message-----
> 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?
>
> Hello Nenad,
> 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/
>
> Best Regards
> Stefan Koehler
>
> Independent Oracle performance consultant and researcher
> Website: http://www.soocs.de/
> Twitter: _at_OracleSK
>
> > Nenad Noveljic <nenad.noveljic_at_gmail.com> hat am 12.05.2023 10:07 CEST
> geschrieben:
> >
> > 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
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l