table GLPCA is huge

[Former Member]

All-

In my PRD system table GLPCA is 110 GB and with indexes it is touching 200GB and is creating lot of performance bottlenecks. We started doing the archiving recently and currently we are archiving this table using object EC_PCA_ITM. My question here is , can we stop the huge data flow to this table ?? If so are there any mechanism/parameter through which I can do this?

Thanks

Anil

[Former Member]

Hello Anil,

I suggest you perform index reorganisation for GLPCA table.

Regards,

Ammey Kesarkar

<i>'Award points for useful info'</i>