RE: Determinants of control file
All right, Here is the complete query to get the information from the control file. select decode (indx, 3,'MAXLOGFILES',4,'MAXDATAFILES',2,'MAXINSTANCES',9,'MAXLOGHISTORY ') , rsnum from x$kccrs where indx in (3,4,2,9) union all select 'MAXLOGMEMBERS ',dimlm from x$kccdi / Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA i2 technologies www.i2.com Riyaj Shamsudeen 12/03/01 09:46 AM To: [EMAIL PROTECTED] cc: Subject: RE: Determinants of control fileLink Hi v$controlfile_record_section is based on the fixed table x$kccrs. This does provide values for all the columns except maxlogmembers. Here is the query to pull the information.. select decode (indx, 3,'MAXLOGFILES',4,'MAXDATAFILES',2,'MAXINSTANCES',9,'MAXLOGHISTORY') , rsnum from x$kccrs where indx in (3,4,2,9) / DECODE(INDX,3 RSNUM - -- MAXINSTANCES 8 MAXLOGFILES 32 MAXDATAFILES 1022 MAXLOGHISTORY 907 which is matching with my controlfile dump. CREATE CONTROLFILE REUSE DATABASE "mydb" NORESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 1022 MAXINSTANCES 8 MAXLOGHISTORY 907 I am not sure where maxlogmembers is stored. I will do some more digging to find that.. Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA i2 technologies www.i2.com Nirmal Kumar Muthu Kumaran <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/01/01 08:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Determinants of control file No. i already checked the view v$control_record_section, This view does not provide any information regarding determinants of controlfile like MAXDATAFILES, MAXLOGFILES, etc Nirmal. -Original Message- t size=1 face="Arial">K Gopalakrishnan [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 11:27 PM To: Multiple recipients of list ORACLE-L oman"> RE: Determinants of control file Other than dumping/ tracing the control file, you can find the required details in the dynamic view V$controlfile_record_section. This view has all the information you want Best Regards, K Gopalakrishnan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tatireddy, Shrinivas (MED, Keane) Sent: Thursday, November 29, 2001 3:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: Determinants of control file Hi Nirmal, Use alter database backup controlfile to trace; You can find these details in the trace file, that will be dumped to your udump destination. HTH Srinivas. -Original Message- From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 7:52 AM To: Multiple recipients of list ORACLE-L Subject: Determinants of control file Hi all, The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc., But after creation of control files, where should i get details about these parameter values?... i checked in v$controlfile and v$database... i didn't get enough info on it. And i found controlfile_sequence# column i found in v$database view. I multiplexed the control files. Where will i get the sequence# of other control files then... Nirmal,
RE: Determinants of control file
Hi v$controlfile_record_section is based on the fixed table x$kccrs. This does provide values for all the columns except maxlogmembers. Here is the query to pull the information.. select decode (indx, 3,'MAXLOGFILES',4,'MAXDATAFILES',2,'MAXINSTANCES',9,'MAXLOGHISTORY') , rsnum from x$kccrs where indx in (3,4,2,9) / DECODE(INDX,3 RSNUM - -- MAXINSTANCES 8 MAXLOGFILES 32 MAXDATAFILES 1022 MAXLOGHISTORY 907 which is matching with my controlfile dump. CREATE CONTROLFILE REUSE DATABASE "mydb" NORESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 1022 MAXINSTANCES 8 MAXLOGHISTORY 907 I am not sure where maxlogmembers is stored. I will do some more digging to find that.. Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA i2 technologies www.i2.com Nirmal Kumar Muthu Kumaran <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/01/01 08:25 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Determinants of control file No. i already checked the view v$control_record_section, This view does not provide any information regarding determinants of controlfile like MAXDATAFILES, MAXLOGFILES, etc Nirmal. -Original Message- t size=1 face="Arial">K Gopalakrishnan [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 11:27 PM To: Multiple recipients of list ORACLE-L oman"> RE: Determinants of control file Other than dumping/ tracing the control file, you can find the required details in the dynamic view V$controlfile_record_section. This view has all the information you want Best Regards, K Gopalakrishnan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tatireddy, Shrinivas (MED, Keane) Sent: Thursday, November 29, 2001 3:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: Determinants of control file Hi Nirmal, Use alter database backup controlfile to trace; You can find these details in the trace file, that will be dumped to your udump destination. HTH Srinivas. -Original Message- From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 7:52 AM To: Multiple recipients of list ORACLE-L Subject: Determinants of control file Hi all, The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc., But after creation of control files, where should i get details about these parameter values?... i checked in v$controlfile and v$database... i didn't get enough info on it. And i found controlfile_sequence# column i found in v$database view. I multiplexed the control files. Where will i get the sequence# of other control files then... Nirmal,
RE: Determinants of control file
Title: RE: Determinants of control file No. i already checked the view v$control_record_section, This view does not provide any information regarding determinants of controlfile like MAXDATAFILES, MAXLOGFILES, etc Nirmal. -Original Message- From: K Gopalakrishnan [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 11:27 PM To: Multiple recipients of list ORACLE-L Subject: RE: Determinants of control file Other than dumping/ tracing the control file, you can find the required details in the dynamic view V$controlfile_record_section. This view has all the information you want Best Regards, K Gopalakrishnan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tatireddy, Shrinivas (MED, Keane) Sent: Thursday, November 29, 2001 3:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: Determinants of control file Hi Nirmal, Use alter database backup controlfile to trace; You can find these details in the trace file, that will be dumped to your udump destination. HTH Srinivas. -Original Message- From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 7:52 AM To: Multiple recipients of list ORACLE-L Subject: Determinants of control file Hi all, The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc., But after creation of control files, where should i get details about these parameter values?... i checked in v$controlfile and v$database... i didn't get enough info on it. And i found controlfile_sequence# column i found in v$database view. I multiplexed the control files. Where will i get the sequence# of other control files then... Nirmal,
RE: Determinants of control file
Title: Determinants of control file Other than dumping/ tracing the control file, you can find the required details in the dynamic view V$controlfile_record_section. This view has all the information you want Best Regards, K Gopalakrishnan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tatireddy, Shrinivas (MED, Keane) Sent: Thursday, November 29, 2001 3:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: Determinants of control file Hi Nirmal, Use alter database backup controlfile to trace; You can find these details in the trace file, that will be dumped to your udump destination. HTH Srinivas. -Original Message- From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 7:52 AM To: Multiple recipients of list ORACLE-L Subject: Determinants of control file Hi all, The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc., But after creation of control files, where should i get details about these parameter values?... i checked in v$controlfile and v$database... i didn't get enough info on it. And i found controlfile_sequence# column i found in v$database view. I multiplexed the control files. Where will i get the sequence# of other control files then... Nirmal,
RE: Determinants of control file
Title: Determinants of control file Hi Nirmal, Use alter database backup controlfile to trace; You can find these details in the trace file, that will be dumped to your udump destination. HTH Srinivas. -Original Message-From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 29, 2001 7:52 AMTo: Multiple recipients of list ORACLE-LSubject: Determinants of control file Hi all, The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc., But after creation of control files, where should i get details about these parameter values?... i checked in v$controlfile and v$database... i didn't get enough info on it. And i found controlfile_sequence# column i found in v$database view. I multiplexed the control files. Where will i get the sequence# of other control files then... Nirmal,