Re: how many database we have

Brian Peasland wrote:

>
> > and about controlfile size I want to know the size of controlfile in
> > bytes used right now.
>
> SELECT SUM(record_size) FROM v$controlfile_record_section;
>

Maybe
select sum(record_size*records_used) from v$controlfile_record_section;

But that seems low still compared to the size of my controlfile. And lower still if you use last_index - first_index instead of records_used. I'm not sure any of this is useful.

jg

--
@home.com is bogus.
http://www.anomalies-unlimited.com/Odd_Pics.html