The INIT.ORA file stores the initialization parameters for Oracle startup. The file can be view from SQL*Plus via executing command,
> show parameter NAME TYPE VALUE ---------------------------- ----------- ----------- instance_number integer 0 java_max_sessionspace_size integer 0 java_pool_size big integer 33554432 java_soft_sessionspace_limit integer 0 job_queue_processes integer 0 large_pool_size big integer 0 license_max_sessions integer 0 license_max_users integer 0 license_sessions_warning integer 0 local_listener string lock_name_space string
Name & Location
The default name for the file is initSID.ora. In UNIX/Linux, the location/path will be in $ORACLE_HOME/dbs. For Windows, the location is %ORACLE_HOME%\database.
