Soccer and Oracle Series (3): Oracle Process rankings, World Cup second round of battle come!

Source: Internet
Author: User

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


Statement:

This is not a technical document, since you have learned a few tricks of Oracle simple moves. Can not endure in front of people show off a few. Pure for the gossip and a few friends of the gag. Just for the ease with a hint of humor, it technology can also be used to ridicule, it is quite intriguing.

At the same time in recent months the Oracle Knowledge points have forgotten a lot, in order to reproduce the knowledge point. A bit of inspiration at first glance. Publish it in a free form. Because I am not a fine apprentice. Examples or stories listed in the article. There will certainly be a far-fetched link with the technical, hope everyone haihan.

Just a little rookie's notes. Don't take this as a technical article Oh, Kiss! 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

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvahvhbmd5yw5sb25n/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/ Dissolve/70/gravity/southeast ">

Smon:system monitor, System Monitor, is concerned with system-level operations, rather than individual processes, focusing on the recovery of strength, as well as the cleanup of temporary table space, cleaning up the rollback table space, merging spare space, and so on.

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 that waiting for you to control this World Cup, to prove to the Earth, what is called the Football kingdom.


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

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvahvhbmd5yw5sb25n/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/ Dissolve/70/gravity/southeast ">

pmon:processes monitor, Process Monitor, runs some update statements. The process crashed when it was not committed. Pmon will roll back the operation on its own initiative, without the need to manually run the 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, suppose that you encounter a LGWR process failure. Pmon will make an action to terminate the instance. Prevent data confusion.

This performance of the Dutch. Let the fans cheer, in the game with Australia, the situation changed Mo, a penalty to anger the Dutch, every time after the goal, will self-regulation, restart the offensive process, go!

Go! Go


Group C: lckn: Colombia: Strong South America. Unite in the Land of America.


LCKN process for the RAC database. A maximum of 10 processes can be used. Used for blocking between instances.

Think of this South American powerhouse, with the strength to restrain the strong from Europe, Asia, Africa. Just like blocking instances, this is the LCKN process.


Group D: RECO: Costa Rica: Three line loop fastening, not accidental. It's a staged victory.

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvahvhbmd5yw5sb25n/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/ Dissolve/70/gravity/southeast ">

The recovery of the distributed database, the recovery of the interrupted database, is suitable for two-phase submission scenario. such as facing multiple databases 1, 2, 3. An app spans three of databases. In the process of initiating, 1, 2, 3 libraries are required to commit successfully, and the transaction will succeed. Just have to have a failure. All rollbacks must be rolled back.

Look at the dark Horse of this World Cup, in fact, the word "black horse" can not say the end of Costa Rica's growth and strength, this is how many generations of players to achieve the current strength of this. From the back to the midfield to the striker. The performance of the players is commendable. The best of all is the performance of the centre-back, whether you're a South American or a little king. Or the blue Ocean of Europe. On the stable three lines of Costa Rica. There is no chance, this is the success of three lines. Success of three databases. After that, we will win. Talent enough to submit success.


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

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvahvhbmd5yw5sb25n/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/ Dissolve/70/gravity/southeast ">

Note One of the parameters: Fast_start_mttr_target. Use it to control ckpt, which triggers DBWR to write data from the data buffer to disk. Ckpt run more frequently, DBWR more frequent, DBWR more often that is, the more can not reflect the characteristics of the bulk, performance is the lower, but there is a strong point is that the database abnormal recovery will be faster.

Waiting to return to the peak, France needs to use the magnificent dance moves again. 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 triggered it.


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

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvahvhbmd5yw5sb25n/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/ Dissolve/70/gravity/southeast ">

DBWR is used to write data from a data buffer to a disk. The process and the ckpt complement each other, as Ckpt contributed to DBWR's writing. Just DBWR is also closely related to LGWR, because DBWR want to write data buffer data to disk, you must notify LGWR before the log buffer write to disk action. To run.

Had to mention the Plum King. 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, are deeply rooted, from the legend of Maradona. To Riquelme's Hale. To the now leading Messi, there are too many names, too many pictures appear in front of us, so the heavyweight team play a DBWR absolutely central role. Think of the database without data operation, this will become what, and then think about the World Cup hypothesis without 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 further ...

。。。


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 exception recovery.

Rules of LGWR:

1, every 3 seconds, LGWR execute once

2, no matter what commit trigger LGWR execution once

3, DBWR to write data from the data cache to disk. Trigger LGWR to execute once

4, log buffer full three points in one or record full 1MB, triggering LGWR to execute once

5, online log file switching, triggering LGWR execution once

Hard-working Germans. Just like the busiest process-LGWR. The whole field is always running tirelessly. This is the tough German style of football. And when the score is backward, the player is violated, the opponent momentum is in the moment. Will once again ignite the morale, the tenacious performance of the incisively and vividly, this is worthy of respect for the Germanic chariot!

Like LGWR. No matter what one determines the trajectory of the race, it will be keenly captured. Make the quickest response. The most deadly blow to the opponent.

Of course, for a database. Do is to write the logs to disk, to the maximum possible maintenance of data security.


Group H: ARCH: Belgium: European Red Devils. Will defend Europe's strength.

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvahvhbmd5yw5sb25n/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/ Dissolve/70/gravity/southeast ">

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 is just like the archive process. Its style is like when the log is full. The need to shift the tactics of youth guards, whenever the need to reverse the situation. There will be a hero who can get the tide.

The Red Devils ' watch is now in Europe, in the world. We look forward to bringing many other surprises to the world.

In South America, the European powers have failed to fully demonstrate their strength and look forward to tonight's Red Devils, just as the archive log process. Cover the performance of the former European brothers without entering the state. Bring a whole new European power, and look forward to the moment when Europe's minnows law is once again 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 be the result of the final game, only someone and the most important.

Looking forward to the second round of the last two games. The European team is once again alive.


Copyright notice: This article blog original article. Blogs, without consent, may not be reproduced.

Soccer and Oracle Series (3): Oracle Process rankings, World Cup second round of battle come!

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.