Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Matthias.

Asked: February 08, 2023 - 4:56 pm UTC

Last updated: June 03, 2025 - 1:38 am UTC

Version: 12.1

Viewed 1000+ times

You Asked

SQL> alter session set standby_max_data_delay=1;

Session altered.

SQL> show parameter standby_max_data_delay
SQL> select * from v$parameter where name='standby_max_data_delay';

no rows selected

SQL>


Where can I see my current setting of standby_max_data_delay ?

and Connor said...

Unfortunately nowhere because its not a "real" parameter, but a session setting

https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/ALTER-SESSION.html#GUID-DC7B8CDD-4F89-40CC-875F-F70F673711D4

Even tinkering about with some dumps didnt really expose it any meaningful way, and I wasn't about to hex hunting to look for it :-)

We'll log an enhancement to get it exposed in v$session or via sys_context

Rating

  (4 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thanks

Matthias Rogel, February 15, 2023 - 10:58 am UTC

Thanks, Connor !

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database