Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
Oracle Community (OTN)
Collaboration Suite Archived Forums
This discussion is archived
on May 1, 2008 7:22 PM by 637005
Checking overall size of all mailboxes
May 1, 2008 11:49 AM
We're about to start on a drive to improve how our users use email. Specifically we want to encourage them to delete irrelevant and outdated emails.
As part of this, we'd like to have some kind of measure such as: All OCS accounts currently use x amount of storage
Then, on a frequent basis we can measure the reduction in this figure so we can report back on progress.
Is this possible?
This content has been marked as final.
Show 1 reply
Re: Checking overall size of all mailboxes
May 1, 2008 7:22 PM
in response to
It's pretty simple. Try the following:
select sum(msg_size) from es_header;
Keep in mind you wouldn't want to calculate msg_size from es_instance since that would give you skewed results.