Friday, October 16, 2015

ORA-600 raised in ASM I/O path, [ossnet_assign_msgid_1]

Today fought with error in alert log (Database 12.1.0.2.11 on Exadata, image 12.1.2.1.2):
 
ORA-00600: internal error code, arguments: [ossnet_assign_msgid_1], [], [], [], [], [], [], [], [], [], []
ERROR: unrecoverable error ORA-600 raised in ASM I/O path

MOS found nothing direct links about this error.

As of note " 12.1.0.2 Bundle Patches for Engineered Systems and DB In-Memory - List of Fixes in each Bundle (Doc ID 1937782.1) "
this is the bug:
ORA-600 [OSSNET_ASSIGN_MSGID_1] CAUSED BY TO SMALL VALUE _SMM_AUTO_MIN_IO_SIZE

The solution which helped to us:

alter system set "_smm_auto_max_io_size"=2048 scope=both sid='*';
alter system set "_smm_auto_min_io_size"=2040 scope=both sid='*';

 

Does DEALLOCATE UNUSED or SHRINK SPACE will free space occupied by LOB segment?

Lets check how it works. My env is DB 19.20@Linux-x64 1) I created the table with 4 LOB columns of 4 different LOB types: BASICFILE BLOB, BA...