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.
There isn't a DDV for that.
1* select * from v$controlfile
I'm after a view, or other method (I recall reading that there is some trick) to get the parameters
such as maxlogfiles, etc.
alter database backup controlfile to trace
The other way: to query views, like v$dbfile, v$log, v$logfile,
props$. But where is MAXLOGFiLES???
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
WHERE type IN ('REDO LOG', 'DATAFILE');
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
I am sometimes amazed at how much there actually is to know about Oracle.
Jeff, No wonder ! you say that
Oracle Develpment is thousands of professionals effort. Not easy to consolidate, memorize and recollect as one.
Click Here to Expand Forum to Full Width