What are these Text index partition objects for: $L, $T, MI (table), MI (table partition) ?
11.2.0.3 EE Linux x64
We have recently noticed 4 new objects on a few of our Text index partitions named like this:
DR#MYIDX9999MI partition P1
DR#MYIDX9999MI table
DR#MYIDX9999$L table
DR#MYIDX9999$T trigger
We've not seen these before and there are 100s of other partitions that do not have them. The only change that we're aware of is recently starting to run optimize rebuilds on partitions, and I'm wondering if these are just left over from jobs that were hung and killed.
1