-
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.
-
There isn't a DDV for that.
-
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
Jeff Hunter
-
I'm after a view, or other method (I recall reading that there is some trick) to get the parameters
such as maxlogfiles, etc.
-
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???
-
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,
Jurij Modic
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 Hunter
-
Jeff, No wonder ! you say that
Oracle Develpment is thousands of professionals effort. Not easy to consolidate, memorize and recollect as one.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|