Gerenciamento de Tablespace SEM espaço.

Olá,

Esse script irá lhe mostrar todas as TABLESPACES do banco de dados que está com 0% livre para crescimento.

SET SERVEROUTPUT ONSET PAGESIZE 1000SET LINESIZE 255SET FEEDBACK OFFPROMPTPROMPT Tablespace perto de 0% freePROMPT ***************************SELECT a.tablespace_name, b.size_kb, a.free_kb, Trunc((a.free_kb/b.size_kb) 100) "LIVRE_%"FROM (SELECT tablespace_name, Trunc(Sum(bytes)/1024) free_kb FROM dba_free_space GROUP BY tablespace_name) a, (SELECT tablespace_name, Trunc(Sum(bytes)/1024) size_kb FROM dba_data_files GROUP BY tablespace_name) bWHERE a.tablespace_name = b.tablespace_nameAND Round((a.free_kb/b.size_kb) 100,2) < 10/PROMPTSET FEEDBACK ONSET PAGESIZE 18

Abraços, http://forum.imasters.com.br/public/style_emoticons/default/shifty.gif