`

My view on DBA

 
阅读更多

<!-- [if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:DrawingGridVerticalSpacing>7.8 磅</w:DrawingGridVerticalSpacing> <w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEvery> <w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:SpaceForUL/> <w:BalanceSingleByteDoubleByteWidth/> <w:DoNotLeaveBackslashAlone/> <w:ULTrailSpace/> <w:DoNotExpandShiftReturn/> <w:AdjustLineHeightInTable/> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:UseFELayout/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!-- [if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!-- [if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]-->

A DBA should know the database theory deeply.

Knowing much more is less useful than knowing some things deeply.

Mastering the fundamental knowledge is very important.

I interviewed some of DBA candidate. Some of them said they had many years’ experience but when asked what is instance what is database they can not tell clearly. It is hard to image that they said they were familiar with the RAC.

Every DBA has the boundary of database knowledge even though he had learned all the knowledge. Their memory is limited, the knowledge will be forgotten if they have no chance to be applied in the real situation and it is almost impossible to have the chance to apply all in the real environment.

So I never think it is fair to ask a DBA how to set an implicit parameter in the dbms_repair package. What can be proven even he did know it? But instead that you can resolve the issue if you understand what is rootcause correctly even you do not know how to take the specific actions.

Surfing the details from the internet is possible to give you right next steps.

The OS knowledge and Cluster knowledge is very useful for a DBA.

These skill sets help you more qualified to the current or future position. Anyone who has worked as a DBA would know that the Database is usually "guilty until proven innocent." Every performance problem gets blamed on the database regardless of its true source cause or not.
So it is necessary for a DBA to know enough
OS and network knowledge. Especially to combine them with database knowledge to solve the database performance problems or sometimes OS or network problems.

Does it sound scared?

Too many things need you to learn?

I do not think so.

The most important is to learn the basic knowledge then learn to what is it.

We need not to focus on how to do it too much.

As long as what is it what can it bring to us.

When the new releases come we should try to know what is it then when we need to use it we can find the details about it.

We can keep up with it if we only focus what it is.

Reaching every detail is wasting you valuable time unless you can find chance to apply it.

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics