Skip to Content
avatar image
Former Member

table GLPCA is huge

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jun 13, 2007 at 12:47 PM

    Hello Anil,

    I suggest you perform index reorganisation for GLPCA table.

    Regards,

    Ammey Kesarkar

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

    Add comment
    10|10000 characters needed characters exceeded