Re: Deactivating Redo Logs on 9i?

> 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'...
>
> If you would know what runs beside oracle on that one little server,
> you'd run away... Screaming, of course ;(

if you want optimized memory usage - run your db on RAW devices ... I have Oracle 9.0.1 DB, 8.1.7.1 DB running on Linux NEXT to 9iAS 1.0.2 and IBM DB2 on 256MB on a Pentium MMX 233Mhz (overclocked to 266MHz :-) ) My two Oracle databases are running on RAW devices to bypass the filesystem cache ...
It's not a supersystem but enough for testing and do-able partly because of the raw devices ... Oracle data shoud be cached in the SGA not in the filesystem cache :-)

If you want to disable the redo log mechanism then set the hidden parameter _disable_logging=TRUE - it kicks ass and it'll bite your ass when your database crashes !!!

"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 - 13:19:51 CST