Thanks Robert, we have Oracle experts and our system is working well for three years, this is the first time we are facing a similar issue.
Does it exist an alternative way to empty step by stemp a node? I mean in place of remove() method, which I suppose it loads the full entity before effectively remove it. Thanks -----Messaggio originale----- Da: Robert Munteanu <romb...@apache.org> Inviato: lunedì 28 gennaio 2019 10:16 A: users@jackrabbit.apache.org Oggetto: Re: Removing very big node Hi Raffaele, On Mon, 2019-01-28 at 08:55 +0000, Raffaele Gambelli wrote: > Now we are not able to remove this node, because its removal increases > the CPU (100% or 200%, we have 4 cores) for an undeterminate time, the > removal doesn't ever end, we waited for twelve hours... I have very little expertise in this area, but maybe a start would be to look at what the Oracle server is doing, maybe there is something to optimise on the DB side... Robert [https://westpole.it/firma/logo.png] Raffaele Gambelli WebRainbow® Software Developer P +39 051 8550 576 M # E r.gambe...@westpole.it W https://westpole.webex.com/meet/R.Gambelli A Via Ettore Cristoni, 84 - 40030 Casalecchio di Reno [https://westpole.it/firma/sito.png]<https://westpole.it> [https://westpole.it/firma/twitter.png] <https://twitter.com/WESTPOLE_SPA> [https://westpole.it/firma/facebook.png] <https://www.facebook.com/WESTPOLESPA/> [https://westpole.it/firma/linkedin.png] <https://www.linkedin.com/company/westpole/> This email for the D.lgs.196/2003 (Privacy Code) and European Regulation 679/2016/UE (GDPR) may contain confidential and/or privileged information for the exclusive use of the intended recipient. Any review or distribution by others is strictly prohibited. If you are not the intended recipient, you must not use, copy, disclose or take any action based on this message or any information here. If you have received this email in error, please contact us (email:priv...@westpole.it) by reply email and delete all copies. Legal privilege is not waived because you have read this email. Thank you for your cooperation. [https://westpole.it/firma/ambiente.png] Please consider the environment before printing this email
