Inserting data into CLOB column causing big overhead (excessive parsing) (4258813)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Inserting data into CLOB column causing big overhead (excessive parsing)
Description

Inserting data into LOB column causing big overhead and significantly slow post performance. Here is an example: The poster process does below query very frequently on target.
SELECT t."GWLMSG" FROM "SNAPADMIN"."GATEWAYLONGMSG" t WHERE ROWID = 'AABBQKAEdAABdM5AAM' FOR UPDATE
Cause

Post is not using bind variable for ROWID, instead it is using the literal ROWID which causes significant parsing and overhead on high transaction/volume CLOB tables.
Resolution

WORKAROUND:
None

STATUS:
Fixed in 6.0 and above.
Defect ID

ST15711

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title