Thanks. V$CONTROLFILE_RECORD_SECTION provides the value for
MAXLOGFILES (type=REDO LOG), MAXDATAFILES (type=DATAFILE) &
MAXLOGHISTORY (type=LOG HISTORY), but can't seem to find the value for
MAXLOGMEMBERS & MAXINSTANCES. Any idea on how to retrieve them?
"Anton Buijs" <remove_aammbuijs_at_xs4all.nl> wrote in message news:<3efc91f6$0$49108$e4fe514c_at_news.xs4all.nl>...
> Jeffrey Yee <jeffyee_at_hotmail.com> schreef in berichtnieuws
> ec4cec95.0306270208.6c5739e8_at_posting.google.com...
> | Hi,
> |
> | I'm wondering if there is a way for me to query for the maxlogfiles,
> | maxlogmembers, maxdatafiles, maxinstances & maxloghistory value? At
> | the meantime, I get these values through the trace file generated by
> | 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE'. But this is very
> | inconvenient, if I have many databases to manage.
> |
> | Please advice. Thank you.
> |
> |
> | Best Regards,
> | Jeffrey Yee
>
> Query V$CONTROLFILE_RECORD_SECTION. You will make it from there.
> Not you question but I want to point you to an interesting script
> controlfile_size.sql that can be found at
> http://www.ixora.com.au/scripts/misc.htm (it's where I found out about this
> V$-view).
> It can calculate the size of the controlfile. This enables you to forecast
> its size when you want to vary those things like maxloghistory.
Received on Sun Jun 29 2003 - 21:31:15 CDT
