:

ORA-00600: internal error code, arguments: ktsladdfcb-bsz

The Problem

I was playing around with the securefile feature in Oracle 11g, which is used with LOB segments. I was trying to create a tablespace with the smallest extent size possible because I wanted to see the affect of using compression quickly and I thought the easiest way was to create a small extent size, load some data in using the varying levels of compression and then see how many extents were used. While trying to create a table in a tablespace with a small extent size, I received the following error:

ERROR at line 1:
ORA-60019: Creating initial extent of size 5 in tablespace of extent size 14
ORA-06512: at line 3

The Cause & Solution

It seems that the minimum number of extents you can have for a table using a LOB segment with (not sure about without) securefile needs to be a minimum of 14, so I thought to make the extent size 14 * block_size.

Once I had done that, I attempted to create the table again and received the following ORA00600 error message:

ORA-00600: internal error code, arguments: [ktsladdfcb-bsz], [3], [], [], [], [], [], [], [], [], [], []

I cannot find anything in the Oracle docs or on Metalink, but I found an Italian website which shows the issue. He thinks it’s a bug.

http://cristiancudizio.wordpress.com/category/11g/

I came to the same conclusion that he did, just make the extent size of the tablespace (14 * block_size) + 1 and that should fix the problems.

Like it, share it...

Category: ORA 600


Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *