Dump modified_parameters

dump_modified_parameters.sql

SQL> alter session set events '1843 trace name MODIFIED_PARAMETERS';

Session altered.

SQL> select * from dual where systimestamp>'2023-55-01 00:00:00';
select * from dual where systimestamp>'2023-55-01 00:00:00'
                                      *
ERROR at line 1:
ORA-01843: not a valid month


SQL> @tracefile_read_current.sql

TRACEFILE_NAME
----------------------------------------------------------------------------------------------------
/opt/oracle/diag/rdbms/ora19/ORA19/trace/ORA19_ora_16013.trc


PAYLOAD
----------------------------------------------------------------------------------------------------
*** CONTAINER ID:(3) 2023-01-17T17:53:47.054542+00:00

DYNAMICALLY MODIFIED PARAMETERS:
  nls_language             = "AMERICAN"
  nls_territory            = "AMERICA"
  nls_sort                 = "BINARY"
  nls_date_language        = "AMERICAN"
  nls_date_format          = "yyyy-mm-dd hh24:mi:ss"
  nls_currency             = "$"
  nls_numeric_characters   = ".`"
  nls_iso_currency         = "AMERICA"
  nls_calendar             = "GREGORIAN"
  nls_time_format          = "hh24:mi:ssxff"
  nls_timestamp_format     = "yyyy-mm-dd hh24:mi:ssxff"
  nls_time_tz_format       = "hh24:mi:ssxff TZR"
  nls_timestamp_tz_format  = "yyyy-mm-dd hh24:mi:ssxff TZR"
  nls_dual_currency        = "$"
  nls_comp                 = "BINARY"

18 rows selected.