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 four disks before reading,
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 four disks before reading,
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.