| SIze of Control FIle [message #131037] |
Thu, 04 August 2005 00:59  |
hafeez_splendid
Messages: 15
Registered: June 2005
Location: india
|
Junior Member |
|
|
hi all,
I have two doubts regarding the size of control file.
1. I know that the size of control file depends on MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, and MAXINSTANCES .I also know that the size of control file will increase automatically by adding more file than this .I have oracle 8i on windows NT .
I watn to know , how this different parameters (MAXDATAFILES,MAXLOGFILES,MAXLOGMEMBERS etc) effect the size of control file.In the sense ,what is the contribution of each parameter for the size of control file . I want this to estimate the size of control file depending different number of different files .
2.I found that , the maximum size of control file in windows is 20000 blocks . Can anyone tell me what is the maximum size of control file in UNIX.
|
|
|
|
|
|
| Re: SIze of Control FIle [message #131103 is a reply to message #131037] |
Thu, 04 August 2005 06:56  |
hafeez_splendid
Messages: 15
Registered: June 2005
Location: india
|
Junior Member |
|
|
hi tarun,
i did a exhaustive search in the document but to my surprise, i did not find anywhere anything related to this.
I think we have to take somewhat lesser value then the maximum size of control file in sizing of the disk .
expecting your views
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
