Soccer and Oracle Series (3): Oracle process ranking, World Cup round is about to be fought!

Soccer and Oracle Series (3): Oracle process ranking, World Cup round is about to be fought!

Statement:

This is not a technical document, since a few strokes of Oracle's simple moves, can not endure in front of people show off a few. Pure for the gossip and a few friends of the gag, only for easy with a hint of humor, it technology can also be used to ridicule, but also pretty intriguing.

At the same time in recent months, Oracle knowledge points forgotten a lot, in order to bring back the knowledge point, a bit of inspiration at first glance, in a free form to release it, because I learned not fine, the examples or stories cited in the text, which will inevitably have a far-fetched with technical links, hope everyone haihan. Only a small rookie of the notes, do not take this as a technical article Oh, Pro! I've seen and laughed, just fine.

Welcome to shoot Bricks, this will be the biggest driving force for my growth.

Group A: Smon: Brazil: Bigger picture, King

Smon:system monitor, System Monitor, focuses on system-level operations, not individual processes, focusing on recovery of power, as well as cleanup of temporary table spaces, cleanup of rollback table spaces, and consolidation of free space. See Click to open the link: Soccer and Oracle Series (1): 32 Way Princes soldiers of, Oracle32 Process Alliance Group A bigger picture of the Brazilian Smon process

King, there is no doubt, waiting for you to control the World Cup, to prove, what is called the Football kingdom.

Group B: Pmon: Netherlands: Ears, wait for the move

pmon:processes monitor, Process Monitor, performs some update statements, the process crashes when uncommitted, and Pmon automatically rolls back the operation without manually performing a rollback operation. Not only that, Pmon can also intervene in the background process, such as Reco exception failure, Pmon will restart the reco process. Also, if you encounter a LGWR process failure, Pmon will make an action to terminate the instance to prevent data confusion.

The Dutch's performance, let the fans rejoice, in the game with Australia, the situation changed Mo, a penalty kick angered the Dutch, every time after the goal, will self-regulation, restart the offensive process, go! Go! Go!

Group C: lckn: Colombia: Strong South America, uniting on American soil

The LCKN process, used for RAC databases, can have up to 10 processes for blocking between instances.

Think of this South American powerhouse, with the strength to suppress the strong from Europe, Asia, Africa, as the example of the blockade, this is the LCKN process.

Group D: RECO: Costa Rica: three-line ring fastening, not accidental, is a staged victory

The recovery of the distributed database, the recovery of the interrupted database, is suitable for two-phase submission scenario. In the face of multiple databases 1, 2, 3, an application across three databases, in the initiation process requires 1, 2, 3 libraries are committed successfully, the transaction will succeed, as long as there is a failure, you must roll back all.

Look at the dark Horse of this World Cup, in fact, the dark horse can not say the end of the growth and strength of Costa Rica, which is experienced by the number of generations of players to achieve the current strength of this. From the back to the midfield to the striker, the players are doing well. The best to the performance of the central defender, whether you are the little King of South America, or the blue ocean in Europe, in Costa Rica's robust three line, there is no opportunity to find, this is the success of three lines, three database success, then it will win before you can submit success.

Group E: CKPT: France: Gorgeous turn between, Rooster needs to prove himself, to the worldFootballhow important it is .

Note A parameter: Fast_start_mttr_target, which is used to control ckpt, to trigger DBWR to write data from the data buffer to disk. The more frequent the ckpt, the more frequent the DBWR, the more frequent the DBWR, the more often it is not able to reflect the bulk of the characteristics, performance is the lower, but there is one advantage is that the database abnormal recovery will be faster.

Waiting to return to the peak, France needs to use the magnificent dance steps to turn back. Which of the heroes will trigger all this change? Is the state of Benzema, or Matuidi, Sissoko? Or a Valbuena? Let's wait and see who triggers it.

Group F: DBWR: Argentina: Faith and culture, waiting for the return of the King

DBWR used to write data from the data buffer to disk, the process and ckpt mutually reinforcing, because it is ckpt to facilitate DBWR to write, but DBWR is also closely related to LGWR, because DBWR want to write data buffer data to disk, The LGWR must be notified that the log buffer has been written to disk before it can be executed.

Have to mention the Plum King, cannot but say Argentina, how many fans of the biggest wish, is how to look forward to "Argentina do not cry for me" do not ring again. Looking forward to a glorious, looking forward to this expensive team in South America to surprise fans. Argentina's football culture, and its influence over generations of football-loving sports, is ingrained, from Maradona's saga, to Riquelme's Hale, to the now-leading Lionel Messi, with too many names and too many images to come before us, so heavyweight teams play the DBWR absolute central role. Think of the database without data operation, this will become what, and then think about the World Cup if not Argentina, what will become, is not the main dish of the top feast, is not also known as a feast? Looking forward to Argentina going farther ...

Group G: LGWR: Germany: The Immortal Germanic, never cease

LGWR is the log buffer data from the memory to write to the disk redo file, complete database object creation, update data, such as the operation of the record, this redo log can be used to do database recovery.

Rules of LGWR:

1, every 3 seconds, LGWR run once

2. Any commit triggers LGWR to run once

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

4, log buffer full One-third or record full 1MB, triggering LGWR run once

5, online log file switch, trigger LGWR run Once

Hard-working Germans, like the busiest process-DBWR, are always running tirelessly, this is the tough German style of football. And whenever the score behind, the player is violated, the opponent momentum is Sheng, will re-ignite the spirit, the tenacious performance of the incisively and vividly, this is worthy of respect for the Germanic chariot! As DBWR, any decision to race the trajectory, will be keenly captured, to make the fastest response to the opponent to complete the most deadly blow. Of course, for a database, the only thing to do is to write the log to disk, to maximize the security of the data to be maintained.

Group H: ARCH: Belgium: European Red Devils, will defend Europe's strength

The arch function is to trigger the arch process to transfer the log file, copy it, and save it as an archive log file when the LGWR write log writes to overwrite the rewrite. The archive area is typically set up specifically to hold archived logs.

Red Devils Belgium like the archive process, its style is as if the log is full, the need to transfer the change tactics of the youth guards, whenever the need to reverse the situation, there will be a turn-around hero. Red Devil's performance in Europe commendable, came to the world arena, we look forward to bring more surprises to the world. In the South American arena, the European powers did not fully demonstrate their strength, looking forward to the Reds tonight, as the archive log process, the former European brothers did not enter the state of the performance of the cover, bringing a new European forces, looking forward from the moment, the European law of no minnows re-confirmed. The geographical advantage of having an adult South America does reflect a lot, without Europe's frequent and high-density events, coupled with a more adaptable climate environment. It's all about the American side, but none of this is going to dominate the final outcome, only the most important one. Looking forward to the second round of the last two games than sweep, the European team renewed vitality.