Oraclue

Oracle internals, debugging and undocumented features

List dinamically modified parameters

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

Advertisements

One response to “List dinamically modified parameters

  1. Andrey Goryunov June 5, 2009 at 4:18 am

    Is there any chance to know ora- errors that log messages to alert.log?

    Thanks,
    Andrey

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: