[Deploying Sakai] Finding large files and their respective owners

Leon Kolchinsky lkolchin at gmail.com
Tue Oct 26 18:59:55 PDT 2010

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
Users storing huge files in the DB and this is not a good practice.

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

More information about the production mailing list