Boa tarde, Dá uma olhada nas notas 1292724.1 e 1055547.1 e veja se lhe ajudam.
Att Mufalani Obter o Outlook para iOS<https://aka.ms/o0ukef> ________________________________ From: oracle_br@yahoogrupos.com.br <oracle_br@yahoogrupos.com.br> on behalf of 'Ednilson Silva' ednilson.si...@jbs.com.br [oracle_br] <oracle_br@yahoogrupos.com.br> Sent: Thursday, August 31, 2017 2:25:48 PM To: oracle_br@yahoogrupos.com.br Subject: [oracle_br] Recuperar espaço livre na SYSAUX Boa Tarde Pessoal, - Red Hat Enterprise Linux Server release 6.3 - Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production Existe alguma forma de recuperar esse espaço livre da tablespace SYSAUX? SQL> SELECT B.tablespace_name, tbs_size SizeMb, A.free_space FreeMb FROM (SELECT tablespace_name, ROUND(SUM(bytes) / 1024 / 1024) as free_space 2 3 4 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 5 WHERE A.tablespace_name(+) = B.tablespace_name order by FreeMb desc 6 7 8 9 10 11 / TABLESPACE_NAME SIZEMB FREEMB ------------------------------ ---------- ---------- SYSAUX 111759 108748 DOCXINDEX 4254 211 DOCCONTROL 3209 191 UNDOTBS1 222 179 SYSTEM 879 18 DOCXLOGACESSO 10 9 DOCXLONG 981 1 DOCXRELAT 5 0 USERS 2 0 10 rows selected. Grato, Ednilson Silva
