As per our promise we are providing Oracle tips and technical papers for about some internals of Oracle database.It is very important for every advance Oracle DBA.
Day by day in new version of Oracle we found hidden parameters are being increased.Oracle 10g (10.2.0.4) is having 1237 hidden parameters. Double under score parameters are introduced in Oracle 10g hidden parameters. Above counting is including of double underscore hidden parameters also.
Hidden parameters called as undocumented parameters of Oracle and it is not easy to change those parameters. Because Oracle doesn’t take any kind of guarantee for database stablility (if changed without getting advise from Oracle Support).
It is not advisable to change hidden parameters of Oracle database for DBAs without instruction of Oracle Support.
You can find out all list of hidden parameters of Oracle 10g Database with description and default value from following link.
File name: Oracle 10g hidden parameters
Thanks and regards,
Remote DBA expert Team