-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|