[Deploying Sakai] Finding large files and their respective owners

[Leon Kolchinsky]

Hello All,

We're looking for a way to find large files (let's say >1GB) stored in our
Sakai 2.5.4 DB (Oracle).
Can someone provide me with SQL query I could run to find a list of those
files and their respective owners (users) which uploaded those files into
our Sakai instance.

We're currently storing all content in the DB ant it's starting to be really
edgy.
Users storing huge files in the DB and this is not a good practice.

Thanks,
Leon
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20101027/e699d3b2/attachment.html