Re: Am I on Oracle RDS?
Date: Fri, 12 May 2023 15:13:42 +0200
Message-ID: <CA+dM1yP6quDZPJjoDpdeeFDyhG-YuPXgBm11eT1fFhmBHJ1fmw_at_mail.gmail.com>
what is the resault of "select distinct machine from v$session where
username is null " ?
regards
PP
Il giorno ven 12 mag 2023 alle ore 10:33 Stefan Koehler
<contact_at_soocs.de> ha scritto:
>
> 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-lReceived on Fri May 12 2023 - 15:13:42 CEST