Runtime Errors TSV_TNEW_BLOCKS_NO_ROLL_MEMORY - ST04old (report RSDB0500)

[Former Member]

Hi,

When i call the "Database Message Log" submonitor in the old Oracle database monitor ST04old (report RSDB0500), a dump occurs with the following message:

Runtime Errors TSV_TNEW_BLOCKS_NO_ROLL_MEMORY

Error analysis :

The internal table "\FUNCTION-POOL=STUN\FORM=S_DB_ALERT_LOG_GET\DATA=%_%_LOG_LISTE" could not be enlarged further.

Memory location: "Session memory"

You attempted to extend the data structure for the management of the memory blocks for table "\FUNCTION-POOL=STUN\FORM=S_DB_ALERT_LOG_GET\DATA=%_%_LOG_LISTE". However, the 1998864 bytes required for this were no longer available in the specified memory area.

The amount of memory requested is no longer available.

Even I have checked the profile parameters also.The system parameters are Ok.

Regards,

Hari

[Former Member · Accepted solution]

HI,

Please ensure that you have checked batch mode in your receiver communication channel.

Also you can set the below in the advanced parameters.Committing transactions is extremely disk I/O intensive and slow. You should always turn auto-commit off.

WSConnection.set-AutoCommit (false).

Check if you have ticked the disconnect from database for each message. Uncheck it. It has highly adverse effect on performance.

thanks,

Sendil.