What are the initialization parameters related to Oracle performance?

Source: Internet
Author: User

Q: What are the initialization parameters related to Oracle performance?
A: The initialization parameters that affect Oracle system performance are as follows:

SGA (system global zone)
The system global zone (SGA) is a memory segment allocated to the database containing an Oracle instance. It mainly includes the database buffer cache, the redo log buffer, the shared pool, and the data dictionary cache) and other information.

Db_block_buffers (Data High-speed buffer zone)
The accessed data is stored in this memory area. The larger the parameter, the more likely Oracle will find the same data in the memory, which accelerates the query speed. Db_block_buffers is in block units. If DB_BLOCK_SIZE = 2 K and db_block_buffers = 3200, the occupied memory is 3200*2 K = 6400 K.

Pai_pool_size (SQL shared buffer pool)
This parameter is a high-speed cache for databases and data dictionaries.

Log_buffer (replaying the log buffer)

Sort_area_size (sorting area)

Processes (number of processes simultaneously connected)

Global_names (if the "Database Link name" has the same name as the "Database" to be connected to, set global_names = TRUE; otherwise, set global_names = FALSE)

Db_block_size (Database block size)
The default Oracle block size is 2 kb, which is too small, because if we have an 8 KB data, the 2 kb database needs to read the disk four times before reading it,
I/O operations are greatly reduced as long as the 8 KB database is read once.
After the database is installed, you can no longer change the value of db_block_size. You can only create a new database. When creating a database, you must manually install the database.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.