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-01583: unable to get block size of controlfile to be backed up

1 Answers  


ORA-09741: spwat: error waiting for a post.

1 Answers  


ORA-12545: Connect failed because target host or object does not exist

1 Answers  


ORA-01640: cannot make tablespace read only with active transactions

1 Answers  


RMAN-08583: channel string: archivelog copy complete, elapsed time: string

1 Answers  






KUP-04067: internal error allocating handle type string

1 Answers  


PCC-00103: AT clause is an Oracle extension

1 Answers  


PLS-01900: : character to number conversion error

1 Answers  


DRG-50802: failed to bind input

1 Answers  


DRG-12307: column string is NULL and cannot be indexed

1 Answers  


NNL-00246: General request processing is currently disabled

1 Answers  


QSM-02058: set operator in mv and compatibility mode is less than 9.0

1 Answers  


Categories