Sometimes Oracle Database 11gR2 complains about not being able to extend a (lob) segment with ORA-1691, but ASM monitoring based on USABLE_FILE_MB did not fire. Adding a new data file fails with ASM ORA-15041. I was under the impression this behaviour of ASM deserved some explanation. Situation Database Alert Log complains with ORA-1691: ORA-1691: unable to extend lobsegment MYUSER.SYS_LOB0013128030C00003$$ […]
About
Martin Klier
Troubleshooter, Database integration, performance and HA specialist with 15+ years of experience. Oracle ACE Director.
co-founder of performing databases.
Your data efficiency experts.
