Common configurations of oracle init. ora

Common configurations of oracle init. ora db_name = "51cto" indicates a DATABASE identifier, which corresponds to the name specified in the create database statement. Instance_name = 51cto uniquely identifies a data warehouse routine when multiple routines use the same service name. INSTANCE_NAME should not be confused with SID. It is actually the unique identifier of each routine that shares memory on a host. Service_names = 51cto is the service name specified by the Net8 listener for identifying a service (for example, a specific database in a replication environment. If the service does not have a domain, the DB_DOMAIN parameter is appended. Control_files = ("/opt/apps/oracle/oradata/51cto/control01.ctl", "/opt/apps/oracle/oradata/51cto/control02.ctl ", "/opt/apps/oracle/oradata/51cto/control03.ctl") open_cursors = 320 library high-speed cache specifies the maximum number of cursors (Environment regions) that a session can open at a time, in addition, the PL/SQL cursor cache size for PL/SQL is limited to avoid re-syntax analysis when you execute the statement again. Set this value to high enough to prevent the application from exhausting open cursors. Max_enabled_roles = 32 db_block_buffers = 5120 Number of Oracle blocks in the cache and I/O buffer. This parameter will significantly affect the total SGA size of a routine. Shard_pool_size = 75497472 large_pool_size = 15728640 pool -- specify the Allocation Heap of the large storage pool, which can be used by multi-thread servers (MTS) used as the session memory, as the message buffer for parallel execution, and as the disk I/O buffer for RMAN backup and recovery. Java_pool_size = 65536, in bytes, specifies the size of the Java storage pool. It is used to store Java methods and class definitions in the shared memory representation, and the Java object transplanted to the Java session space at the end of the call. Log_checkpoint_interval = 10000 indicates the number of OS blocks (rather than database blocks) in the redo log file that must be written before a checkpoint occurs. No matter what the value is, the checkpoint will appear during log switching. A low value can shorten the time required for routine recovery, but may lead to excessive disk operations. Log_checkpoint_timeout = 1800 specifies the maximum time interval (in seconds) from the next checkpoint ). If the time value is set to 0, time-based checkpoints are disabled. A low value can shorten the recovery time of the routine, but may lead to excessive disk operations. processes = 220log_buffer = 8388608, in bytes, indicates that before LGWR writes the redo log entries to the redo log file, the amount of memory used to cache these entries. Redo entries record changes made to database blocks. If the value is greater than 65536, the I/O of the redo log file can be reduced, especially for systems with long transaction processing or massive transaction processing, ** the maximum value is 500 K or 128 K * CPU_COUNT, oracle_trace_enable = true, the largest of the two, starts a default Oracle Trace set until the value is set to NULL again. SQL _trace = false this information is useful for improving performance. Because using SQL to track devices will incur system overhead, you must use TRUE only when you need to optimize the information. Timed_statistics = true collects the timing information of the operating system, which can be used to optimize databases and SQL statements. To avoid overhead caused by request time from the operating system, set this value to zero. Setting this value to TRUE is also useful for viewing the progress of a long operation. Background_dump_dest =/opt/apps/oracle/admin/51cto/bdump specifies the path name (directory or disk) of the trail file written to the background process (LGWR, DBW n, etc.) during Oracle operations ). It also defines the location of the database warning file that records important events and messages. Core_dump_dest =/opt/apps/oracle/admin/51cto/cdump specifies the Directory Name of the core dump location (for UNIX ). Resource_manager_plan = system_plan if this value is specified, the Resource Manager activates all sub-items (sub-plans, commands, and user groups) of the plan and routine ). If this parameter is not specified, the resource manager is disabled, but the alter system command can also be used. User_dump_dest =/opt/apps/oracle/admin/51cto/udump specifies the path name for the directory where the server writes the debug trace file as a user Process Identity. For example, the directory can be set as follows: C:/ORACLE/UTRC on the NT operating system;/oracle/utrc on the UNIX operating system; or DISK $ UR3 on the VMS Operating System: [ORACLE. UTRC]. Db_block_size = 8192 size of an Oracle database block (in bytes ). This value is set when you create a database and cannot be changed later. 1024-65536 (depending on the operating system ). Remote_login_passwordfile = exclusive specifies whether the operating system or a file checks the password of a user with permissions. If it is set to NONE, Oracle ignores the password file. If it is set to EXCLUSIVE, the database password file will be used to verify each user with permissions. If it is set to SHARED, multiple databases will share the SYS and INTERNAL Password File user OS _authent_prefix = "" Use the user's operating system account name and password to verify the user connected to the server. The value of this parameter is connected with the operating system account of each user. To remove the OS account prefix, specify a null value. Job_queue_processes = 4 is only used to copy the environment. It specifies the number of SNP Job Queue processes for each routine (SNP0,... SNP9, SNPA,... SNPZ ). To automatically update a table snapshot or execute a request created by DBMS_JOB, set this parameter to 1 or a greater value. 0 to 36 job_queue_interval = 60 job queue is only used for copying the environment. It specifies the wake-up frequency of each SNPn background process of the routine in seconds. 1 to 3600 distributed_transactions = 10 the maximum number of distributed transactions that a database can participate in at a time. If this value is reduced due to frequent network failures, a large number of pending transactions will be processed. Open_links = 4 specifies the maximum number of connections that can be opened to the remote database at the same time in a session. This value should be equal to or greater than the number of databases referenced in a single SQL statement that references multiple databases. In this way, all databases can be opened to execute this statement. Mts_dispatchers = "(protocol = TCP) (mul = ON) (tick = 15) (pool = (in = 2) (out = 2 )) "Set the number and type of scheduling programs to set the sharing environment of multi-threaded servers. You can specify several options for this parameter. This is an example of a string value: "(PROTOCOL = TCP) (DISPATCHERS = 3 )". Compatible = "8.1.0" allows the use of a new release, while ensuring backward compatibility with previous versions. Sort_area_size = 524288 in bytes, specify the maximum memory used for sorting. After sorting is completed, the rows are returned and the memory is released. Increasing this value can improve the efficiency of large-scale sorting. If the memory size exceeds this limit, a temporary disk segment is used. It is equivalent to the value (minimum value) of 6 database blocks to the value (maximum value) determined by the operating system ). Sort_area_retained_size = 131072, in bytes, specifies the maximum memory size of the user global zone (UGA) retained after a sorting operation is completed. After the last row is extracted from the sorting space, the memory will be released back to UGA rather than to the operating system.