Which initialization parameters most affect Oracle system performance ____oracle

Normal 0 7.8 lb 0 2 false false en-US ZH-CN x-none MicrosoftInternetExplorer4/* Style definitions/table. msonormaltable {mso-style-name: plain form; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; Mso-style-qformat:yes; Mso-style-parent: ""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; Mso-pagination:widow-orphan; font-size:10.0pt; Font-family: "Times New Roman", "Serif";} What is SGA (System global Area)

1. The system global Area (SGA) is a control information memory segment assigned to Oracle that contains an Oracle instance database.
Mainly includes the database cache cache (buffer cache),
Replay log cache (the redo log buffer)
Shared Pool,
Data dictionary caching (the dictionary cache) and other information. Db_block_buffers

1, data high-speed buffer
2, access to the data are placed in this piece of memory area, the larger the parameter, Oracle in memory to find the same data, the greater the likelihood, that is, speed up the query speed.
3, db_block_buffers to block as a unit, if db_block_size=2k, db_block_buffers=3200, then occupy the memory =3200*2k=6400k. Share_pool_size

1. SQL Shared buffer pool
2, this parameter is the cache of the library cache and the data dictionary. Log_buffer

1. Replay Log Buffer Sort_area_size

1, sorting area processes

1, simultaneous connection of the number of processes Global_names

1. If "Database link name" and the "database" to which it is connected have the same name, set global_names = TRUE,
Otherwise, set global_names = FALSE db_block_size

1, database block size
2, the Oracle default block is 2KB, too small, because if we have a 8KB of data, the 2KB block database to read 4 times to read,
and 8KB block of database as long as 1 read, greatly reduced I/O operation.
3, after the completion of the database installation, you can no longer change the value of the db_block_size, you can only re-establish the database
And when you build a library, you choose to install the database manually. Open_links

1, at the same time open the number of links dml_locks

1, the user can set the maximum number of locks on the table
2. If three users modify 6 tables, 18 DML locks are required to achieve parallel operations, if the set dml_locks is not large enough, the operation will be interrupted, you can use the size of your application and the maximum number of users in parallel to estimate the value of the system needed dml_locks, However, the size of the value of the database does not affect the other performance, so it is generally set to a large, far more than the actual value can be achieved, if the system is running in the event of a frequent table lock, you should consider increasing the value. Open_cursors

1, open the number of cursors
2. This parameter can be owned by each user process at the same time, and the maximum value of this parameter varies according to the operating system.
3. When you create a composite view that contains many tables, the view creation is unsuccessful if this parameter is small. Dbwr_io_slaves

1, background write process number