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 |