RAMDISK redo, was: Please a parameter to disable undo, like _disable_logging

NOTE: I _KNOW_ what the risks are.
Just for fun, I created a ramdisk on Linux, and put my online redologs
there. They are copied there on system startup by an rc-script. A
graceful system shutdown saves them back to HDD just before the
powershut. 

Not exactly what you asked for, but speeding things up quite well. I
must give the credit of this to Casey Dyke, who put his redo on /tmp on
Solaris some day, to speed up a huge load. tmp on Solaris is more or
less ramdisk. He posted about this here. It's quite easy on linux as
well. Tweak your boot parameters a little, to create ramdisk devices
that are big enough, create the filesystem, mount and there you go.

By the way, this is some form of backing up your online redologs ;-)

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok)
===
On Wed, 2004-10-06 at 01:18, Juan Carlos Reyes Pacheco wrote: 

> Hi, I searched but I didn't find it, please do you know some parameter like
> _disable_logging (disables logging), 
> to disable undo.
> 
> SELECT KSPPINM, KSPPSTVL 
> FROM X$KSPPI A, X$KSPPSV B
> WHERE A.INDX=B.INDX AND SUBSTR(KSPPINM,1,1) = '_'
> and upper(KSPPINM) like '%UNDO%' ;
>  
> This is only to speed my test database, thanks.
>  
> Juan Carlos Reyes Pacheco
> OCP
> --
> http://www.freelists.org/webpage/oracle-l





--
http://www.freelists.org/webpage/oracle-l

Other related posts: