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-14163: subpartition number string: INITRANS value must be less than MAXTRANS value

1 Answers  


ORA-25232: duplicate recipients specified for message

1 Answers  


ORA-02756: osnfsmnam: name translation failure

1 Answers  


ORA-09828: SCLFR: atomic latch return error.

1 Answers  


ORA-01942: IDENTIFIED BY and EXTERNALLY cannot both be specified

1 Answers  


ORA-32320: REFRESH FAST of "string"."string" unsupported after container table PMOPs

2 Answers  


ORA-36956: (XSFCAST25) There are only number PERIODICITY values. You cannot specify more OFFSET values.

1 Answers  


ORA-36278: (XSCGMDLAGG07) workspace object is not a valid valueset.

1 Answers  


PLS-00114: identifier 'string' too long

1 Answers  


ORA-16178: Cannot specify remote destinations in archivelog manual mode

1 Answers  


ORA-31105: User does not own lock "string"

1 Answers  


O2F-00328: Illegal INITFUNC name

1 Answers  


Categories