To create a medium-sized SGA, comment out the small parameter definition and activate the medium parameter definition. The parameter that creates a small SGA is active in this first example: db_block_buffers = 200 # SMALL Several initialization parameters are specified with three different values to create a small, medium, or large System Global Area, respectively. Here are two examples of activation and de-activation of alternative parameters. To use sample file initsmpl.ora as part of database creation:Įdit this file to reflect the correct location of your database control files and the name of your database, as a minimum. You can use either initsmpl.ora or the starter database init.ora as a basis for creating a new Oracle Database initialization parameter file. If you installed a starter database, the initialization parameter file used by the starter database is located in the same directory. and is located in ORACLE_BASE\ ORACLE_HOME\admin\sample\pfile. To de-activate a particular parameter, edit the initialization parameter file to add a comment sign. To activate a particular parameter, remove the preceding # sign. These values and annotations are preceded by comment signs ( #), which prevent them from being processed. Oracle Database provides an annotated sample initialization parameter file with alternative values for initialization parameters.
0 Comments
Leave a Reply. |