D.D. View for Control File Parameters?

[JDoyle]

Is there a data dictionary view which will allow me to see the contents of the control file?
The only way I can find is to dump to trace, which is o.k., but I want to be thorough.
Thanks.

[Halo]

There isn't a DDV for that.

[marist89]

system@dev815nt.us> l
1* select * from v$controlfile
system@dev815nt.us> /

STATUS NAME
------- ----------------------------------------
D:\ORACLE\ORADATA\DEV815NT\CONTROL01.CTL
D:\ORACLE\ORADATA\DEV815NT\CONTROL02.CTL

[JDoyle]

I'm after a view, or other method (I recall reading that there is some trick) to get the parameters
such as maxlogfiles, etc.

[LND]

One way:
alter database backup controlfile to trace

The other way: to query views, like v$dbfile, v$log, v$logfile,
props$. But where is MAXLOGFiLES???

[jmodic]

There *is* a V$ view for that, at least in 8.0 and above. Take a look at V$CONTROLFILE_RECORD_SECTION. For example, the following will tell you the current settings of MAXLOGFILES and MAXDATAFILES in the controlfile and how much of those are allready used:

SELECT type, records_total AS max_limit, records_used AS allready_in_use
FROM v$controlfile_record_section
WHERE type IN ('REDO LOG', 'DATAFILE');

HTH,

[marist89]

I am sometimes amazed at how much there actually is to know about Oracle.

[sreddy]

Jeff, No wonder ! you say that

Oracle Develpment is thousands of professionals effort. Not easy to consolidate, memorize and recollect as one.