[Spacewalk-list] Spacewalk + Oracle XE =>ORA-12952: The request exceeds the maximum allowed database size of 4 GB

[David Nutter]

On Tue, Dec 01, 2009 at 11:38:27AM +0100, Michael Mraka wrote:
*snip*

> Sometimes things are much simply then they seem; you've forgotten about indexes.
> 
> oracle$ sqlplus / as sysdba
> SQL> select trunc(sum(bytes)/1024/1024, 2) MB from dba_segments where owner = 'SPACEWALK'; 

Aha, that's much better. Thanks!

Replacing the (non-working since it depends on db-control)
check-oracle-space-usage.sh crontab from spacewalk-dobby with a call
like this might be useful for spacewalk.

Regards,

-- 
David Nutter  				Tel: +44 (0)131 650 4888
BioSS, JCMB, King's Buildings, Mayfield Rd, EH9 3JZ. Scotland, UK 

Biomathematics and Statistics Scotland (BioSS) is formally part of The
Scottish Crop Research Institute (SCRI), a registered Scottish charity
No. SC006662