Find database name. (non-privileged users)

SQL> show user

USER is "SCOTT"

SQL> select ora_database_name from dual;

ORA_DATABASE_NAME
-------------------
NSEDB



SQL> select '&_CONNECT_IDENTIFIER' NAME from dual;
old   1: select '&_CONNECT_IDENTIFIER' NAME from dual
new   1: select 'NSEDB' NAME from dual

NAME
-----
NSEDB

how to change data guard real time apply to delayed apply

########## ON STANDBY: Real time Apply to Delayed apply ##########


SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DELAY 30 DISCONNECT FROM SESSION;




########## ON STANDBY: Revoking delayed apply to No delay apply #######

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE NODELAY DISCONNECT FROM SESSION;

--