Re: Designer 2.1.1 Never finishes reverse engineering

Yep

I agree, took me 2-3 night to reverse engineer my database, nearly used up this disk by making the rollbacks tablespace auto extend.

Even one table seems to take for ever !!

Are there any performance tips you know of ?

Richard Platt

dperez_at_juno_nospam.com wrote in message <36ab1a50.34732843_at_news.cwix.com>...
>Well, just when I thought Oracle COULDN'T find a way to make Designer
perform
>worse than 1.3.2....... they managed.....
>
>Designer 2.1.1 installation using PO 8.0.4 and ORACLE'S SEEDED DATABASE....
>
>Reverse engineer a trivial set of tables into Designer - we're only talking
80
>tables here and possibly 20 or so foreign keys...... Essentially mickey
>mouse.....
>
>Runs. Read the database. Gets the stuff... Puts up the banner to
"Save".....
>Hit the button....................... runs, runs, runs... Gets to 99%.
Says
>its "Committing" NEVER FINISHES........ I let it run OVERNIGHT. Never
>finished.............
>
>First time I did this USING ORACLES sizes of rollback tablespace and
segments, I
>got blown up with a "can't extend segment on rollback segment"... SO, I
set the
>rollback tablespace and segments to UNLIMITED..........
>
>A single attempt caused the rollback tablespace to expande from whatever it
>originally was (around 2 MB as I recall) to 33MB....... That's the one
that
>spent ALL NIGHT "Committing"..............
>
>Now I'm trying to pull these in 5 or 6 tables at a time - which is pure,
>unadulterated, *&$_at_#@ but sort-of works............
>
>I noticed that the SECOND rollback segment is now 32MB so my rollback
tablespace
>is 66MB at the moment.......... TO GET 5 TABLES...
>
>Oh, and once it gets to the "Commit" ABSOLUTELY PEGS the CPU for as long
as it
>decides to commit... No disk activity. I've got the monitor running...
>NOTHING to the disk, just CPU. And for 10 tables, its been sitting here
for
>over an hour - COMMITTING!!!!!!!!
>
>My God, no wonder my customers are using things like ERwin and Power
Designer
>and throwing this thing out!!!
>
>So, how do I get this tablespace back down to a reasonable size? And how
do I
>get this POS to reverse engineer in less than 8 hours for a few dozen
tables?
>
>
Received on Wed Jan 27 1999 - 00:47:58 CET