[Spacewalk-list] Oracle XE reached 4GB Limit

[Michael Mraka]

Sabuj Pattanayek wrote:
% Hi,
% 
% SQL> select sum(bytes)/1024/1024 from dba_data_files;
% 
% SUM(BYTES)/1024/1024
% --------------------
%                 5530
% 
% SQL> select sum(bytes)/1024/1024 from v$log;
% 
% SUM(BYTES)/1024/1024
% --------------------
%                  100
% 
% For me it's showing that I broke the 4GB limit a long time ago. Also :
% 
% # du -sh oradata/
% 5.6G    oradata/
% 
% 
% I don't seem to be having problems kickstarting new machines, updating
% machines, or sync'ing new packages into the repo. Or am I determining
% the size of the XE db incorrectly?

The exact text that is printed on the web page under
Administration >> Storage

"Oracle Database Express Edition is designed to provide users with 4 GB
of user data storage. Physical storage is limited to a database size of
5 GB of total overall size. This includes the system tablespace, but
excludes temporary and rollback. You can compact storage by clicking
Compact Storage in the Tasks list."


Regards,

--
Michael Mráka
Satellite Engineering, Red Hat