[Editing the original post]
Hi,
DB: Oracle 11.2.0.4.0 EE
OS: OEL6
I am running a script which cleans up data from underlying set of tables using truncate.
Below is the flow:-
1) disable underlying tables FK constrains
2) truncate tables
3) enable underlying tables FK constrains
Previously there was no such problem with the performance (5-7 mins max), but suddenly the script is taking +1hr to complete.
On diagnosing, it is found that disabling and enabling steps are taking the maximum time.
Previously they used to take ~10-20 secs vs ~2-4 mins now (per constraint).
Total no of FK constraints are approx 20.
Data in underlying tables is not that huge (~3k to 4k).
I am not able to get a proper solution to this problem.
What could be the culprit here?
Thanks in advance..
Message was edited by: 991278