Re: Deactivating Redo Logs on 9i?

Ohhoh.

I have been there for sure.

You may want to get something in writing like a SLA (Service Level Agreement) that specifically denies that the testing process is to do anything with performance, and is only for logic, interface, and all the other stuff you test for, and get whoever is going to whine at you to sign it, that would be good for you and your boss to have in your pocket; make sure whoever is NOT paying for an adequate test bed to sign it as well, and include the consequences of testing in this manner.

The raw disk I/O suggestion is a good one, but again that gets us back into the "How different can your test environment be from production, and still be any decent kind of test? argument

With a million things running at once on that poor test server, that's a further argument that this test isn't going to mean a lot, unless the same million things are running in production as well. And a further reason to get something in writing; I've found that people who demand the impossible, and won't give you what you need, are often very very queasy about putting their name to something that you can blackmail them with when everything goes to hell, as well as protect your own jobs.

Good luck with this, I'll keep you in my prayers.

RSH.
"Holger Eilhard" <holger_at_xpo.de> wrote in message news:a5e083$6k50v$1_at_ID-18902.news.dfncis.de...
> Hi,
>
> "RSH" <RSH_Oracle_at_worldnet.att.net> schrieb im Newsbeitrag
> news:GGue8.14021$Im1.933366_at_bgtnsc05-news.ops.worldnet.att.net...
> > A question, though: if it's a test environment, and you don't have
> redo
> > logging, how is it really going to be a good testbed, since I
> presume and
> > would hope, your production environment will have redo logs;
> normally, I
> > want my test environments as close as possible to what my production
> > platform will be.
>
> Don't ask me, ask my boss... :( I know (and he knows it as well) that
> it's not the 'optimal' solution. But in the moment, hardware is a bit
> short ;) and it was even a problem to get this Athlon 1 Gig and 768 MB
> RAM... My boss wants to have as much as possible oracle in the ram...
> And there are two oracle test db's running on that 'server'...
>
> > Also, shutting off redo logging in test is kind of cheating, since
> > production won't have that luxury, and you might end up with people
> whining
> > at you "This ran a lot faster in test, what did you do to it??",
> words I've
> > grown to loathe hearing, especially when they aren't true.
>
> If you would know what runs beside oracle on that one little server,
> you'd run away... Screaming, of course ;(
>
> But thanks for your tips, I will try them and see that it won't hurt
> the dbs ;)
>
> Thanks!
> Holger
>
>
Received on Mon Feb 25 2002 - 16:24:40 CST