Hi > >ALTER SYSTEM SET DB_CACHE_SIZE = 0 scope=spfile; IMHO it is always better to remove the parameters and not to set them to other values that should/can disable a feature... i.e. in such situation I would use ALTER SYSTEM RESET. HTH Chris -- http://www.freelists.org/webpage/oracle-l