DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: control files

Threaded View

  1. #1
    Join Date
    Apr 2003
    Posts
    46

    control files

    hi

    when we create database through dbca by default it creates 3 control files. do all these control files contain the same data or are they different.because when i startup my database with only one file it starts my db but does not allow me to work further.

    another query regarding controfiles is that through oem if u check :
    database/storage/controlfile and in the right pane the record section tab
    it gives some details regarding record size, record total. for eg.
    database record size is 192, record total is 1 , records used is 1.
    what does these parameters signify.

    another doubt if i were to view the contents of controlfile , how would it be possible.

    another query, how would i reduce the size of my control files , when i went through the manuals the maxlogfiles, maxlogmembers etc. influence in the size of control files. and there is no other way to give size for my control files. i want to compare the physical size of my control files with these parameters that we provide while creating database.is it possible. how.


    thanks
    ser
    Last edited by ser; 05-21-2003 at 05:18 AM.

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