Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

Re: HELP!!! HORRIBLE ARCHITECTURE

From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
To: paulastankus@xxxxxxxxx
Date: Fri, 2 Mar 2007 21:07:04 +0000

It strikes me that what you need is not a smart architecture but a
competent program manager and a development program and schedule. When
I came here we had, for one of the 3 business critical systems I
support, 8 dev environments, 2 DBAs reporting to me and no
concentration on the other systems at all. We now have 4 dev
environments, one consolidated test environment and prod, we also have
regular program meetings. We also know about how the other systems
work as well. It isn't great - too many clone requests per month, but
it is manageable. It's the program management that has made the
biggest difference. I do claim credit for insisting on change control
and regression testing as per your last email, but really it's the
business getting a handle on development that is the key.

Incidentally, one side effect of change control and regression testing
by end users is that the teams 'requiring' the 10 different
developments simultaneously will likely find they need to resource
appropriate testing. This is likely to be a greater strain on them
than you and is a great way of discovering the business's real
priorities.

cheers

Niall



On 3/2/07, Paula Stankus <paulastankus@xxxxxxxxx> wrote:

yes,

it occurs to me that we will need to setup some serious testing in a staging
environment that matches production before deploying to production to ensure
that all of these things come together in the end.

...sigh...


Paula Stankus <paulastankus@xxxxxxxxx> wrote:

Here it is and if someone has a good solution let me know.

I have inherited this database with multiple, multiple schemas.

The schemas have views and the views access more schemas.

The database is very large.

I have about 10 development groups needing (per their request) 10 separate
instances to develop on because they are in different phases of development.

Refreshing the databases is a nightmare.  Just when you thought you were
done you need yet another underlying schema.

I don't have enough space for 10 clones of prod (wish I did)

Any suggestions???
________________________________
Never miss an email again!
Yahoo! Toolbar alerts you the instant new Mail arrives. Check it out.


________________________________
Don't be flakey. Get Yahoo! Mail for Mobile and
always stay connected to friends.



--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: HELP!!! HORRIBLE ARCHITECTURE
From: Dennis Williams

References:
- Re: HELP!!! HORRIBLE ARCHITECTURE
  - From: Paula Stankus

Re: HELP!!! HORRIBLE ARCHITECTURE

Other related posts: