Miladin Modrakovic's Blog: Oraclue

Quick way to find dynamically modified parameters.

Again old friend oradebug.Command oradebug dump modified_parameters will dump all dynamically altered parameters  (parameteres modified using alter system or alter session command).

Example:

oradebugh setmypid

SQL> alter session set cursor_sharing=force;

oradebug dump modified_parameters 1

oradebug tracefile_name
/oracle/admin/diag/rdbms/test/trace/test_ora_194.trc

host vi /oracle/admin/diag/rdbms/test/test_ora_194.trc

DYNAMICALLY MODIFIED PARAMETERS:
  _memory_broker_stat_interval= 600
  service_names            = test.world
  local_listener           = LISTENER_TEST
  cursor_sharing           = FORCE
  result_cache_max_size    = 10485760
  result_cache_max_result  = 6
  diagnostic_dest          = /ora-main/app/oracle/admin