Hi,
I am working on some standard version RACs and the problem is that my instance snaps always hang themselves.. It's funny because there are multiple databases with the same configuration and only on one db this problem happens... It's always on the SQLTEXT Object hanging.. on a row that is empty, I have selected it, also index dumps, etc.. I work on it already 2 months but I not getting further.. on another database I have problems with the purge jobs when I make extended deletes.. if I would make all these things sequentially everything would work but after I enable every job (snap_[1,2], purge[1,2]) I get into troubles and always have to stop these jobs and generate tickets.. I tried rebuilding indexes, reorgs, making foreign keys because of TM Contention on stats$undostat (for purge jobs)... I have also checked the statspack definitions and I think that these deletes should be modified,if you make extended purge..
How do you solve monitor these Standard editions? Thank you
Session wait event Info Obj
------------------------------ ---------------------------------------- ---------------------------------------------------------------------- -----------------------------------
'1726,44458,@1' resmgr:cpu quantum | Insert ACTIVE -> 04-JUL-17 | User: PERFSTAT 7r7twx8dzdd8r,0 SYS.OBJ$
'1194,30573,@2' enq: TX - row lock c | Insert ACTIVE -> 13098.07 minutes | User: PERFSTAT 11dxc6vpx5z4n,0 PERFSTAT.STATS$SQLTEXT_PK