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

_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list

Reply via email to