Re: Please a parameter to disable undo, like _disable_logging

You could do this by performing the following:

su - oracle
sqlplus "/ as sysdba"
alter system checkpoint;
shutdown abort;
startup mount;
alter database open read only;

-Jamie

On Tue, 5 Oct 2004 19:18:00 -0400, Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com> 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