Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Maxlogfiles, maxlogmembers, maxdatafiles... etc.
Hello
I am having trouble locating the correct V$ view (If there is one...), to tell me the following controlfile creation information:
MAXLOGFILES
MAXLOGMEMBERS
MAXDATAFILES
MAXINSTANCES
MAXLOGHISTORY
I know I could execute an 'alter database backup controlfile to trace;'
command, and look at the trace file contents, but I needed to query this in a
PL/SQL block of code. Can someone point me to the correct view(s)?
Thanks!
Tom Tyson
![]() |
![]() |