[Spacewalk-list] Oracle XE reached 4GB Limit

[Rampersad, Shaun]

-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Sabuj Pattanayek
Sent: 13 October 2010 20:09
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Oracle XE reached 4GB Limit

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?


------------

Looks like you will hit your limit soon. This is my output.
SQL> select sum(bytes)/1024/1024 from dba_data_files;

SUM(BYTES)/1024/1024
--------------------
		5610
SQL> select sum(bytes)/1024/1024 from v$log;

SUM(BYTES)/1024/1024
--------------------
		 100

Regards
Shaun
This e-mail is subject to a disclaimer, available at http://www.rmb.co.za/web/elements.nsf/online/disclaimer-communications.html