Database Administration (MOSC)

MOSC Banner

Advice on setting db_16k_cache_size for a new tablespace

edited Mar 20, 2014 10:18AM in Database Administration (MOSC) 12 commentsAnswered ✓

11.2.0.1

Hi,

I want to create a new tablespace with 16k blocks. So we can create an index without hitting

ORA-00604: error occurred at recursive SQL level 1

ORA-01450: maximum key length (3215) exceeded

So, I found out that I need to set db_16k_cache_size.

But to how much? I guess its a MINIMAL threshold, so if I set to 64M it can grow bigger, but not lower then 64M?

Is there any way to find out a "good" size for the db_16k_cache_size?


EDIT: and it seems that not even a 32K tablespace was enough. Still hitting ORA-01450: maximum key length (3215) exceeded.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center