You can Query itself from database to know the documented parameter, however we only use/ set the Values for this on the basis of requirement by Application/session etc.
set pagesize 35
set linesize 150
col NAME format a30
col VALUE format a20
col DESCRIPTION format a60
SELECT x.ksppinm NAME, y.ksppstvl VALUE, ksppdesc DESCRIPTION
FROM x$ksppi x, x$ksppcv y
WHERE x.inst_id = userenv('Instance')
AND y.inst_id = userenv('Instance')
AND x.indx = y.indx
AND SUBSTR(x.ksppinm,1,1) ^= '_'
ORDER BY 1;
There are different parameter requirements for different environments and generalization may be difficult. Below are some documents for the specific environments.
Database Initialization Parameters for Oracle Applications Release 11i [ID 216205.1]
Database Initialization Parameters for Oracle Applications Release 12 [ID 396009.1]
Also find below the document which contains a sample of the parameter files.
Sample Initialization Parameter File
- Natik Ameen
Recommended for what since there are many different features and based on the requirement, licensing, usage of them may or may not be required. You may want to tell us more than just asking a list of the parameters , for example, a better question would be, I want to ensure that the memory management of my instance is good, how do I ensure it through a parameter, if any?