How to fix the error ORA-00380: cannot specify db_stringk_cache_size since stringK is the standard block size?

In this post, you’ll learn more about the Oracle ErrorORA-00380: cannot specify db_stringk_cache_size since stringK is the standard block size with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-00380: cannot specify db_stringk_cache_size since stringK is the standard block size

Reason for the Error ORA-00380: cannot specify db_stringk_cache_size since stringK is the standard block size

User specified the parameter db_nk_cache_size (where n is one of 2,4,8,16,32), while the standard block size for this database is equal to n Kbytes. This is illegal.

How to fix the Error ORA-00380: cannot specify db_stringk_cache_size since stringK is the standard block size ?

You can fix this error in Oracle by following the below steps

Specify the standard block size cache using db_cache_size (DEFAULT pool) (and db_recycle_cache_size, db_keep_cache_size if additional buffer pools are required). Do NOT use the corresponding db_nk_cache_size parameter for the standard block size.