Our DBA is asking about a LOB in our production F98950 table. The interesting thing about this 28GB LOB is it was created on July 13th, a week before we actually upgraded production. Our QA Central Objects were copied to the production database the week prior to our 8.9 Go-Live...so I can't say the users logging in created the extra large production LOB, but I have a hunch the file is growing and has something to do with the large number of users we support. See comments from Oracle DBA below:
I was noticing a significant size difference between QA9 and PD9 tablespaces. PD9T is 37GB where QA9T is about 13GB. I've discovered a LOB Segment stored in production PD9.SYS_LOB0000356740C00009$$ 28790 MBYTES
I haven't worked much with lobs,blob, etc. I do not know what is in the lob. It was created July 13, 2004 at 22:57.
I can research to try to view the lob's contents but thought I'd check with you to see if you had any insight. This lob doesn't appear to exist in the other environments.
Ok, it looks like the blob is associated with table f98950 - column name UOBINDTA. See if you can find anything out about it.