Post hung or slow execution of specific SQL statement for a same table (20085)
Post hung or slow execution of specific SQL statement for a same table
Post was completely hung for several hours on the particular update statement on the specific table.
Table is locked by another process causing post hung on this statement.
1. Turn on post full debug to find out which SQL statement post is waiting to execute:
sp_ctrl> set param SP_OPO_DEBUG_FLAG 0x0f0001ff
run it for a couple minutes and then turn off debug
sp_ctrl> set param SP_OPO_DEBUG_FLAG 0x0
Examine shareplex var dir/log/*opo01.log to find out the last statement it is running.
2. Stop post and try running this SQL statement manually on the database to see if it still hangs.
3. If this is still hung, you should check oracle v$lock to find out which session is blocking Shareplex post process.
4. Either kill the blocking process or discard this message and restart post.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED.