how to locate LOBS file for each module?
hi there,
After running the SQL, I have found there are many files at these top 6 areas. Please advise how I can know they are related to which module because program tag is null or even which PO PR.
I aim to ask user to remove them to trim down the DB size. Thanks
SQL
select program_name, FILE_CONTENT_TYPE, substr(program_tag, 1, 10) as program_tag, count(1)
From fnd_lobs
where program_name not in ('FND_HELP')
and program_name = 'FNDATTCH'
group by program_name, FILE_CONTENT_TYPE, substr(program_tag, 1, 10)
order by 4 desc, 1, 3
;
| |||
| PROGRAM_NAME |
| FILE_CONTENT_TYPE |
---|