ORA-12952: The request exceeds the maximum allowed database size of 4 GB
725549Nov 9 2010 — edited Nov 15 2010Hi,
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