Parameters inside ORACLE Server Parameter File (SPFILE)

Copy all these parameters to create pfile (init.ora) , modify necessary path and size according to your requirement. 

From pfile you can create spfile by using "create spfile from pfile='location\init.ora'; "

  

__db_cache_size=2816M

__java_pool_size=32M

__large_pool_size=16M

__oracle_base='/d01/app/oracle' # ORACLE_BASE set from environment

__pga_aggregate_target=2512M

__sga_target=3744M

__shared_io_pool_size=0

__shared_pool_size=800M

Server Parameter File of ORACLE 11g - I

1. Default location of PFILE and SPFILE in UNIX and WINDOWS are?

For UNIX :              $ORACLE_HOME/dbs                  or   /d02/app/oracle/product/11.2.0/dbhome/dbs

For WINDOWS :  %ORACLE_HOME\database      or  c:\app\oracle\product\11.2.0\dbhome\database

SQL> show parameter spfile

NAME      TYPE        VALUE

--------- ----------- ------------------------------

spfile    string      /d01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora