Hi,
I have installed "myOra" utilities on my OracleExpresEdition10 and i could view
USER ANONYMOUS 99% process
USER PMON 75% process
TableSpace USER 100% used
AutoExtensible is true on my tableSpace, but FREEMB seems low
What do you suggest me ?
Regards
Phil
SELECT b.tablespace_name,
tbs_size SizeMb,
a.free_space FreeMb
FROM
(SELECT tablespace_name,
ROUND(SUM(bytes)/1024/1024 ,2) AS free_space
FROM dba_free_space
GROUP BY tablespace_name
) a,
(SELECT tablespace_name,
SUM(bytes)/1024/1024 AS tbs_size
FROM dba_data_files
GROUP BY tablespace_name
) b
WHERE a.tablespace_name(+)=b.tablespace_name;
TABLESPACENAME SIZEMB FREEMB
SYSAUX 1070 20,94
USERS 570 8,69
SYSTEM 430 9,88
UNDO 360 340,75
APEX_1243207222091854 1000,0625 1000