RE: Changing DB_CACHE_SIZE to DB_BLOCK_BUFFERS

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