D.D. View for Control File Parameters?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: D.D. View for Control File Parameters?

  1. #1
    Join Date
    Oct 2000
    Posts
    80
    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.

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    There isn't a DDV for that.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Oct 2000
    Posts
    80
    I'm after a view, or other method (I recall reading that there is some trick) to get the parameters
    such as maxlogfiles, etc.

  5. #5
    Join Date
    Nov 2000
    Posts
    212

    Talking

    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???

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I am sometimes amazed at how much there actually is to know about Oracle.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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
  •  



Click Here to Expand Forum to Full Width