martes, 21 de diciembre de 2010

COMO VER EL ESPACIO LIBRE DE LOS TABLESPACES DE ORACLE


Para ver el espacio libre que queda en un tablespace tenemos que mirar en la tabla dba_free_space
SELECT tablespace_name, ROUND(sum(bytes)/1024/1024,0) FROM dba_free_space WHERE tablespace_name NOT LIKE 'TEMP%' GROUP BY tablespace_name; 
Con esta consulta obentemos el nombre del tablespace y el espacio en Megas libre Para ver el espacio total en un tablespace tenemos que mirar en la tabla dba_data_files
SELECT tablespace_name, round(sum(BYTES/1024/1024),0) FROM dba_data_files b WHERE tablespace_name NOT LIKE 'TEMP%' GROUP BY b.tablespace_name;
Con esta consulta obentemos el nombre del tablespace y el espacio total en Megas que puede llegar a tener
Fuente y mas detalles:

1 comentario:

  1. My eighth profitable technique is, apparently, rare search out|to search out}. However, it's the technique I used to get to Seven Stars top-tier status in six weeks over a few dozen 3-hour classes. It didn’t assist me win that car – that was the second 메리트카지노 technique – but I was quite happy with it. Another excellent resource is Robin Aubin from NE Time Gambling, who has been finding out video poker for 20 years. You’ve scrapped together each little bit of profitable odds you'll find.

    ResponderEliminar