Skip to Main Content

Need info on PROPERTY_VALUE table

3009057Aug 10 2015 — edited Aug 24 2015

In our project we have a portal application for which we are using weblogic portal server (10.3.4).

Recently we faced an issue where we saw concurrent DELETES on multiple nodes running against PROPERTY_VALUE .  

These concurrent deletes resulting in row locking issues and blocking locks. PROPERTY_VALUE had 4 million records. 

SQL_TEXT : -   DELETE FROM PROPERTY_VALUE WHERE ENTITY_ID = :1  AND PROPERTY_KEY_ID=:2

We have below queries on this regard:-

a.         For what purpose is this table being used?

b.         Why would there be more insert and delete on a day on this table?

c.          Why would there be concurrent deletes?

d.         Why would the table have PROPERTY_VALUE have 4 million records?

e.         Can it be purged?

Comments
Post Details
Added on Aug 10 2015
3 comments
642 views