Soccer and Oracle Series (1): 32 Way Princes soldiers of, Oracle32 Process Alliance Group A bigger picture of the Brazilian Smon process

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.

Clue One: Road Princes soldiers of, oracle32 Process Federation

Group A bigger picture of the Brazilian Smon process

Brazil has always been active in world football as a strong man, and it is as important as the Smon process in Oracle, and once the instance crashes, it needs to be restored by Smon. If one day football lonely (should not appear, haha), it is necessary to have a football kingdom called Brazil to the tide!

Look at the partners in the group with Brazil, Croatia is like a temporary table space, Europe came to America, haha, everyone knows ...

Mexico is like rolling back the table space so that we can remember the historical performance of the North American team, just as the rollback segment maintains read consistency.

Finally left Cameroon, this tumultuous team, have to say that the country's turmoil will have some impact on the team, but also we are more fortunate that the unrest can not eliminate a country's love for football, but after all, the example is inferior to other teams, compare you to the free space between the instances, hope that one day to re-use up, Become strong.

Smon Process:Brief Description:

An important background process that is responsible for recovering the instance when it starts. It also cleans up temporary segments that are no longer being used. In a parallel server environment, the process restores the instance of the failure and the failed CPU. Smon will consume a lot of CPU. Smon will be periodically woken up and executed to deal with things like the following, this is the 2014 World Cup host country-Brazil, football is strong, but at the same time the World Cup planning is busy, O (∩_∩) o haha ~

Work Refinement:1. Clean up temporary table space

Example: When an index is established, the extents assigned to the index during creation are identified as temporary. If the CREATE index session is abnormally interrupted for some reason, Smon will be responsible for cleanup. The temporary extents created by other operations are also handled by Smon.

2. Clean the rollback section

Smon automatically shrinks the rollback segment to its optimal size (provided that it has been set).

3. Merge free space

For example, if you are using a data dictionary to manage tablespaces, Smon will be responsible for combining those extent that are spatially in the tablespace with a large free extension (provided that the default pctincrease is set to a non-zero storage clause, the dictionary manages the tablespace).

4. Restore the unavailable file transaction to an activity

For example, assume that if a file might already be unavailable or not mounted on disk. Smon will restore it. This is similar to the Qicu period. The file cannot be used for recovery, Smon recovers a failed transaction that was skipped during instance recovery.

5. Instance recovery of RAC fault node

For example: In a clustered environment, when a node instance crashes, other points in the cluster will open the Redo log file for the failed instance and perform all data recovery for the failed instance.

6. Cleaning obj$

Smon will be responsible for deleting the process that is not in the desired row.

7. Offline rollback segment

When a rollback segment of an active transaction needs to be taken offline or unavailable in the actual application, the rollback segment is not really offline, it is marked as "Offline", and in the background process, Smon will periodically make it truly offline until it is complete.

[08:07:[email protected]] $ps-ef|grep ' ora_.* '; --You can see what the running process is

--Process naming format: Ora_ Process Specific Name _ instance name
Oracle 3075 1 0 08:06? 00:00:00 Ora_pmon_prod
Oracle 3077 1 0 08:06? 00:00:00 Ora_vktm_prod
Oracle 3081 1 0 08:06? 00:00:00 Ora_gen0_prod
Oracle 3083 1 0 08:06? 00:00:00 Ora_diag_prod
Oracle 3085 1 0 08:06? 00:00:00 Ora_dbrm_prod
Oracle 3087 1 0 08:06? 00:00:00 Ora_psp0_prod
Oracle 3089 1 0 08:06? 00:00:00 Ora_dia0_prod
Oracle 3091 1 0 08:06? 00:00:00 Ora_mman_prod
Oracle 3093 1 0 08:06? 00:00:00 Ora_dbw0_prod
Oracle 3095 1 0 08:06? 00:00:00 Ora_lgwr_prod
Oracle 3097 1 0 08:06? 00:00:00 Ora_ckpt_prod
Oracle 3099 1 0 08:06? 00:00:00 Ora_smon_prod
Oracle 3101 1 0 08:06? 00:00:00 Ora_reco_prod
Oracle 3103 1 1 08:06? 00:00:00 Ora_mmon_prod
Oracle 3105 1 0 08:06? 00:00:00 Ora_mmnl_prod
Oracle 3107 1 0 08:06? 00:00:00 Ora_d000_prod
Oracle 3109 1 0 08:06? 00:00:00 Ora_d001_prod
Oracle 3111 1 0 08:06? 00:00:00 Ora_d002_prod
Oracle 3113 1 0 08:06? 00:00:00 Ora_s000_prod
Oracle 3115 1 0 08:06? 00:00:00 Ora_s001_prod
Oracle 3117 1 0 08:06? 00:00:00 Ora_s002_prod
Oracle 3119 1 0 08:06? 00:00:00 Ora_s003_prod
Oracle 3121 1 0 08:06? 00:00:00 Ora_s004_prod
Oracle 3123 1 0 08:06? 00:00:00 Ora_s005_prod
Oracle 3125 1 0 08:06? 00:00:00 Ora_s006_prod
Oracle 3127 1 0 08:06? 00:00:00 Ora_s007_prod
Oracle 3129 1 0 08:06? 00:00:00 Ora_s008_prod
Oracle 3131 1 0 08:06? 00:00:00 Ora_s009_prod
Oracle 3139 1 0 08:06? 00:00:00 Ora_qmnc_prod
Oracle 3153 1 1 08:06? 00:00:00 Ora_cjq0_prod
Oracle 3183 1 10 08:06? 00:00:02 Ora_j000_prod
Oracle 3185 1 0 08:06? 00:00:00 Ora_j001_prod
Oracle 3189 1 2 08:06? 00:00:00 Ora_j003_prod
Oracle 3191 1 0 08:06? 00:00:00 Ora_j004_prod
Oracle 3193 1 0 08:06? 00:00:00 Ora_q000_prod
Oracle 3195 1 0 08:06? 00:00:00 Ora_q001_prod

The idea of playing soccer with Oracle was first because of personal interest and, secondly, because it was more appropriate because the sport was the largest and most participatory sport in competitive sports, with a vivid correspondence to Oracle's sprawling knowledge system.

This series will not be based on the narrative of time or plot, but by the author randomly generated association, in a free writing style presented in front of everyone.