Parameter file

From Oracle FAQ

Jump to: navigation, search

You may want to tune various instance parameters for memory usage, etc., to do this you will have to change Oracle's initialization parameter file.

Oracle offers two types of parameter files - INIT.ORA and SPFILE.

Contents

[edit]

Parameter file types

[edit]

INIT.ORA/ PFILEs

PFILEs are also know as INIT.ORA files. Characteristics of a PFILE:

  • Client side
  • Text file
  • Edit with text editor like vi or notepad
[edit]

SPFILEs

Characteristics of an SPFILE:

  • Server side
  • Binary file
  • Edit by issuing ALTER SYSTEM SET commands

To see if a database is using an SPFILE, issue the following command from SQL*Plus: 

show parameter spfile;
[edit]

See what parameters are set

From SQL*Plus (connect SYS AS SYSDBA): 

show parameters db_name

As a query: 

SELECT * FROM v$parameter;
[edit]

Also see

Retrieved from "http://www.orafaq.com/wiki/Parameter_file"
Personal tools