Search notes:

oradebug dump modified_parameters

oradebug dump modified_parameters shows values of init parameters of another session that were modified (i.e. whose value is different from their default value).

Modify parameters in a session

alter session set commit_logging = batch;
alter session set commit_wait    = nowait;

In order to execute oradebug setospid, we need the session's spid:

select
   prc.spid
from
   v$session     ses                                                   join
   v$process     prc on ses.paddr           = prc.addr
where
   ses.sid = sys_context('userenv', 'sid');
--
-- SPID
-- -----
-- 14028

Show modified parameters from another session

sqlplus / as sysdba
SQL> oradebug setospid  14028
SQL> oradebug dump modified_parameters 1
SQL> oradebug tracefile_name

The trace file shows, among others, the following information:

…
Received ORADEBUG command (#2) 'dump modified_parameters 1' from process '16512'
DYNAMICALLY MODIFIED PARAMETERS:
  …
  commit_wait              = "NOWAIT"
  commit_logging           = "BATCH"
…

Index