Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: oracle parallel server

RE: oracle parallel server

From: Richard Ji <richard_at_letsplay.com>
Date: Thu, 21 Sep 2000 12:01:03 -0400
Message-Id: <10626.117588@fatcity.com> 





This is a multi-part message in MIME format.



------=_NextPart_000_0024_01C023C5.60BA85A0
Content-Type: text/plain;


        charset="us-ascii"


Content-Transfer-Encoding: 7bit





Anything you can tell me. I've never used OPS and plan to attend a class in
November.




What version of Oracle did you use?


[Richard Ji] I used 7.3.4 OPS on Digital Unix 4.0d on a Dec cluster.




Does it work as expected?


[Richard Ji] Yes, it worked pretty well for us.




What type of application is it?


[Richard Ji] It's a datawarehouse for a global equity system for a big

financial insitute.



What sort of transaction volumes do you have?


[Richard Ji] Nightly batch load of 500MB data.




How many users?


[Richard Ji] 150




How many instances are you running on how many nodes?


[Richard Ji] Four instance on two nodes.  Two instance belongs to a stage

database and two instance for the end user database.  Replication between
the two.



How is locking between instances handled?


[Richard Ji] By logically separate the users.  One node dedicated for query

the other for updateds.



Have you seen performance degradation because of lock management between
instances or any other inter-instance communication?


[Richard Ji] Nope.




 How is logging handled[Richard Ji] Each instance has it's own thread of
redo log on distributed raw devices.



 Are there separate logs for each instance?


[Richard Ji] Yes




 Have you succesfully tested backup and recovery?


[Richard Ji] Yes, using EBU and Legato.




 Are there any administration things to watch out for that are introduced by
OPS?



[Richard Ji] Yes, a lots both on the OS side and Oracle side.




How much application work is involved to switch instances in the event of a
failure?


[Richard Ji] Depends on how you have it setup.  In our case it's very small.




 Is anything lost when a node fails?


[Richard Ji] For committed transactions no, the surviving node will recover

the failed node's redo log.



Have you encountered situations where a node fails but the applications
haven't detected the failure?


[Richard Ji] No I haven't encountered that situation yet.




TIA



  "Adams, Matthew (GEA, 088130)" <MATT.ADAMS_at_APPL.GE.COM> wrote:





Yes. What would you like to know?





matt adams - matt.adams_at_appl.ge.com <?XML:NAMESPACE PREFIX = MAILTO />



against the Martian Landscape>


"That is the top of the calibration target, that is _not_ in fact a
monolith."


- NASA TV Commentator - 7/5/1997



-----Original Message-----


Sent: Wednesday, September 20, 2000 10:01 AM
To: Multiple recipients of list ORACLE-L




Has anyone succesfully used OPS in a mission critical production
environment? I'd like to hear about it.











Do You Yahoo!?


Send instant messages & get email alerts with Yahoo! Messenger
.


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Adams, Matthew (GEA, 088130)
INET: MATT.ADAMS_at_APPL.GE.COM
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).



  _____

Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.


------=_NextPart_000_0024_01C023C5.60BA85A0
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">


<META content=3D"MSHTML 5.00.3103.1000" name=3DGENERATOR></HEAD>
<BODY>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE>
  <P>Anything you can tell me. I've never used OPS and plan to attend a =
class in=20
  November.</P><BR>
  <P>What version of Oracle did you use? <BR><SPAN=20
  class=3D633505315-21092000><FONT color=3D#0000ff face=3DArial =
size=3D2>[Richard=20
  Ji]&nbsp;I used 7.3.4 OPS on Digital Unix 4.0d on a Dec=20
  cluster.</FONT></SPAN></P>
  <P>Does it work as expected?<BR><SPAN class=3D633505315-21092000><FONT =

  color=3D#0000ff face=3DArial size=3D2>[Richard Ji]&nbsp;Yes, it worked =
pretty well=20
  for us.</FONT></SPAN></P>
  <P>What type of application is it?<BR><SPAN =
class=3D633505315-21092000><FONT=20
  color=3D#0000ff face=3DArial size=3D2>[Richard Ji]&nbsp;It's a =
datawarehouse for a=20
  global equity system for a big financial insitute.</FONT></SPAN></P>
  <P>What sort of transaction volumes do you have?<BR><SPAN=20
  class=3D633505315-21092000><FONT color=3D#0000ff face=3DArial =
size=3D2>[Richard=20
  Ji]&nbsp;Nightly batch load of 500MB data.</FONT></SPAN></P>
  <P><SPAN class=3D633505315-21092000></SPAN>How many users?<BR><SPAN=20
  class=3D633505315-21092000><FONT color=3D#0000ff face=3DArial =
size=3D2>[Richard=20
  Ji]&nbsp;150</FONT></SPAN></P>
  <P><SPAN class=3D633505315-21092000></SPAN>How many instances are you =
running on=20
  how many nodes?<BR><SPAN class=3D633505315-21092000><FONT =
color=3D#0000ff=20
  face=3DArial size=3D2>[Richard Ji]&nbsp;Four instance on two =
nodes.&nbsp; Two=20
  instance belongs to a stage database and two instance for the =
end&nbsp;user=20
  database.&nbsp; Replication between the two.</FONT></SPAN></P>
  <P><SPAN class=3D633505315-21092000></SPAN>How is locking between =
instances=20
  handled?<BR><SPAN class=3D633505315-21092000><FONT color=3D#0000ff =
face=3DArial=20
  size=3D2>[Richard Ji]&nbsp;By logically separate the users.&nbsp; One=20
  node&nbsp;dedicated for query the other for =
updateds.</FONT></SPAN></P>
  <P><SPAN class=3D633505315-21092000></SPAN>Have you seen performance =
degradation=20
  because of lock management between instances or any other =
inter-instance=20
  communication?<BR><SPAN class=3D633505315-21092000><FONT =
color=3D#0000ff=20
  face=3DArial size=3D2>[Richard Ji]&nbsp;Nope.</FONT></SPAN></P>
  <P><SPAN class=3D633505315-21092000>&nbsp;</SPAN>How is logging =
handled<FONT=20
  color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D633505315-21092000>[Richard=20
  Ji]&nbsp;Each instance has it's own thread of redo log =
on&nbsp;distributed raw=20
  devices.&nbsp;</SPAN></FONT></P>
  <P><SPAN class=3D633505315-21092000>&nbsp;</SPAN>Are there separate =
logs for=20
  each instance? <BR><SPAN class=3D633505315-21092000><FONT =
color=3D#0000ff=20
  face=3DArial size=3D2>[Richard Ji]&nbsp;Yes</FONT></SPAN></P>
  <P><SPAN class=3D633505315-21092000>&nbsp;</SPAN>Have you succesfully =
tested=20
  backup and recovery? <BR><SPAN class=3D633505315-21092000><FONT =
color=3D#0000ff=20
  face=3DArial size=3D2>[Richard Ji]&nbsp;Yes, using EBU and=20
  Legato.</FONT></SPAN></P>
  <P><SPAN class=3D633505315-21092000>&nbsp;</SPAN>Are there any =
administration=20
  things to watch out for that are introduced by OPS?&nbsp; <BR><SPAN=20
  class=3D633505315-21092000><FONT color=3D#0000ff face=3DArial =
size=3D2>[Richard=20
  Ji]&nbsp;Yes, a lots both on the OS side and Oracle=20
  side.&nbsp;</FONT></SPAN></P>
  <P>How much application work is involved to switch instances in the =
event of a=20
  failure? <BR><SPAN class=3D633505315-21092000><FONT color=3D#0000ff =
face=3DArial=20
  size=3D2>[Richard Ji]&nbsp;Depends on how you have it setup.&nbsp; In =
our case=20
  it's&nbsp;very small.</FONT></SPAN></P>
  <P><SPAN class=3D633505315-21092000>&nbsp;</SPAN>Is anything lost when =
a node=20
  fails? <BR><SPAN class=3D633505315-21092000><FONT color=3D#0000ff =
face=3DArial=20
  size=3D2>[Richard Ji]&nbsp;For committed transactions no, the =
surviving node=20
  will recover the failed node's&nbsp;redo log.&nbsp;</FONT></SPAN></P>
  <P><SPAN class=3D633505315-21092000></SPAN>Have you =
encountered&nbsp;situations=20
  where a node fails but the applications haven't detected the =
failure?<BR><FONT=20
  color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D633505315-21092000>[Richard=20
  Ji]&nbsp;No I haven't encountered that situation =
yet.&nbsp;</SPAN></FONT></P>
  <P>TIA</P><BR>
  <P>&nbsp; <B><I>"Adams, Matthew (GEA, 088130)"=20
  &lt;MATT.ADAMS_at_APPL.GE.COM&gt;</I></B> wrote: <BR></P><BR>
  <BLOCKQUOTE=20
  style=3D"BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; =
PADDING-LEFT: 5px">Yes.=20
    What would you like to know?<BR><BR>----<BR>matt adams -=20
    matt.adams_at_appl.ge.com <?XML:NAMESPACE PREFIX =3D MAILTO=20
    /><MAILTO:MATT.ADAMS_at_APPL.GE.COM><BR><DISCUSSING <br silhouetted =
rectangle=20
    black a of image an>against the Martian Landscape&gt;<BR>"That is =
the top of=20
    the calibration target, that is _not_ in fact a<BR>monolith."<BR>- =
NASA TV=20
    Commentator - 7/5/1997<BR><BR>-----Original Message-----<BR>Sent: =
Wednesday,=20
    September 20, 2000 10:01 AM<BR>To: Multiple recipients of list=20
    ORACLE-L<BR><BR><BR>Has anyone succesfully used OPS in a mission =
critical=20
    production<BR>environment? I'd like to hear about it.=20
    <BR><BR><BR><BR><BR><BR><BR>_____ <BR><BR>Do You Yahoo!?<BR>Send =
instant=20
    messages &amp; get email alerts with Yahoo! Messenger<BR>.<BR><BR>-- =

    <BR>Please see the official ORACLE-L FAQ: =
http://www.orafaq.com<BR>--=20
    <BR>Author: Adams, Matthew (GEA, 088130)<BR>INET:=20
    MATT.ADAMS_at_APPL.GE.COM<BR><BR! !>Fat City Network Services -- (858) =
538-5051=20
    FAX: (858) 538-5051<BR>San Diego, California -- Public Internet =
access /=20
    Mailing=20
    =
Lists<BR>----------------------------------------------------------------=
----<BR>To=20
    REMOVE yourself from this mailing list, send an E-Mail =
message<BR>to:=20
    ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and =
in<BR>the=20
    message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the =
name of=20
    mailing list you want to be removed from). You may<BR>also send the =
HELP=20
    command for other information (like=20
  subscribing).</BLOCKQUOTE></MAILTO:MATT.ADAMS_at_APPL.GE.COM>


Received on Thu Sep 21 2000 - 11:01:03 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US