Skip to Content
0
Nov 03, 2008 at 06:57 PM

After table partition, some transactions hang

800 Views

I am running SAP 4.6 and Oracle 10.2

I recently used online reorg to partition table DFKKOP (over 100 million records) into two parts. One partition was for "closed" orders, and the other was for "open" orders (less than 2% of the rows).

Since most of the queries against this table were against open orders, access times improved dramatically (one query went from 20 minutes to 20 seconds).

Unfortunately, while it was on a test system, our developers discovered that this caused transactions FPL9 and CIC0 to hang. To prove that it was the partition causing the hang, we used our "snapback" ability to return the database to the point in time prior to the partition (we did this twice), and the problem disappeared. Other than these hangs, the database seemed to work normally.

Does anyone have an idea why this might be happening? BTW - I had "row movement enabled", so that's not it. I have found nothing in SAP notes or on this forum.

Thanks.