I am wondering about a weird deadlock and after checking all other components I am considering it to be a INITRANS problem in Oracle 11.2.
Now three questions arose:
Is there some way of analyzing how full the blocks are?
My database reached its max tablespace size a while ago and started rejecting inserts, then I added another data file, but this only grows if nearly all the space is used up. My PCT_USED is 96%. Is my assumption correct that all data blocks will be totally stuffed and a INITRANS deadlock is likly?
Is there some way of seeing an INITRANS problem in a deadlock trace?
I'm happy about partial answers as well.