David Nutter wrote: % > BTW, Oracle XE is limited to 4GB of disk space and Spacewalk only uses <2GB: % > % > SELECT SUM((blocks*8)/1024) FROM all_tables WHERE owner = 'SPACEWALK'; % > % > SUM((BLOCKS*8)/1024) % > -------------------- % > 1840.25781 % > % > We're investigating when Oracle spents 4GB of disk space, and if there's % > no solution we will purchase an Oracle licence, thanks! % % I was wondering about space usage as well and after a bit of googling % found this: % % http://www.dba-oracle.com/t_script_oracle_table_size.htm % % It seems that Oracle has several different concepts of size, all % rather confusing. For this reason I use the space report in Oracle's % web interface rather than using SQLplus. Presumably XE thinks it is % using much more space than your block count above - possibly it counts % the redo logs and so forth in the overall space count.
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'; -- Michael Mráka Satellite Engineering, Red Hat _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
