locutoriorama

select  name,decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1) Redundancy,REQUIRED_MIRROR_FREE_MB,   (total_mb/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1)) Total_MB,   ((free_mb - REQUIRED_MIRROR_FREE_MB)/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1)) Free_MB,   ((free_mb/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1))/(total_mb/decode(type,'NORMAL',2,'HIGH',3,'EXTERN',1)))*100 "%Free" from v$asm_diskgroup;

Falcon BMS 4.33 download

Oracle Database 12c: INTERACTIVE QUICK REFERENCE

En este script utilizo la vista dba_temp_free_space que está disponible a partir de la versión 11g de Oracle: SELECT a . tablespace_name , a . asignado , b . libre , c . contents , c . status FROM ( SELECT tablespace_name , SUM ( bytes )/ 1024 / 1024 AS asignado FROM dba_Data_files GROUP BY tablespace_name ) a , ( SELECT tablespace_name , SUM ( bytes )/ 1024 / 1024 AS libre FROM dba_free_space GROUP BY tablespace_name ) b , ( SELECT tablespace_name , contents , status FROM dba_tablespaces ) c WHERE a . tablespace_name = b . tablespace_name (+) AND a . tablespace_name = c . tablespace_name UNION ALL SELECT d . TABLESPACE_NAME , d . ALLOCATED_SPACE / 1024 / 1024 , d . FREE_SPACE / 1024 / 1024 , e . contents , e . status FROM dba_temp_free_space d , dba_tablespaces e WHERE d . tablespace_name = e . tablespace_name AND contents = 'TEMPORARY' ; Para la versión

AWR Formatter, de Tyler Muth (https://tylermuth.wordpress.com/2011/04/20/awr-formatter/) y que se puede bajar de : http://dl.dropbox.com/u/4131944/AWR-Format/AWR-Format.crx Tiene problemas para ejecutarse en Croome, pero en el navegador Opera funciona! Solo hay que configurarlo así en las extensiones: