Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-00383: DEFAULT cache for blocksize string cannot be
reduced to zero



ORA-00383: DEFAULT cache for blocksize string cannot be reduced to zero..

Answer / guest

Cause: User attempted to reduce db_cache_size to zero, or
attempted to to reduce db_<n>K_cache_size to zero while
there were still online tablespaces with blocksize <n>K.
Note that since the SYSTEM tablespace cannot be taken
offline, it is always illegal to set db_cache_size to zero.

Action: Offline any tablespaces with the corresponding
blocksize and then perform the operation again.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02203: INITIAL storage options not allowed

1 Answers  


ORA-26013: List allocated may not be big enough

1 Answers  


ORA-06004: NETASY: dialogue file open failure

1 Answers  


TNS-02517: key smaller than requested size

1 Answers  


ORA-21707: pin duration is longer than allocation duration

1 Answers  






ORA-12591: TNS:event signal failure

1 Answers  


RMAN-08526: channel string: string

1 Answers  


TNS-00095: * to trace_on - argument is considered the trace level

1 Answers  


RMAN-08092: channel string: specifying datafilecopy of datafile string for proxy backup

1 Answers  


NID-00335: The following datafiles are not consistent:

1 Answers  


ORA-13914: Threshold notification failed.

1 Answers  


IMG-00815: merged area queue free failed

1 Answers  






Categories