RE: OPS DBA work (was dumb question)

From: Hallas John <John.Hallas_at_btcellnet.net>
Date: Tue, 05 Feb 2002 05:48:53 -0800
Message-ID: <F001.004060DC.20020205053521@fatcity.com>

Bjorn,

I
don't have any issues with what you say - in fact it really agrees mostly with what I stated. You have added 2 important factors though, better application knowledge and use of raw file systems.
I use
Compaq Tru64 so that does not require raw files systems but other o/s certainly do.
<SPAN

class=800233013-05022002>
I
think you were a bit unfair to suggest that I meant you
only needed to check a few init.ora parameters out ( 'it is far more than knowing the GC_ parameters' ). I am fully aware of the need to look at freelists and freelist groups - I encompassed that in my statement

'Management and tuning of internode communication. Specifically reducing the level of pinging - use of GC% init.ora variables'
<FONT

face=Arial>
<FONT

face=Arial>Anyway
I don't think we are that far away from each other
<FONT

face=Arial>
<FONT

face=Arial>Regards
<FONT

face=Arial>
<FONT

face=Arial>John
<FONT

size=2>
<SPAN

class=800233013-05022002>
<SPAN

class=800233013-05022002>
<SPAN

class=800233013-05022002> -----Original Message-----From: Bjørn Engsig [mailto:bengsig_at_yahoo.com]Sent: 05 February 20021 2:25To: Multiple recipients of list ORACLE-LSubject: Re: OPS DBA work (was dumb question)
With the caveat, that I am a consultant and not actually a DBA, I would argue very strongly, that the OPS DBA needs quite some extra understanding, knowledge and experience compared to one managing a single instance Oracle. In particular:- Performance problems, primarily due to poor application design/development, that are seen in single instance are likely to be one to two orders of magnitude worse in OPS. Hence, the DBA needs a much better application understanding.- There are Oracle features (e.g. free list groups) that must be used with OPS and which rarely are needed single instance.- Recovery scenarios are more complex- You must use raw devices (except on platforms with inhertance from Digital Corp), which can add complexity- A frequent requirement of OPS systems is better uptimes than for single instance, which is a very non-trivial task. The whole stack is far more complex, and even though the possibility to have two or more independent nodes sound really great in theory, the practical assurance, that they are in fact completely independent is difficult. And if they aren't independent, they are likely to have worse uptimes than the single instance! - And I probably forgot something, so it is far more than knowing the GC_ parameters, which, BTW, by itself isn't that simple!- Also, BTW, note that except for a few things, RAC doesn't make your life easier than OPS!Thanks, Bjørn.Shreeni wrote:

<O:SMARTTAGTYPEN
amespaceuri="urn:schemas-microsoft-com:office:smarttags" name="date">

<!---style-name:"Table Normal";

	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	mso-style-noshow:yes;
	mso-style-parent:"";
	mso-padding-alt:0in 5.4pt 0in 5.4pt;
	mso-para-margin:0in;
	mso-para-margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.0pt;
	font-family:"Times New Roman";}

Hi
 John,

 Thx for
 the input. I really appreciate it. I was just kind of stumped when I was asked not once but several times and places, to point out the diff between an OPS DBA and a "regular" DBA that I am.
 Thanks
 again

 Shreeni
 Shreenivasa
 Raoe-Z
 ing Technologies,
 Inc..41-43 Beekman Street, 3rd FloorNew York, NY 10038.Tel: (212)233-9861 xt.241Fax:
 (212)233-9862Cell:(917)861-4966<A
 href="mailto:lsama_at_e-zingtech.com">lsama_at_e-zingtech.com
 <FONT color=#000000

    size=2>*****************************************Your IT Solutions

Provider*********** *** <A href="http://www.e-zingtech.com/" target=_blank><FONT

    size=2>http://www.e-zingtech.com <FONT 
    size=2>  <FONT color=#000000 
    size=2>*******Under Bill s.1618 Title III passed by the 105th U.S.

Congress this mail cannot be considered spam as long as we include contact information and a remove link for removal from our mailing list. To be removed from our mailing list reply with remove in the subject heading and your email address in the body. Include complete address and/or domain to be

    removed.--------------------------------------------
    
      <FONT 
      face=Tahoma size=2>-----Original Message-----From: <A
      class=moz-txt-link-abbreviated 
      href="mailto:root_at_fatcity.com">root_at_fatcity.com [<A 
      class=moz-txt-link-freetext 
      href="mailto:root_at_fatcity.com">mailto:root_at_fatcity.com] On Behalf 
      Of Hallas JohnSent: Monday, February 04, 2002 4:05 
      AMTo: Multiple recipients of list ORACLE-LSubject: 
      OPS DBA work (was dumb question)
      <SPAN 
      class=506365808-04022002>Shreeni,
       
      <SPAN 
      class=506365808-04022002>The mangement of a OPS system does not require 
      any extra skills or facilities. Areas that are different or need more
      attention from a standalone instance include the following 
      :
       
      <SPAN 
      class=506365808-04022002>Management and tuning of internode communication. 
      Specifically reducing the level of pinging  - use of GC% init.ora 
      variables
      <SPAN 
      class=506365808-04022002>Requirement for different start up scripts
      (exclusive and shared modes)
      <SPAN 
      class=506365808-04022002>Some additional work when duplicating databases 
      using RMAN
      <SPAN 
      class=506365808-04022002>Perhaps more involvement with application and sys 
      admin teams to determine load balancing factors
       
      <SPAN 
      class=506365808-04022002>I am sure there are others (probably ones I 
      should be doing that I am not)
       
      
      <SPAN 
      class=506365808-04022002>The simplest thing to remember about OPS is that 
      there is only 1 set of datafiles and therefore tables, despite the number 
      of instances that may be using those datafiles. This point is 
      occasionally made to those whob elieve that we have a fully
      resilient set up.
       
      <SPAN 
      class=506365808-04022002>HTH
       
      <SPAN 
      class=506365808-04022002>John
      
        <FONT face="Times New Roman" 
        size=2>-----Original Message-----From: Shreeni [<A 
        class=moz-txt-link-freetext 
        href="mailto:sri.tri_at_verizon.net">mailto:sri.tri_at_verizon.net]Sent: 
        04 February 2002 00:40To: Multiple recipients of list 
        ORACLE-LSubject: Dumb question
        Hi 
        List,
         
        To 
        ask a dumb question, is there any special way to run exp/imp on Oracle 
        Parallel server on Solaris ?? Is parallel server DBA different than a 
        "regular" DBA ?? :)
         
        <SPAN 
        class=593433600-04022002>TIA
         
        <SPAN 
        class=593433600-04022002>Shreeni
        <FONT
        color=#000000>Shreenivasa Rao<FONT 
        color=#0000ff>e-Z ing 
        Technologies, 
        Inc..41-43 Beekman Street, 3rd FloorNew York, NY 10038.Tel: 
        (212)233-9861 xt.241Fax: 
        (212)233-9862Cell:(917)861-4966<A 
        href="mailto:lsama_at_e-zingtech.com"><FONT 
        size=2>lsama_at_e-zingtech.com 
        <FONT color=#000000 
        size=2>*****************************************Your IT Solutions 
        Provider*********** *** <A href="http://www.e-zingtech.com/" 
        target=_blank><FONT 
        size=2>http://www.e-zingtech.com <FONT 
        color=#0000ff>  <FONT 
        color=#000000 size=2>*******Under Bill s.1618 Title III passed by 
        the 105th U.S. Congress this mail cannot be considered spam as long 
        as we include contact information and a remove link for removal from our 
        mailing list. To be removed from our mailing list reply with remove in 
        the subject heading and your email address in the body. Include complete 
        address and/or domain to be 
        removed.--------------------------------------------
        
          <FONT 
          face=Arial size=2><SPAN 
          style="FONT-FAMILY: Arial; FONT-SIZE: 10pt"> <FONT 
      size=3>=========================================================This 
      electronic message contains information from the mmO2 plc Group which 
      may be privileged or confidential. The information is intended to be
      for the use of the individual(s) or entity named above. If you are not 
      the intended recipient be aware that any disclosure, copying, 
      distribution or use of the contents of this information is prohibited. 
      If you have received this electronic message in error, please notify 
      us by telephone or email (to the numbers or address above) 
      immediately.=========================================================

=========================================================

This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately.

Received on Tue Feb 05 2002 - 07:48:53 CST