Oracle 9i initialization parameter file __oracle

Pfile file
The Pfile (Parameter file) file is a text-formatted parameter file that contains configuration parameters for the database.
Oracle 9i establishes a pfile for each database at installation time, the default name is "init+ routine name. Ora", a text file that can be opened with any text editing tool.
Table 6.1 initialization parameter file analysis of database

Content	Description
# Copyright (c) 1991, 2001 by Oracle Corporation	Oracle Company Copyright logo
# MTS	Multithreaded server configuration identity, referred to as shared server configuration in Oracle 9i
Dispatchers= "(protocol=tcp) (Ser=modose)", "(PROTOCOL=TCP) (Pre=oracle.aurora.server.giopserver)", "(PROTOCOL=TCP) (Pre=oracle.aurora.server.sgiopserver) "	Multithreaded Server Configuration
# Other	Configure additional parameters
compatible=9.0.0	Compatible version 9.0.0
Db_name=myoracle	Database name is MyOracle
# Distributed, replicated and snapped	Configuring distributed, replication, and snapshot parameters
Db_domain=mynet	The database domain name is mynet, plus the database name db_name make up the global database name
Remote_login_passwordfile=exclusive	Specifies whether the operating system or password file has permission to check the user's password. Set to exclusive, each user with permissions will be authenticated using the password file for the database.
# sort, hash join, bitmap index	Configure sorting, hashing joins, bitmap index parameters
sort_area_size=524288	The maximum amount of memory used by the specified sort area is 512KB. When the sorting is complete, the rows are returned and memory is freed. Increasing this value can increase the efficiency of large sorting.
# File Configuration	File configuration Parameters
Control_files= ("c:/oracle/oradata/myoracle/control01.") CTL "," c:/oracle/oradata/myoracle/control02. CTL "," c:/oracle/oradata/myoracle/control03. CTL ")	Specify the path and file name of the control file
# Pool	Memory configuration Parameters
java_pool_size=33554432	Specifies a Java storage pool size of 32MB, which is used to store Java methods, class definitions, and Java objects.
large_pool_size=1048576	Specifies a large pool size of 1MB, which is used to share the server's session memory, the parallel message buffer execution, and the disk I/O buffers for Rman backup and recovery.
shared_pool_size=33554432	Specifies the size of a shared pool of 32MB, which is used to store objects such as shared cursors, stored procedures, control structures, and parallel execution of message buffers. Higher values can improve performance of multiuser systems
# Cursor and library cache	Configuring cursors and Cache Parameters
open_cursors=300	Specifies that the maximum number of cursors that can be opened at one time for a session is 300, which should be set high enough to prevent the application from running out of open cursors
# System-managed undo and fallback segments	Configure system Management Undo and Rollback segment parameters
Undo_management=auto	Specifies that the undo space management used by the system is SMU, and that, in the SMU mode, the undo space is allocated externally as the undo Tablespace
Undo_tablespace=undotbs	Specifies that the rollback table space is Undotbs
# Network Registration	Configure Network Registration parameters
Instance_name=myoracle	Routine name is MyOracle
# Diagnostics and Statistics	Configuring Diagnostics and Statistics parameters
Background_dump_dest=c:/oracle/admin/myoracle/bdump	Background process trace File directory
Core_dump_dest=c:/oracle/admin/myoracle/cdump	Core Dump trace File directory
Timed_statistics=true	Collects timing information for the operating system, which can be used to optimize database and SQL statements
User_dump_dest=c:/oracle/admin/myoracle/udump	User process trace File directory
# Process and Session	Configuring processes and Session information
processes=150	Specifies that the maximum number of operating system user processes that can connect to an Oracle server simultaneously is 150
# Redo Logs and restores	Redo log and restore parameter settings
fast_start_mttr_target=300	Specifies that the time required to recover from a single database routine crash is 300 seconds
# cache and I/O	Configuring Cache and I/O parameters
db_block_size=4096	Specifies that the data block size is 4KB
db_cache_size=33554432	Specify a data buffer of 32MB, the larger the value, you can reduce the number of I/O to the database files, improve efficiency

SPFile file
SPfile (server Parameter file) is a binary format parameter file that contains parameters and values for databases and routines, but cannot be opened with a text editing tool.
The following compares the two initialization parameter files as shown in Table 6.2.
Table 6.2 Comparison of SPFile and pfile files

comparison	SPfile	Pfile
format	binary format	text Format
Edit	(1) Use Enterprise Manager to modify pfile and then convert to SPFile (2) use a in SQL Plus Lter system statement for modification	(1) Direct modification with Text tool (2) after modifying configuration in Enterprise Manager, export to form
default name	spfile+ The routine name. Ora	init+ routine name. ora actual parameter file Init.ora
default path	oracle/ora90/database/	Oracle/ora90/database/init.ora in oracle/admin/database routine name/pfile/
start order	SPf Ile precedence over pfile	pfile below spfile