When an Oracle Instance is started, the characteristics of the Instance are established by parameters specified within the initialization parameter file. These initialization parameters are either stored in a PFILE or S[...]
select name , value from v$parameter where ismodified != 'FALSE' / [...]
Setting a parameter to =’ ‘ often isn’t enough. Do this instead… alter system reset <parameter> scope=spfile sid='*' / The sid='*' bit is always necessary, even in non RAC database. [...]
select name , value from v$parameter where ismodified != 'FALSE' / or for name='parameter' style... set pages 999 lines 100 select name || '=' || decode(type, 2, '''') || value || decode(type, 2, '''') param[...]
This page is an introduction to my blog, which is dedicated to Oracle data base performance management.
I found over the years sharing knowledge to be an invaluable tool in assisting me in my various consulting assignments. Spending most of my time in capacity planning, tuning, application sizing and performance management, I thought it might be [...]
