29 lines
543 B
SQL
29 lines
543 B
SQL
@@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
|