Football and oracle series (3): oracle process rankings, the World Cup round is about to fight!

Football and oracle series (3): oracle process rankings, the World Cup round is about to fight!

Statement:

This is not a technical document. Since I have learned a few tricks about oracle, I cannot afford to sell it to anyone. Just after a meal, I joined several friends in the library. It is just a bit humorous and it can also be used to make fun of others.

At the same time, I have forgotten a lot of oracle knowledge points in recent months. In order to reproduce the knowledge points, I am inspired to publish them in a free form, the examples or stories listed in this article are bound to be far-fetched in terms of technical connection. It's just a note from cainiao. Don't use it as a technical article! I have read and laughed.

Welcome to shoot bricks. This will be the biggest motivation for my growth.

Group A: SMON: Brazil: big picture, King

SMON: system monitor, system monitor, focuses on system-level operations, rather than individual processes, and focuses on the recovery of strength, it also serves to clear temporary tablespace, rollback segment tablespace, and merge idle space. For details, see the open link: football and oracle series (1): 32-way zhoudianbing, overall view of the Brazilian SMON process in group A of oracle32 process Alliance

The king, there is no doubt, waiting for you to control the World Cup and prove to the world what is football kingdom.

Group B: PMON: Netherlands: listening and listening

PMON: processes monitor, process monitor. When some update statements are executed and the process crashes when not submitted, pmon automatically rolls back the operation without manual rollback. In addition, pmon can also intervene in background processes. For example, if a reco exception fails, pmon will restart the reco process. For example, if the lgwr process fails, pmon will terminate the instance to prevent data disorder.

The Dutch fans are excited for their current performance. In the competition with Australia, the situation is unpredictable. A penalty is a record that angered the Dutch. Every time they lose the ball, they will adjust themselves and restart the attack process. go! Go! Go!

Group C: LCKn: MBIA: strong South America, united in the Americas

The LCKn process, used for the RAC database, can have up to 10 processes, used for blocking between instances.

Looking at this strong South America tour, we are using the power to suppress the various strong players from Europe, Asia, and Africa. Just like blocking instances, this is the lckn process.

Group D: RECO: Costa Rica: three-wire ring closely linked, not by accident, is a staged victory

The recovery of distributed databases and the recovery of interrupted databases are suitable for two-phase commit application scenarios. If there are multiple databases 1, 2, 3, and an application spans three databases, the transaction will succeed only when the databases 1, 2, and 3 are successfully committed during the initiation process, if one fails, all rollback is required.

Looking at the dark horse of the World Cup, we can't say that we have finished the growth and strength of Costa Rica. This is how many generations of players have worked hard to achieve the current strength. From the back guard to the midfield, to the forward, the player's performance is remarkable. The best thing is the performance of the center guard. Whether you are the little king of South America or the blue ocean in Europe, you cannot find a chance on the three stable online in Costa Rica, this is the success of the three lines. After the three databases are successful, they will be successfully submitted.

Group E: CKPT: France: the gorgeous turning room, the rooster needs to prove itself, how important it is to world football

Note a parameter: FAST_START_MTTR_TARGET, which is used to control ckpt, used to trigger DBWR to write data from the data buffer to the disk. The more frequently ckpt is executed, the more frequently dbwr is, the more frequently dbwr is, the less batch features are displayed, and the lower the performance is, however, one advantage is that the faster the database recovers from exceptions.

Waiting to return to the peak, France needs to turn around again with the gorgeous dance steps. Which hero will trigger all these changes? Is it benzema in a prosperous state, mattuidi, or Sissoko? Or valbuena? We will wait and see who triggered it.

Group F: DBWR: Argentina: faith and culture, waiting for the return of the king

DBWR is used to write data from the data cache area to the disk. This process and ckpt complement each other because ckpt facilitates dbwr writing. However, dbwr is also closely related to lgwr, when dbwr wants to write data in the data cache area to a disk, it must notify lgwr to write the log buffer to the disk before execution.

I have to mention Mei Tianwang. Argentina is the greatest wish of many fans. I hope that "Don't cry for me in Argentina" should not be heard again. We look forward to a great honor and hope that this expensive team will surprise fans in South America. The football culture of Argentina and its influence on generations who love football are all deep-rooted, from the legend of Maradona, to the toughness of rickermei, to the now-leading Messi, there are too many names, too many pictures come to us, and such a heavyweight team plays the absolute core role of DBWR. Think about what the database will become if there is no data, and think about what it will become if there is no Argentina in the World Cup. Is there a lack of top-level feast for a single main course, can it also be called a feast? Looking forward to going further in Argentina ......

Group G: LGWR: Germany: the German that cannot die, never stop

LGWR writes the data in the log cache area from the memory to the REDO file on the disk, and records the operation processes such as creating and updating database objects, this redo log can be used for database exception recovery.

LGWR rules:

1. Run LGWR once every 3 seconds.

2. Any COMMIT triggers LGWR to run once.

3. DBWR writes data from the data cache to the disk, triggering LGWR to run once

4. When the log buffer is 1/3 full or the record is 1 MB full, LGWR is triggered once.

5. Online Log File switching, triggering LGWR to run once

The industrious Germans are like DBWR, the busiest process. The audience is always running tirelessly. This is a tough german style. Every time the score lags behind, the players are attacked, and the opponent's momentum is flourishing, the fighting spirit will be re-ignited and the tenacious performance will be shown to the fullest. This is a respectable German chariot! Like DBWR, any decision on the game track will be keenly captured and the fastest response will be made to the opponent's most fatal blow. Of course, for databases, logs are written to disks to maximize data security.

Group H: ARCH: Belgium: European red devils, defending the strength of Europe

ARCH is used to trigger the ARCH process to transfer the log file, copy it, and save it as an archive log file when LGWR writes logs to overwrite and overwrite logs. Generally, a dedicated archiving area is set up to store archived logs.

As with the archiving process, the red devils in Belgium are like the young guards who need to transfer tactics After logs are full. Whenever the situation needs to be reversed, there will be a hero. The performance of the red devils is remarkable in Europe and we are looking forward to bringing more surprises to the world. In South America, Europe's strong players have not fully demonstrated their own strength. They are looking forward to the red devils tonight. Just like the archiving log process, they will overwrite the performance of their European brothers who have not yet entered the status, bringing a brand new European power, we hope that from now on, the law of Europe with no weak travel will be confirmed again. The regional advantages of adult South America do not show much. There is no frequent and high-density competition in Europe, coupled with a more adaptive climate. Tiandi lidu tends to be a team in the Americas, but it cannot be the dominant choice in deciding the final result. Only people and people are the most important. Looking forward to the second round of the last two matches, the European team will be born again.