Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12952: The request exceeds the maximum allowed database size of 4 GB

725549Nov 9 2010 — edited Nov 15 2010
Hi,

Recently, I've been getting the "ORA-12952: The request exceeds the maximum allowed database size of 4 GB" error from time to time on my Oracle XE. Most of the time, the database works perfect, no problems whatsoever. But then there is the occasional "ORA-12952: The request exceeds the maximum allowed database size of 4 GB" which worries me of course.
Especially because I have no clue where it comes from. There should be plenty of space left.
I've been trying dozens of suggestions from this forum, without any luck.
Does anyone know what causes the occasional ORA-12952 errors?
Thanks

SQL> select nvl(b.tablespace_name, nvl(a.tablespace_name,'UNKNOWN')) tablespace_name, kbytes_alloc
kbytes, kbytes_alloc-nvl(kbytes_free,0) size_alloc_bytes, round(((kbytes_alloc-nvl(kbytes_free,0))/
kbytes_alloc)*200) sed_chart, to_char(((kbytes_alloc-nvl(kbytes_free,0))/ kbytes_alloc)*100,
'999G999G999G999G999G999G990D00') ||'%' used, data_files from ( select sum(bytes)/1024/1024 Kbytes_free,
max(bytes)/1024/1024 largest, tablespace_name from sys.dba_free_space group by tables
pace_name ) a, ( select sum(bytes)/1024/1024 Kbytes_alloc, tablespace_name, count(*) data_files f
rom sys.dba_data_files group by tablespace_name )b where a.tablespace_name (+) = b.tablespace_name;

TABLESPACE_NAME KBYTES SIZE_ALLOC_BYTES SED_CHART USED DATA_FILES
------------------------------ ---------- ---------------- ---------- -------------------------------- ----------
SYSAUX 1240 749,375 121 60,43% 1
USERS 420 383,0625 182 91,21% 1
SYSTEM 3459,875 1360,75 79 39,33% 2
UNDO 275 22,625 16 8,23% 1
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 13 2010
Added on Nov 9 2010
10 comments
2,401 views