In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-26 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Servers >
Share
Shulou(Shulou.com)05/31 Report--
The knowledge of this article "how to solve the log buffer log buffer problem" is not quite understood by most people, so the editor summarizes the following, detailed content, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "how to solve the log buffer log buffer problem" article.
Log buffer (log buffer)
Change vector is a modification applied to something; executing DML statements
Generates change vectors applied to data.
The log buffer is a small, short-term change vectors place for changes.
Log files are used to ensure that data in the database is not lost. The change vectors applied to the block will write
Put it in the log file. The session generates log information to the log buffer, and the log information is written to the day through the background process LGWR
It's in the history file. Because the redo log information is written to the redo log file almost in real time, it is better than the normal oracle
The memory structure component is small. So the buffer doesn't need to be very large, just accept the recommended size (server-based
Recommended value for the number of CPU). However, you cannot set the redo log buffer to be less than the default value, in which case the oracle will
The setting of action is the default value. Tuning also starts from the default value. The size of the log buffer is operated by the system
The duration of the line is not adjustable unless the system is restarted. Perhaps at the peak of DML operations, log information is generated faster than
The speed of LGWR, which is the DML operation will be paused for milliseconds. The operation speed of DML cannot be faster than the speed of LGWR writing redo log.
(The process of flushing the log buffer to disk is one of the ultimate
Bottlenecks in the Oracle architecture.)
If redo generation is the limiting factor in a database's performance, the only
Option is to go to RAC. In a RAC database, each instance has its own log buffer
And its own LGWR. This is the only way to parallelize writing redo data to disk.
The size of the log buffer is static, fixed at instance startup. It cannot be
Automatically managed.
View log buffer size
SQL > show parameter log_buffer
NAME TYPE VALUE
-
Log_buffer integer 5603328
Note: the conditions for triggering the LGWR write log buffer are:
A session executes a commit.
The log information reaches 1/3 of the log buffer size, or the log information reaches 1mb.
DBWR intends to write dirty data (no commit data) in the data buffer.
SQL > alter system set log_buffer=5m scope=spfile
Alter system set log_buffer=5m scope=spfile
ORA-02095: the specified initialization parameters cannot be modified
Log_buffer cannot be adjusted dynamically. The easiest way is to add a "log_buffer=value" to the init.ora file.
Then restart Oracle with this init.ora (SQL > startup pfile=init.ora)
The above is about the content of this article on "how to solve the log buffer log buffer problem". I believe we all have a certain understanding. I hope the content shared by the editor will be helpful to you. If you want to know more about the relevant knowledge, please follow the industry information channel.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 279
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.