@@header

/*
*
*  Author     : Vishal Gupta
*  Purpose    : Display controlfile record sections
*  Parameters : 
*
*  Revision History:
*  ===================
*  Date       Author        Description
*  ---------  ------------  -----------------------------------------
*  22-Jul-16  Vishal Gupta  Created
*
*/


SELECT type
    , (record_size * records_total) TotalSize
    , (record_size * records_used)  UsedSize 
    , a.record_size
    , a.records_total
    , a.records_used
FROM V$CONTROLFILE_RECORD_SECTION a 
order by type ;


@@footer