My little IT blog now Oracle oriented

I was looking online for this issue: are you able to know when a parameter was changed in your database or also track all parameters changes in your database? Kerry Osborne has the solution. Even if you’re able to check in your alert log file for changes (Oracle logs every changes to parameters) you can [...]

Do you know that there are more than thirty not documented and hidden parameters for tracing? You can find them with this query: select ksppinm "Parameter Name", ksppstvl "Value", ksppstdf "Default", from x$ksppi x, x$ksppcv y where x.indx = y.indx and ksppinm like ‘/_%trace%’ escape ‘/’ ; Note that Oracle 9i has about 26 parameters [...]