RE: Tips for Building the Designer2000 Repository

From: Shockey, David <DShockey_at_jwrinc.com>
Date: Fri, 14 Jul 2000 11:49:46 -0500
Message-Id: <10558.112085@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFEDB5.35CD82AC
Content-Type: text/plain;

charset="iso-8859-1"

We are considering using Designer for application development. In the real world, how close can you get to 100% generation? If changes are made using Developer, can the changes be included in the application version that is stored in the repository?

-----Original Message-----
From: Henry.O'Keeffe_at_ft.com [mailto:Henry.O'Keeffe_at_ft.com] Sent: Friday, July 14, 2000 11:42 AM
To: Steve Orr
Cc: oracle-l_at_fatcity.com; oracledba_at_QuickDoc.co.uk Subject: Re: Tips for Building the Designer2000 Repository

Dunno ... I've got designer running in ONE tablespace (USERS) and it seems ok.
(Yes, yes, bad bad bad)
Designer apears CPU bound more than disk bound, especially when reverse engineering stuff, so I'd make sure you had a fast client PC first rather than
worrying about splitting the respository up into 15 tablespaces. (15 tablespaces for designer is a joke quite frankly) Another thing you'll need is plenty of rollback.

HTH .... "Steve Orr" <sorr_at_arzoo.com> on 14/07/2000 09:19:06 To: oracle-l_at_fatcity.com, oracledba_at_QuickDoc.co.uk cc: (bcc: Henry O'Keeffe/PSD/LONDON/FTI)

Subject: Tips for Building the Designer2000 Repository

Sometimes Oracle's recommendations are good and sometimes they are puzzling. I'm installing Designer2000 (version 6i) today and going thru the docs. Oracle recommends creating 15 tablespaces dedicated for Des2k objects. I like the idea of segregating like objects into separate tablespaces. But, for a large repository, the recommended size for 8 of these tablespaces is less than 5MB. Eight itty bitty teeny tiny datafiles < 5MB ??? (This is on a scale of MS Access :-) Is it really worth it or should I ignore Oracle's recommendations and lump some of these tablespaces together (except for those containing I/O contending objects)?

(I'm putting the repository on a small Sun pizza box dedicated to DBA management stuff like statspack, the OEM and RMAN repositories, my own stuff, etc. No capacity problems are anticipated on this box.)

Any other tips on sizing and init.ora parms for supporting the Des2k repository? Any other DBA issues for maintaining the repository?

All off-the-wall-2-bit-recommendations are welcome from my DBA friends on the lists. :-) TIA.

Puzzled as usual...
Steve Orr

If you're bored, then visit the list's website: http://www.lazydba.com (updated
daily)
to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk

Please visit the web site of the Financial Times at: *
http://www.ft.com *
*
This E-Mail is intended for the use of the addressee only and may *
contain confidential information. If you are not the intended *
recipient, you are hereby notified that any use or dissemination *
of this communication is strictly prohibited. *
If you receive this transmission in error, please notify us *
immediately then delete this E-Mail. * *
*
postmaster_at_ft.com *

If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk

------_=_NextPart_001_01BFEDB5.35CD82AC
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: Tips for Building the Designer2000 Repository</TITLE>
</HEAD>
<BODY>

We are considering using Designer for application = development.  In the real world, how close can you get to 100% = generation?  If changes are made using Developer, can the changes = be included in the application version that is stored in the = repository?

-----Original Message----- From: Henry.O'Keeffe_at_ft.com [<A = HREF=3D"mailto:Henry.O'Keeffe_at_ft.com">mailto:Henry.O'Keeffe_at_ft.com</A>]<= /FONT>

<BR><FONT SIZE=3D2>Sent: Friday, July 14, 2000 11:42 AM</FONT>
<BR><FONT SIZE=3D2>To: Steve Orr</FONT>
<BR><FONT SIZE=3D2>Cc: oracle-l_at_fatcity.com; =

oracledba_at_QuickDoc.co.uk
 Subject: Re: Tips for Building the Designer2000 = Repository

Dunno ... I've got designer running in ONE tablespace = (USERS) and it seems ok.  
 (Yes, yes, bad bad bad) Designer apears CPU bound more than disk bound, = especially when reverse  
 engineering stuff, so I'd make sure you had a fast = client PC first rather than 
 worrying about splitting the respository up into 15 = tablespaces. (15 
 tablespaces for designer is a joke quite = frankly)

<BR><FONT SIZE=3D2>Another thing you'll need is plenty of rollback. =
</FONT>
</P>

<P><FONT SIZE=3D2>HTH ....</FONT>
</P>
<BR>
<BR>
<BR>

"Steve Orr" <sorr_at_arzoo.com> on = 14/07/2000 09:19:06
 To: oracle-l_at_fatcity.com, = oracledba_at_QuickDoc.co.uk
 cc:  (bcc: Henry = O'Keeffe/PSD/LONDON/FTI)

Subject: Tips for Building the Designer2000 = Repository

Sometimes Oracle's recommendations are good and = sometimes they are puzzling.
 I'm installing Designer2000 (version 6i) today and = going thru the docs.
 Oracle recommends creating 15 tablespaces dedicated = for Des2k objects. I
 like the idea of segregating like objects into = separate tablespaces. But,
 for a large repository, the recommended size for 8 = of these tablespaces is
 less than 5MB. Eight itty bitty teeny tiny datafiles = < 5MB ??? (This is on a
 scale of MS Access :-)  Is it really worth it = or should I ignore Oracle's
 recommendations and lump some of these tablespaces = together (except for
 those containing I/O contending objects)?

(I'm putting the repository on a small Sun pizza box = dedicated to DBA
 management stuff like statspack, the OEM and RMAN = repositories, my own
 stuff, etc. No capacity problems are anticipated on = this box.)

Any other tips on sizing and init.ora parms for = supporting the Des2k
 repository? Any other DBA issues for maintaining the = repository?

All off-the-wall-2-bit-recommendations are welcome = from my DBA friends on

<BR><FONT SIZE=3D2>the lists. :-)&nbsp; TIA.</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Puzzled as usual...</FONT>
<BR><FONT SIZE=3D2>Steve Orr</FONT>

--------
 If you're bored, then visit the list's website: <A = HREF=3D"http://www.lazydba.com" =
TARGET=3D"_blank">http://www.lazydba.com</A> (updated daily)
 to unsubscribe, send a blank email to = oracledba-unsubscribe_at_quickdoc.co.uk to subscribe send a blank email to = oracledba-subscribe_at_quickdoc.co.uk

</P>
<BR>
<BR>
<BR>
<BR>
<BR>

<FONT =

SIZE=3D2>***************************************************************=

******
 * Please visit the web site of the Financial Times = at:           &nb= sp;  *
 *          &n= bsp;           &n= bsp;  <A HREF=3D"http://www.ft.com" = TARGET=3D"_blank">http://www.ft.com</A>     &nb= sp;           &nb= sp;       * <FONT =

SIZE=3D2>*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *</FONT>

* This E-Mail is intended for the use of the = addressee only and may *
 * contain confidential information. If you are not = the intended     * * recipient, you are hereby notified that any use or = dissemination  *
 * of this communication is strictly = prohibited.          &= nbsp;          * * If you receive this transmission in error, please = notify us       * * immediately then delete this =

E-Mail.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

*
 <FONT =

SIZE=3D2>*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *</FONT>

* =

postmaster_at_ft.com&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=

nbsp;   *
 <FONT =

SIZE=3D2>***************************************************************=

******