Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Collaboration Suite Archived Forums
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: May 1, 2008 2:22 PM by
Checking overall size of all mailboxes
May 1, 2008 6: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 2: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.